Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_perfschema_applier_xa_status_check.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 ####################################################################
7 # Test Case 1: Simple MASTER-SLAVE setup.
8 # Verify that slave displays appropriate XA_STATE in performance
9 # schema table, post XA PREPARE AND XA COMMIT command execution.
10 ####################################################################
11 [connection slave]
12 TRUNCATE TABLE performance_schema.events_transactions_current;
13 ---- Setup ----
14 [connection master]
15 CREATE TABLE t ( f INT) ENGINE=INNODB;
16 ---- XA PREPARE ----
17 XA START 'xatest';
18 INSERT INTO t VALUES (10);
19 XA END 'xatest';
20 XA PREPARE 'xatest';
21 include/sync_slave_sql_with_master.inc
22 # Wait for XA_STATE to become PREPARED on slave
23 # Expecting one prepared transaction
24 XA RECOVER;
25 formatID gtrid_length bqual_length data
26 1 6 0 xatest
27 ---- XA COMMIT ----
28 [connection master]
29 XA COMMIT 'xatest';
30 include/sync_slave_sql_with_master.inc
31 # Wait for XA_STATE to become COMMITTED on slave
32 # Expecting no prepared transactions
33 XA RECOVER;
34 formatID gtrid_length bqual_length data
35 include/diff_tables.inc [master:t,slave:t]
36 [connection master]
37 DROP TABLE t;
38 include/sync_slave_sql_with_master.inc
39 include/rpl_reset.inc
40 ####################################################################
41 # Test Case 2: Enable Multithreaded Slave with replica_parallel_type as
42 # DATABASE. Verify that slave displays appropriate XA_STATE in
43 # performance schema table, post XA PREPARE AND XA COMMIT command
44 # execution.
45 ####################################################################
46 [connection slave]
47 SET @save_replica_parallel_workers=@@global.replica_parallel_workers;
48 SET @replica_parallel_type=@@global.replica_parallel_type;
49 include/stop_slave.inc
50 SET GLOBAL replica_parallel_workers=4;
51 SET GLOBAL replica_parallel_type='DATABASE';
52 include/start_slave.inc
53 [connection slave]
54 TRUNCATE TABLE performance_schema.events_transactions_current;
55 ---- Setup ----
56 [connection master]
57 CREATE TABLE t ( f INT) ENGINE=INNODB;
58 ---- XA PREPARE ----
59 XA START 'xatest';
60 INSERT INTO t VALUES (10);
61 XA END 'xatest';
62 XA PREPARE 'xatest';
63 include/sync_slave_sql_with_master.inc
64 # Wait for XA_STATE to become PREPARED on slave
65 # Expecting one prepared transaction
66 XA RECOVER;
67 formatID gtrid_length bqual_length data
68 1 6 0 xatest
69 ---- XA COMMIT ----
70 [connection master]
71 XA COMMIT 'xatest';
72 include/sync_slave_sql_with_master.inc
73 # Wait for XA_STATE to become COMMITTED on slave
74 # Expecting no prepared transactions
75 XA RECOVER;
76 formatID gtrid_length bqual_length data
77 include/diff_tables.inc [master:t,slave:t]
78 [connection master]
79 DROP TABLE t;
80 include/sync_slave_sql_with_master.inc
81 include/rpl_reset.inc
82 ####################################################################
83 # Test Case 3: Enable Multithreaded Slave with replica_parallel_type as
84 # LOGICAL_CLOCK. Verify that slave displays appropriate XA_STATE in
85 # performance schema table, post XA PREPARE AND XA COMMIT command
86 # execution.
87 ####################################################################
88 include/stop_slave.inc
89 SET GLOBAL replica_parallel_workers=4;
90 SET GLOBAL replica_parallel_type='LOGICAL_CLOCK';
91 include/start_slave.inc
92 [connection slave]
93 TRUNCATE TABLE performance_schema.events_transactions_current;
94 ---- Setup ----
95 [connection master]
96 CREATE TABLE t ( f INT) ENGINE=INNODB;
97 ---- XA PREPARE ----
98 XA START 'xatest';
99 INSERT INTO t VALUES (10);
100 XA END 'xatest';
101 XA PREPARE 'xatest';
102 include/sync_slave_sql_with_master.inc
103 # Wait for XA_STATE to become PREPARED on slave
104 # Expecting one prepared transaction
105 XA RECOVER;
106 formatID gtrid_length bqual_length data
107 1 6 0 xatest
108 ---- XA COMMIT ----
109 [connection master]
110 XA COMMIT 'xatest';
111 include/sync_slave_sql_with_master.inc
112 # Wait for XA_STATE to become COMMITTED on slave
113 # Expecting no prepared transactions
114 XA RECOVER;
115 formatID gtrid_length bqual_length data
116 include/diff_tables.inc [master:t,slave:t]
117 [connection master]
118 DROP TABLE t;
119 include/sync_slave_sql_with_master.inc
120 [connection slave]
121 include/stop_slave.inc
122 set @@global.replica_parallel_workers= @save_replica_parallel_workers;
123 set @@global.replica_parallel_type= @replica_parallel_type;
124 include/start_slave.inc
125 include/rpl_end.inc