Debian Codegraph @

mysql-test/suite/multi_source/multi_parallel.test

raw
1 # This test file tests events counter like Slave_ddl_groups,
2 # Slave_non_transactional_groups, Slave_transactional_groups
3 --source include/not_embedded.inc
4 --source include/have_innodb.inc
5 --source include/no_valgrind_without_big.inc
6 --let $rpl_server_count= 0
7
8 --connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
9 --connect (master2,127.0.0.1,root,,,$SERVER_MYPORT_2)
10 --connect (slave,127.0.0.1,root,,,$SERVER_MYPORT_3)
11
12 #save state
13 --let $par_thd= `select @@slave_parallel_threads;`
14
15 set global slave_parallel_threads=10;
16
17 --replace_result $SERVER_MYPORT_1 MYPORT_1
18 eval change master 'master1' to
19 master_port=$SERVER_MYPORT_1,
20 master_host='127.0.0.1',
21 master_user='root', master_ssl_verify_server_cert=0;
22
23 --replace_result $SERVER_MYPORT_2 MYPORT_2
24 eval change master 'master2' to
25 master_port=$SERVER_MYPORT_2,
26 master_host='127.0.0.1',
27 master_user='root', master_ssl_verify_server_cert=0;
28
29
30 #start all slaves
31 --disable_warnings
32 start all slaves;
33 --enable_warnings
34 set default_master_connection = 'master1';
35 --source include/wait_for_slave_to_start.inc
36
37 set default_master_connection = 'master2';
38 --source include/wait_for_slave_to_start.inc
39
40 --echo ## Slave status variable
41
42 set default_master_connection = 'master1';
43 show status like 'slave_running';
44
45 set default_master_connection = 'master2';
46 show status like 'slave_running';
47
48
49 --echo #master 1
50 --connection master1
51
52 --let $loop_counter=10
53 --let $table_engine=myisam
54 --source multi_parallel_loop.inc
55 --save_master_pos
56
57 --connection slave
58
59 --sync_with_master 0,'master1'
60 --let $status= query_get_value(show slave 'master1' status, Slave_DDL_Groups, 1)
61 --echo Slave_DDL_Groups= $status;
62
63 --let $status= query_get_value(show slave 'master1' status, Slave_Non_Transactional_Groups, 1)
64 --echo Slave_Non_Transactional_Groups= $status;
65
66 --let $status= query_get_value(show slave 'master1' status, Slave_Transactional_Groups, 1)
67 --echo Slave_Transactional_Groups= $status;
68
69 --echo #master 2
70 --connection master2
71
72 --let $loop_counter=10
73 --let $table_engine=myisam
74 --source multi_parallel_loop.inc
75 --save_master_pos
76
77 --connection slave
78 --sync_with_master 0,'master2'
79 --let $status= query_get_value(show slave 'master2' status, Slave_DDL_Groups, 1)
80 --echo Slave_DDL_Groups= $status;
81
82 --let $status= query_get_value(show slave 'master2' status, Slave_Non_Transactional_Groups, 1)
83 --echo Slave_Non_Transactional_Groups= $status;
84
85 --let $status= query_get_value(show slave 'master2' status, Slave_Transactional_Groups, 1)
86 --echo Slave_Transactional_Groups= $status;
87
88 --echo #master 1
89 --connection master1
90
91 --let $loop_counter=10
92 --let $table_engine=innodb
93 --source multi_parallel_loop.inc
94 --save_master_pos
95
96 --connection slave
97
98 --sync_with_master 0,'master1'
99 --let $status= query_get_value(show slave 'master1' status, Slave_DDL_Groups, 1)
100 --echo Slave_DDL_Groups= $status;
101
102 --let $status= query_get_value(show slave 'master1' status, Slave_Non_Transactional_Groups, 1)
103 --echo Slave_Non_Transactional_Groups= $status;
104
105 --let $status= query_get_value(show slave 'master1' status, Slave_Transactional_Groups, 1)
106 --echo Slave_Transactional_Groups= $status;
107
108
109 # Cleanup
110 stop all slaves;
111 set default_master_connection = 'master1';
112 --source include/wait_for_slave_to_stop.inc
113
114 set default_master_connection = 'master2';
115 --source include/wait_for_slave_to_stop.inc
116
117 --eval set global slave_parallel_threads=$par_thd
118
119 --source include/reset_master_slave.inc
120 --disconnect slave
121 --connection master1
122 --source include/reset_master_slave.inc
123 --disconnect master1
124 --connection master2
125 --source include/reset_master_slave.inc
126 --disconnect master2