Debian Codegraph @

mysql-test/suite/multi_source/multi_parallel.result

raw
1 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
2 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
3 connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
4 set global slave_parallel_threads=10;
5 change master 'master1' to
6 master_port=MYPORT_1,
7 master_host='127.0.0.1',
8 master_user='root', master_ssl_verify_server_cert=0;
9 change master 'master2' to
10 master_port=MYPORT_2,
11 master_host='127.0.0.1',
12 master_user='root', master_ssl_verify_server_cert=0;
13 start all slaves;
14 set default_master_connection = 'master1';
15 include/wait_for_slave_to_start.inc
16 set default_master_connection = 'master2';
17 include/wait_for_slave_to_start.inc
18 ## Slave status variable
19 set default_master_connection = 'master1';
20 show status like 'slave_running';
21 Variable_name Value
22 Slave_running ON
23 set default_master_connection = 'master2';
24 show status like 'slave_running';
25 Variable_name Value
26 Slave_running ON
27 #master 1
28 connection master1;
29 ##Running CURD operation
30 connection slave;
31 Slave_DDL_Groups= 20;
32 Slave_Non_Transactional_Groups= 20;
33 Slave_Transactional_Groups= 0;
34 #master 2
35 connection master2;
36 ##Running CURD operation
37 connection slave;
38 Slave_DDL_Groups= 20;
39 Slave_Non_Transactional_Groups= 20;
40 Slave_Transactional_Groups= 0;
41 #master 1
42 connection master1;
43 ##Running CURD operation
44 connection slave;
45 Slave_DDL_Groups= 40;
46 Slave_Non_Transactional_Groups= 20;
47 Slave_Transactional_Groups= 20;
48 stop all slaves;
49 Warnings:
50 Note 1938 SLAVE 'master2' stopped
51 Note 1938 SLAVE 'master1' stopped
52 set default_master_connection = 'master1';
53 include/wait_for_slave_to_stop.inc
54 set default_master_connection = 'master2';
55 include/wait_for_slave_to_stop.inc
56 set global slave_parallel_threads=0;
57 include/reset_master_slave.inc
58 disconnect slave;
59 connection master1;
60 include/reset_master_slave.inc
61 disconnect master1;
62 connection master2;
63 include/reset_master_slave.inc
64 disconnect master2;