Debian Codegraph @

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

raw
1 #
2 # MENT-662 Lag Free Alter On Slave
3 #
4
5 # Start Alter with Parallel Replication, With 2 sources
6 # 2 domain id (From 2 sources)
7 # |Concurrent alters| < |Parallel workers on slave|
8 # |x| denotes number of entities it encloses
9 # And then binary log from slave is replayed to slave again to check if
10 # binlog output is okay.
11 #
12
13 --source include/have_log_bin.inc
14 --source include/have_innodb.inc
15 --source include/have_debug.inc
16 --connect (server_1,127.0.0.1,root,,,$SERVER_MYPORT_1)
17 --connect (server_2,127.0.0.1,root,,,$SERVER_MYPORT_2)
18 --connect (server_3,127.0.0.1,root,,,$SERVER_MYPORT_3)
19
20 --connection server_1
21 SET @save_binlog_alter_two_phase= @@GLOBAL.binlog_alter_two_phase;
22 SET GLOBAL binlog_alter_two_phase = ON;
23 SET binlog_alter_two_phase = ON;
24 --echo # Create table and perform CA and RA
25 CREATE TABLE t1( a INT, b INT) ENGINE=InnoDB;
26 INSERT INTO t1 VALUES(1,1);
27 INSERT INTO t1 VALUES(2,2);
28 --echo # Normal Alter
29 ALTER TABLE t1 ADD COLUMN c INT;
30 --echo # Failed Alter
31 INSERT INTO t1 VALUES(1,1, NULL);
32 --error ER_DUP_ENTRY
33 ALTER TABLE t1 CHANGE a a INT UNIQUE;
34 SHOW CREATE TABLE t1;
35 SELECT @@gtid_binlog_state;
36
37 --echo # apply the binlog
38 let MYSQLD_DATADIR= `select @@datadir;`;
39 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/master_1.sql
40 DROP TABLE t1;
41 --echo # reset the binlog
42 RESET MASTER;
43
44 --echo # execute the binlog
45 --exec $MYSQL --port=$SERVER_MYPORT_1 --host=127.0.0.1 -e "source $MYSQLTEST_VARDIR/tmp/master_1.sql"
46 SELECT @@gtid_binlog_state;
47 --echo # Same as before
48 SHOW CREATE TABLE t1;
49 DROP TABLE t1;
50 --echo # reset the binlog
51 RESET MASTER;
52 RESET SLAVE;
53 remove_file $MYSQLTEST_VARDIR/tmp/master_1.sql;
54
55 --connection server_2
56 SET @save_binlog_alter_two_phase= @@GLOBAL.binlog_alter_two_phase;
57 SET GLOBAL binlog_alter_two_phase = ON;
58
59 --connection server_3
60 SET STATEMENT sql_log_bin=0 FOR
61 CALL mtr.add_suppression("The table mysql.gtid_slave_pos was removed. This change will not take full effect until all SQL threads have been restarted");
62 SET STATEMENT sql_log_bin=0 FOR
63 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
64 SET @save_gtid_strict_mode= @@GLOBAL.gtid_strict_mode;
65 SET @slave_parallel_threads= @@GLOBAL.slave_parallel_threads;
66 SET @slave_parallel_mode= @@GLOBAL.slave_parallel_mode;
67 SET GLOBAL slave_parallel_threads=20;
68 SET GLOBAL slave_parallel_mode=optimistic;
69 SET GLOBAL gtid_strict_mode=1;
70
71 --disable_warnings
72 --disable_query_log
73 --replace_result $SERVER_MYPORT_1 MYPORT_1
74 eval CHANGE MASTER 'm1' TO MASTER_PORT=$SERVER_MYPORT_1, MASTER_HOST='127.0.0.1', MASTER_USER='root', master_ssl_verify_server_cert=0, MASTER_USE_GTID=slave_pos;
75 --replace_result $SERVER_MYPORT_2 MYPORT_2
76 eval CHANGE MASTER 'm2' TO MASTER_PORT=$SERVER_MYPORT_2, MASTER_HOST='127.0.0.1', MASTER_USER='root', master_ssl_verify_server_cert=0, MASTER_USE_GTID=slave_pos;
77 --enable_query_log
78 --enable_warnings
79
80 --connection server_1
81 SET gtid_domain_id= 11;
82 CREATE DATABASE s1;
83 USE s1;
84 --let $domain_1=11
85 --let $domain_2=11
86 --let $M_port= $SERVER_MYPORT_1
87 --let $S_port= $SERVER_MYPORT_3
88 --let $sync_slave=0
89 --let $db_name=s1
90 --source include/start_alter_include.inc
91
92 --connection server_1
93 DROP DATABASE s1;
94 --let $master_pos_1= `SELECT @@gtid_binlog_pos`
95
96 --connection server_2
97 SET gtid_domain_id= 12;
98 CREATE DATABASE s2;
99 USE s2;
100 --let $domain_1=12
101 --let $domain_2=12
102 --let $M_port= $SERVER_MYPORT_2
103 --let $S_port= $SERVER_MYPORT_3
104 --let $sync_slave=0
105 --let $db_name=s2
106 --source include/start_alter_include.inc
107 --connection server_2
108 DROP DATABASE s2;
109 --let $master_pos_2= `SELECT @@gtid_binlog_pos`
110
111 --connection server_3
112 START ALL SLAVES;
113 SET default_master_connection = 'm1';
114 --source include/wait_for_slave_to_start.inc
115 SET default_master_connection = 'm2';
116 --source include/wait_for_slave_to_start.inc
117
118 SET default_master_connection = 'm1';
119 --let $master_pos= $master_pos_1
120 --source include/sync_with_master_gtid.inc
121 SET default_master_connection = 'm2';
122 --let $master_pos= $master_pos_2
123 --source include/sync_with_master_gtid.inc
124
125 --echo # Stop slaves and apply binlog
126 --connection server_3
127 SET default_master_connection = 'm1';
128 --source include/stop_slave.inc
129 SET default_master_connection = 'm2';
130 --source include/stop_slave.inc
131 SET GLOBAL slave_parallel_threads = @slave_parallel_threads;
132 SET GLOBAL slave_parallel_mode = @slave_parallel_mode;
133 SET GLOBAL gtid_strict_mode = @save_gtid_strict_mode;
134 SET GLOBAL gtid_domain_id= 0;
135 SELECT @@gtid_binlog_state;
136
137 let MYSQLD_DATADIR= `select @@datadir;`;
138 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/slave_1.sql
139 --echo # reset the binlog
140 RESET MASTER;
141 --echo # execute the binlog
142 --exec $MYSQL --port=$SERVER_MYPORT_3 --host=127.0.0.1 -e "source $MYSQLTEST_VARDIR/tmp/slave_1.sql"
143 SELECT @@gtid_binlog_state;
144
145 --echo # One more time to simulate S->S case
146 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/slave_2.sql
147 RESET MASTER;
148 --echo # execute the binlog
149 --exec $MYSQL --port=$SERVER_MYPORT_3 --host=127.0.0.1 -e "source $MYSQLTEST_VARDIR/tmp/slave_2.sql"
150 SELECT @@gtid_binlog_state;
151 remove_file $MYSQLTEST_VARDIR/tmp/slave_1.sql;
152 remove_file $MYSQLTEST_VARDIR/tmp/slave_2.sql;
153 RESET MASTER;
154 RESET SLAVE ALL;
155 SET GLOBAL gtid_slave_pos= '';
156
157 --connection server_1
158 SET GLOBAL binlog_alter_two_phase=@save_binlog_alter_two_phase;
159 SET GLOBAL gtid_domain_id= 0;
160 RESET MASTER;
161 --connection server_2
162 SET GLOBAL gtid_domain_id= 0;
163 SET GLOBAL binlog_alter_two_phase=@save_binlog_alter_two_phase;
164 RESET MASTER;
165
166 --disconnect server_1
167 --disconnect server_2
168 --disconnect server_3