Debian Codegraph @

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

raw
1 #
2 # Start Alter with Parallel Replication, With 2 sources
3 # 2 domain id (From 2 sources)
4 # |Concurrent alters| < |Parallel workers on slave|
5 # |x| denotes number of entities it encloses
6 #
7 --source include/have_log_bin.inc
8 --source include/have_innodb.inc
9 --source include/have_debug.inc
10 --connect (server_1,127.0.0.1,root,,,$SERVER_MYPORT_1)
11 --connect (server_2,127.0.0.1,root,,,$SERVER_MYPORT_2)
12 --connect (server_3,127.0.0.1,root,,,$SERVER_MYPORT_3)
13
14 --connection server_1
15 --let $binlog_alter_two_phase= `select @@binlog_alter_two_phase`
16 set global binlog_alter_two_phase = ON;
17 set binlog_alter_two_phase = ON;
18
19 --connection server_2
20 stop slave;
21 set global binlog_alter_two_phase=true;
22
23 --connection server_3
24 SET STATEMENT sql_log_bin=0 FOR
25 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");
26 SET STATEMENT sql_log_bin=0 FOR
27 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
28 --let $gtid_strict_mode= `select @@gtid_strict_mode`
29 --let $slave_parallel_threads= `select @@slave_parallel_threads`
30 --let $slave_parallel_mode= `select @@slave_parallel_mode`
31 SET GLOBAL slave_parallel_threads=20;
32 set global slave_parallel_mode=optimistic;
33 set global gtid_strict_mode=1;
34
35 --disable_warnings
36 --disable_query_log
37 --replace_result $SERVER_MYPORT_1 MYPORT_1
38 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;
39 --replace_result $SERVER_MYPORT_2 MYPORT_2
40 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;
41 --enable_query_log
42 --enable_warnings
43
44 --connection server_1
45 set gtid_domain_id= 11;
46 create database s1;
47 use s1;
48 --let $domain_1=11
49 --let $domain_2=11
50 --let $M_port= $SERVER_MYPORT_1
51 --let $S_port= $SERVER_MYPORT_3
52 --let $sync_slave=0
53 --let $db_name=s1
54 --source include/start_alter_include.inc
55 --connection server_1
56 drop database s1;
57 --let $master_pos_1= `SELECT @@gtid_binlog_pos`
58
59 --connection server_2
60 set gtid_domain_id= 12;
61 create database s2;
62 use s2;
63 --let $domain_1=12
64 --let $domain_2=12
65 --let $M_port= $SERVER_MYPORT_2
66 --let $S_port= $SERVER_MYPORT_3
67 --let $sync_slave=0
68 --let $db_name=s2
69 --source include/start_alter_include.inc
70 --connection server_2
71 drop database s2;
72 --let $master_pos_2= `SELECT @@gtid_binlog_pos`
73
74 --connection server_3
75 start all slaves;
76 set default_master_connection = 'm1';
77 --source include/wait_for_slave_to_start.inc
78 set default_master_connection = 'm2';
79 --source include/wait_for_slave_to_start.inc
80
81 set default_master_connection = 'm1';
82 --let $master_pos= $master_pos_1
83 --source include/sync_with_master_gtid.inc
84 set default_master_connection = 'm2';
85 --let $master_pos= $master_pos_2
86 --source include/sync_with_master_gtid.inc
87
88 --echo # cleanup
89 --connection server_3
90 set default_master_connection = 'm1';
91 --source include/stop_slave.inc
92 set default_master_connection = 'm2';
93 --source include/stop_slave.inc
94 --eval set global slave_parallel_threads = $slave_parallel_threads;
95 --eval set global slave_parallel_mode = $slave_parallel_mode;
96 --eval set global gtid_strict_mode = $gtid_strict_mode;
97 set global gtid_domain_id= 0;
98 reset master;
99 RESET SLAVE ALL;
100 SET GLOBAL gtid_slave_pos= '';
101
102 --connection server_1
103 --eval set global binlog_alter_two_phase=$binlog_alter_two_phase;
104 set global gtid_domain_id= 0;
105 reset master;
106 --connection server_2
107 set global gtid_domain_id= 0;
108 --eval set global binlog_alter_two_phase=$binlog_alter_two_phase;
109 reset master;
110
111 --disconnect server_1
112 --disconnect server_2
113 --disconnect server_3