Debian Codegraph @

mysql-test/suite/multi_source/load_data.test

raw
1 #
2 # Simple multi-master test
3 #
4
5 --source include/not_embedded.inc
6 --let $rpl_server_count= 0
7
8 --connect (slave,127.0.0.1,root,,,$SERVER_MYPORT_3)
9 --connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
10 --connect (master2,127.0.0.1,root,,,$SERVER_MYPORT_2)
11 --connection slave
12
13 --replace_result $SERVER_MYPORT_1 MYPORT_1
14 eval change master '' to master_port=$SERVER_MYPORT_1, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
15 --replace_result $SERVER_MYPORT_2 MYPORT_2
16 eval change master 'master2' to master_port=$SERVER_MYPORT_2, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
17 start all slaves;
18
19 set default_master_connection = '';
20 --source include/wait_for_slave_to_start.inc
21 set default_master_connection = 'master2';
22 --source include/wait_for_slave_to_start.inc
23
24 #
25 # Now test doing a load data infile from both connections
26 #
27 set default_master_connection = '';
28 --connection master1
29 create table t1 (a varchar(10) character set utf8);
30 load data infile '../../std_data/loaddata6.dat' into table t1 character set latin1;
31 --save_master_pos
32 --connection slave
33 --sync_with_master 0,''
34 --connection master2
35 create table t2 (a varchar(10) character set utf8);
36 load data infile '../../std_data/loaddata6.dat' into table t2 character set latin1;
37 --save_master_pos
38 --connection slave
39 --sync_with_master 0,'master2'
40 select count(*) from t1;
41 select count(*) from t2;
42 --connection master1
43 drop table t1;
44 --connection master2
45 drop table t2;
46
47 #
48 # clean up
49 #
50
51 --connection master1
52 --save_master_pos
53 --connection slave
54 --sync_with_master 0,''
55 --connection master2
56 --save_master_pos
57 --connection slave
58 --sync_with_master 0,'master2'
59
60 --connection slave
61 --sorted_result
62 stop all slaves;
63
64 --source include/reset_master_slave.inc
65 --disconnect slave
66 --connection master1
67 --source include/reset_master_slave.inc
68 --disconnect master1
69 --connection master2
70 --source include/reset_master_slave.inc
71 --disconnect master2