Debian Codegraph @

mysql-test/suite/multi_source/load_data.result

raw
1 connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
2 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
3 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
4 connection slave;
5 change master '' to master_port=MYPORT_1, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
6 change master 'master2' to master_port=MYPORT_2, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
7 start all slaves;
8 Warnings:
9 Note 1937 SLAVE 'master2' started
10 Note 1937 SLAVE '' started
11 set default_master_connection = '';
12 include/wait_for_slave_to_start.inc
13 set default_master_connection = 'master2';
14 include/wait_for_slave_to_start.inc
15 set default_master_connection = '';
16 connection master1;
17 create table t1 (a varchar(10) character set utf8);
18 load data infile '../../std_data/loaddata6.dat' into table t1 character set latin1;
19 connection slave;
20 connection master2;
21 create table t2 (a varchar(10) character set utf8);
22 load data infile '../../std_data/loaddata6.dat' into table t2 character set latin1;
23 connection slave;
24 select count(*) from t1;
25 count(*)
26 1
27 select count(*) from t2;
28 count(*)
29 1
30 connection master1;
31 drop table t1;
32 connection master2;
33 drop table t2;
34 connection master1;
35 connection slave;
36 connection master2;
37 connection slave;
38 connection slave;
39 stop all slaves;
40 Warnings:
41 Note 1938 SLAVE '' stopped
42 Note 1938 SLAVE 'master2' stopped
43 include/reset_master_slave.inc
44 disconnect slave;
45 connection master1;
46 include/reset_master_slave.inc
47 disconnect master1;
48 connection master2;
49 include/reset_master_slave.inc
50 disconnect master2;