Debian Codegraph @

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