diff options
Diffstat (limited to 'mysql-test/suite/multi_source/multisource.result')
| -rw-r--r-- | mysql-test/suite/multi_source/multisource.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/suite/multi_source/multisource.result b/mysql-test/suite/multi_source/multisource.result index 227e88f6d71..d99a377f0c5 100644 --- a/mysql-test/suite/multi_source/multisource.result +++ b/mysql-test/suite/multi_source/multisource.result @@ -1,3 +1,4 @@ +connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3; change master 'abc' to relay_log_file=''; ERROR HY000: Failed initializing relay log position: Could not find target log during relay log initialization change master 'abc2' to master_host=''; @@ -9,6 +10,8 @@ master_user='root'; start slave 'master1'; set default_master_connection = 'master1'; include/wait_for_slave_to_start.inc +connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1; +connection slave; # # Checking SHOW SLAVE 'master1' STATUS # @@ -39,11 +42,13 @@ Last_Errno = '0' Last_SQL_Errno = '0' Slave_heartbeat_period = '60.000' # +connection master1; drop database if exists db1; create database db1; use db1; create table t1 (i int auto_increment, f1 varchar(16), primary key pk (i,f1)) engine=MyISAM; insert into t1 (f1) values ('one'),('two'); +connection slave; select * from db1.t1; i f1 1 one @@ -115,13 +120,18 @@ Last_SQL_Errno = '0' Slave_heartbeat_period = '60.000' Slave_heartbeat_period = '60.000' # +connection master1; insert into t1 (f1) values ('three'); +connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2; drop database if exists db2; create database db2; use db2; create table t1 (pk int auto_increment primary key, f1 int) engine=InnoDB; begin; insert into t1 (f1) values (1),(2); +connection slave; +connection master2; +connection slave; select * from db1.t1; i f1 1 one @@ -129,18 +139,24 @@ i f1 3 three select * from db2.t1; pk f1 +connection master2; commit; +connection slave; select * from db2.t1; pk f1 1 1 2 2 +connection master1; flush logs; +connection slave; +connection master1; purge binary logs to 'master-bin.000002'; show binary logs; Log_name File_size master-bin.000002 filesize insert into t1 (f1) values ('four'); create table db1.t3 (f1 int) engine=InnoDB; +connection slave; # # Checking SHOW ALL SLAVES STATUS # @@ -188,6 +204,8 @@ mysqld-relay-bin.000002 # Gtid # # BEGIN GTID #-#-# mysqld-relay-bin.000002 # Intvar # # INSERT_ID=1 mysqld-relay-bin.000002 # Query # # use `db2`; insert into t1 (f1) values (1),(2) mysqld-relay-bin.000002 # Xid # # COMMIT /* XID */ +disconnect slave; +connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3; stop slave io_thread; show status like 'Slave_running'; Variable_name Value @@ -199,7 +217,12 @@ Slave_running ON drop database db1; drop database db2; include/reset_master_slave.inc +disconnect slave; +connection master1; drop database db1; include/reset_master_slave.inc +disconnect master1; +connection master2; drop database db2; include/reset_master_slave.inc +disconnect master2; |