Debian Codegraph @

mysql-test/suite/rpl/t/rpl_xa_xplugin.test

raw
1 ##############################################################################
2 # This test checks the basic functionality of replication with Xplugin setup.
3 #
4 # NOTE : All queries will run through mysqlx plugin using MYSQLXTEST --ssl-mode=REQUIRED.
5 #
6 # Steps involved in this test :
7 # 0. This test requires 2 servers.
8 # 1. Set up master and slave servers.
9 # 2. Start the slave server.
10 # 3. Perform ddl and dml operations on master and slave servers.
11 # a) master : Create table T1 and perform ddl on T1.
12 # b) slave : Create table T2 and perform ddl on T1 & T2.
13 # 4. Assert for values on on tables from slave server.
14 # 5. Stop slave through mysqlx.
15 # 6. uninstall mysqlx plugin on both master and slave servers.
16 # 7. clean-up
17 ##############################################################################
18
19 --source include/have_mysqlx_plugin.inc
20
21 --let $rpl_skip_start_slave= 1
22 --source include/master-slave.inc
23
24 CALL mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
25
26 # Install Mysqlx plugin on both master and slave servers.
27
28 --source include/rpl_connection_master.inc
29 --source include/xplugin_wait_for_interfaces.inc
30
31 --source include/rpl_connection_slave.inc
32 --source include/xplugin_wait_for_interfaces.inc
33
34 # File for starting slave through X-protocol
35
36 --write_file $MYSQL_TMP_DIR/start_slave.tmp
37 -->sql
38 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_USER= 'root';
39 START SLAVE;
40 -->endsql
41 EOF
42
43 # Starting the slave through mysqlx
44 --echo Starting the slave server
45 --exec $MYSQLXTEST --ssl-mode=REQUIRED -u root --port=$SLAVE_X_MYPORT --file=$MYSQL_TMP_DIR/start_slave.tmp 2>&1
46
47 # Temp file for performing ddl and dml on master
48
49 --source include/rpl_connection_master.inc
50 --write_file $MYSQL_TMP_DIR/ddl_dml_on_master.tmp
51 -->sql
52 USE test;
53 CREATE TABLE T1 (C1 INT PRIMARY KEY, C2 INT );
54
55 XA START 'xstatement1';
56 INSERT INTO T1 VALUES (1,12);
57 INSERT INTO T1 VALUES (2,1234);
58 INSERT INTO T1 VALUES (3,98765);
59 UPDATE T1 SET C2 = C2 - 10;
60 XA END 'xstatement1';
61 XA PREPARE 'xstatement1';
62 XA COMMIT 'xstatement1';
63
64 DELETE FROM T1 WHERE C2 = 0;
65 -->endsql
66 EOF
67
68 --disable_result_log
69 --exec $MYSQLXTEST --ssl-mode=REQUIRED -u root --port=$MASTER_X_MYPORT --file=$MYSQL_TMP_DIR/ddl_dml_on_master.tmp 2>&1
70 --enable_result_log
71
72 # Wait Until slave is in sync with master
73
74 --source include/sync_slave_sql_with_master.inc
75
76 # Temp file for performing ddl and dml on slave
77
78 --write_file $MYSQL_TMP_DIR/ddl_dml_on_slave.tmp
79 -->sql
80 USE test;
81 CREATE TABLE T2 (C1 CHAR(20) PRIMARY KEY, C2 INT );
82 INSERT INTO T2 VALUES ('ABC',23);
83 UPDATE T2 SET C2 = C2 + 27;
84 INSERT INTO T1 VALUES (4,34);
85 INSERT INTO T2 VALUES ('ABCDEF',23);
86 INSERT INTO T1 VALUES (5,1234);
87 INSERT INTO T2 VALUES ('ABCDEFGHIJ',23);
88 DELETE FROM T2 WHERE C1 = 'ABC';
89 INSERT INTO T2 VALUES ('XYZ',23);
90 UPDATE T2 SET C1 = 'ABC' WHERE C1 ='XYZ';
91 -->endsql
92 EOF
93
94 --exec $MYSQLXTEST --ssl-mode=REQUIRED -u root --port=$SLAVE_X_MYPORT --file=$MYSQL_TMP_DIR/ddl_dml_on_slave.tmp 2>&1
95
96 # Asserts for values on each table.
97
98 --write_file $MYSQL_TMP_DIR/assert.tmp
99
100 -->echo Checking the value on T1
101 -->wait_for 2 SELECT C2 FROM test.T1 WHERE C1=1
102
103 -->echo Checking the value on T2
104 -->wait_for 23 SELECT C2 FROM test.T2 WHERE C1="ABC"
105 EOF
106
107 --exec $MYSQLXTEST --ssl-mode=REQUIRED -u root --port=$SLAVE_X_MYPORT --file=$MYSQL_TMP_DIR/assert.tmp 2>&1
108
109
110 # Temp for drop table on slave.
111 --write_file $MYSQL_TMP_DIR/delete_tables_slave.tmp
112 -->sql
113 USE test;
114 DROP TABLE T2;
115 -->endsql
116 EOF
117
118 # Deleting second table on slave.
119 --exec $MYSQLXTEST --ssl-mode=REQUIRED -u root --port=$SLAVE_X_MYPORT --file=$MYSQL_TMP_DIR/delete_tables_slave.tmp 2>&1
120
121 # Temp for drop table.
122 --write_file $MYSQL_TMP_DIR/delete_tables.tmp
123 -->sql
124 USE test;
125 DROP TABLE T1;
126 -->endsql
127 EOF
128
129 --source include/rpl_connection_master.inc
130 # Deleting table
131 --exec $MYSQLXTEST --ssl-mode=REQUIRED -u root --port=$MASTER_X_MYPORT --file=$MYSQL_TMP_DIR/delete_tables.tmp 2>&1
132
133 --source include/sync_slave_sql_with_master.inc
134
135 # Creating temp file to stop slave.
136 --write_file $MYSQL_TMP_DIR/stop_slave.tmp
137 -->stmtsql STOP SLAVE;
138 -->recvresult
139 EOF
140
141 # Stopping slave
142 --echo Stopping slave
143 --exec $MYSQLXTEST --ssl-mode=REQUIRED -u root --port=$SLAVE_X_MYPORT --file=$MYSQL_TMP_DIR/stop_slave.tmp 2>&1
144
145
146 --source include/rpl_connection_master.inc
147
148 --source include/rpl_connection_slave.inc
149
150 # clean-up
151 --remove_file $MYSQL_TMP_DIR/start_slave.tmp
152 --remove_file $MYSQL_TMP_DIR/ddl_dml_on_master.tmp
153 --remove_file $MYSQL_TMP_DIR/ddl_dml_on_slave.tmp
154 --remove_file $MYSQL_TMP_DIR/delete_tables.tmp
155 --remove_file $MYSQL_TMP_DIR/delete_tables_slave.tmp
156 --remove_file $MYSQL_TMP_DIR/assert.tmp
157 --remove_file $MYSQL_TMP_DIR/stop_slave.tmp
158
159 --source include/start_slave.inc
160 --source include/rpl_end.inc