Debian Codegraph @

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

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