Debian Codegraph @

mysql-test/suite/rpl/t/rpl_start_alter_3.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_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
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 set global gtid_strict_mode=1;
22
23
24 --connection slave
25 --source include/stop_slave.inc
26 SET GLOBAL slave_parallel_threads=4;
27 set global slave_parallel_mode=optimistic;
28 change master to master_use_gtid=slave_pos;
29 --source include/start_slave.inc
30
31 --echo # Parallel Slave
32 --connection master
33 --let $master_server= "master"
34 --let $domain_1=0
35 --let $domain_2=0
36 --let $M_port= $MASTER_MYPORT
37 --let $S_port= $SLAVE_MYPORT
38 --let $sync_slave=1
39 --source include/start_alter_include.inc
40 --connection master
41 --source include/save_master_gtid.inc
42
43 --connection slave
44 --source include/sync_with_master_gtid.inc
45
46 --echo # cleanup
47 --source include/stop_slave.inc
48 --eval set global slave_parallel_threads = $slave_parallel_threads;
49 --eval set global slave_parallel_mode = $slave_parallel_mode;
50 --eval set global gtid_strict_mode = $gtid_strict_mode;
51 set global gtid_domain_id= 0;
52 --source include/start_slave.inc
53
54 --connection master
55 --eval set global binlog_alter_two_phase=$binlog_alter_two_phase;
56 --source include/rpl_end.inc