Debian Codegraph @

mysql-test/suite/multi_source/syntax.test

raw
1 # Test multi master syntax
2
3 --source include/not_embedded.inc
4 --source include/master-slave.inc
5
6 # Check syntax of multi source replication
7
8 show slave status;
9 show slave '' status;
10 show all slaves status;
11
12 --echo #
13 --echo # Check error handling
14 --echo #
15
16 --error WARN_NO_MASTER_INFO
17 show slave 'qqq' status;
18 --error WARN_NO_MASTER_INFO
19 show slave 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc' status;
20 --error ER_WRONG_ARGUMENTS
21 show slave 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbcccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc' status;
22 --error ER_WRONG_ARGUMENTS
23 change master 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbcccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc' to master_host='dummy';
24
25 --error WARN_NO_MASTER_INFO
26 start slave 'qqq';
27 --error WARN_NO_MASTER_INFO
28 stop slave 'qqq';
29 --error WARN_NO_MASTER_INFO
30 flush slave 'qqq';
31 --error WARN_NO_MASTER_INFO
32 reset slave 'qqq';
33
34 select master_pos_wait('master-bin.999999',0,2,'qqq');
35 select master_pos_wait('master-bin.999999',0,2,'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbcccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc');
36
37 save_master_pos;
38 connection slave;
39 sync_with_master 0,'';
40 sync_with_master 0 ,'';
41 sync_with_master 0, '';
42
43 --echo #
44 --echo # checking usage of default_master_connection;
45 --echo #
46 select @@default_master_connection;
47
48 --error 1238
49 select @@global.default_master_connection;
50 --error 1228
51 set @@global.default_master_connection='qqq';
52 --error 1231
53 set @@default_master_connection='aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbcccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc';
54 select @@default_master_connection;
55 set @@default_master_connection='qqq';
56 select @@default_master_connection;
57 show variables like "default_master_connection";
58
59 --error WARN_NO_MASTER_INFO
60 show slave status;
61 select master_pos_wait('master-bin.999999',0,2);
62 set @@default_master_connection='';
63 select master_pos_wait('master-bin.999999',0,2);
64
65 set @@default_master_connection='';
66
67 --echo #
68 --echo # checking variables
69 --echo #
70 show status like "Slave_running";
71 set @@default_master_connection='qqq';
72 show status like "Slave_running";
73 set @@default_master_connection='';
74
75 --source include/rpl_end.inc