Debian Codegraph @

mysql-test/suite/multi_source/relaylog_events.test

raw
1 #
2 # Check that SHOW RELAYLOG EVENTS can be used
3 # for a named master connection
4 #
5
6 --source include/not_embedded.inc
7 --let $rpl_server_count= 0
8
9 --connect (slave,127.0.0.1,root,,,$SERVER_MYPORT_3)
10
11 --replace_result $SERVER_MYPORT_1 MYPORT_1
12 eval change master 'master1' to
13 master_port=$SERVER_MYPORT_1,
14 master_host='127.0.0.1',
15 master_user='root', master_ssl_verify_server_cert=0;
16
17 start slave 'master1';
18 set default_master_connection = 'master1';
19 --source include/wait_for_slave_to_start.inc
20
21 --connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
22 --disable_warnings
23 drop table if exists t1;
24 --enable_warnings
25 create table t1 (i int) engine=MyISAM;
26 --save_master_pos
27
28 --connection slave
29 --sync_with_master 0,'master1'
30
31 --let $datadir = `SELECT @@datadir`
32 --list_files $datadir mysqld-relay-bin-master1.*
33
34 let binlog_start=4;
35 let binlog_file= mysqld-relay-bin-master1.000002;
36 source include/show_relaylog_events.inc;
37 let binlog_file=;
38 source include/show_relaylog_events.inc;
39
40 --connection master1
41 drop table t1;
42 --save_master_pos
43
44 --connection slave
45 --sync_with_master 0,'master1'
46
47 --source include/reset_master_slave.inc
48 --disconnect slave
49
50 --connection master1
51 --source include/reset_master_slave.inc
52 --disconnect master1
53