Debian Codegraph @

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

raw
1 #
2 # Start Alter with Parallel Replication
3 # 2 domain id
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/master-slave.inc
10 --source include/have_debug.inc
11 --connection master
12 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
13 --let $binlog_alter_two_phase= `select @@binlog_alter_two_phase`
14 set global binlog_alter_two_phase = ON;
15 set binlog_alter_two_phase = ON;
16 --connection slave
17 --let $gtid_strict_mode= `select @@gtid_strict_mode`
18 --let $slave_parallel_threads= `select @@slave_parallel_threads`
19 --let $slave_parallel_mode= `select @@slave_parallel_mode`
20 set global gtid_strict_mode=1;
21
22 --connection slave
23 --source include/stop_slave.inc
24 SET GLOBAL slave_parallel_threads=4;
25 set global slave_parallel_mode=optimistic;
26 change master to master_use_gtid=slave_pos;
27 --source include/start_slave.inc
28
29 --echo # Parallel Slave
30 --connection master
31 --let $master_server= "master"
32 --let $domain_1=11
33 --let $domain_2=12
34 --let $M_port= $MASTER_MYPORT
35 --let $S_port= $SLAVE_MYPORT
36 --let $sync_slave=1
37 --source include/start_alter_include.inc
38 --connection master
39 --source include/save_master_gtid.inc
40
41 --connection slave
42 --source include/sync_with_master_gtid.inc
43
44 --echo # cleanup
45 --source include/stop_slave.inc
46 --eval set global slave_parallel_threads = $slave_parallel_threads;
47 --eval set global slave_parallel_mode = $slave_parallel_mode;
48 --eval set global gtid_strict_mode = $gtid_strict_mode;
49 set global gtid_domain_id= 0;
50 --source include/start_slave.inc
51
52 --connection master
53 --eval set global binlog_alter_two_phase=$binlog_alter_two_phase;
54 set global gtid_domain_id= 0;
55 --source include/rpl_end.inc