summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/r/rpl_domain_id_filter.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_domain_id_filter.result')
-rw-r--r--mysql-test/suite/rpl/r/rpl_domain_id_filter.result61
1 files changed, 31 insertions, 30 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_domain_id_filter.result b/mysql-test/suite/rpl/r/rpl_domain_id_filter.result
index fb315c4b020..893d76e4a2e 100644
--- a/mysql-test/suite/rpl/r/rpl_domain_id_filter.result
+++ b/mysql-test/suite/rpl/r/rpl_domain_id_filter.result
@@ -1,9 +1,9 @@
include/master-slave.inc
[connection master]
-# On slave
+connection slave;
call mtr.add_suppression("Both DO_DOMAIN_IDS & IGNORE_DOMAIN_IDS lists can't be non-empty at the same time");
call mtr.add_suppression("DO_DOMAIN_IDS or IGNORE_DOMAIN_IDS lists can't be non-empty in non-GTID mode.*");
-# On master
+connection master;
SET @@session.gtid_domain_id= 1;
SELECT @@session.gtid_domain_id;
@@session.gtid_domain_id
@@ -14,7 +14,7 @@ SELECT * FROM t1;
i
1
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
SELECT * FROM t1;
i
@@ -26,7 +26,7 @@ CHANGE MASTER TO DO_DOMAIN_IDS=(1), MASTER_USE_GTID=slave_pos;
include/start_slave.inc
DO_DOMAIN_IDS (AFTER) : 1
IGNORE_DOMAIN_IDS (AFTER) :
-# On master
+connection master;
SET @@session.gtid_domain_id= 2;
INSERT INTO t1 VALUES(2);
SET @@session.gtid_domain_id= 1;
@@ -37,7 +37,7 @@ i
2
3
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
SELECT * FROM t1;
i
@@ -50,7 +50,7 @@ CHANGE MASTER TO DO_DOMAIN_IDS=(), IGNORE_DOMAIN_IDS=(1), MASTER_USE_GTID=slave_
include/start_slave.inc
DO_DOMAIN_IDS (AFTER) :
IGNORE_DOMAIN_IDS (AFTER) : 1
-# On master
+connection master;
SELECT @@session.gtid_domain_id;
@@session.gtid_domain_id
1
@@ -65,7 +65,7 @@ i
4
5
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
SELECT * FROM t1;
i
@@ -88,7 +88,7 @@ CHANGE MASTER TO DO_DOMAIN_IDS=(4,4,5,1,7,7,7,1,1,2,6,8,1,4,5,5,9,3), IGNORE_DOM
include/start_slave.inc
DO_DOMAIN_IDS (AFTER) : 1, 2, 3, 4, 5, 6, 7, 8, 9
IGNORE_DOMAIN_IDS (AFTER) :
-# On master
+connection master;
SELECT @@session.gtid_domain_id;
@@session.gtid_domain_id
2
@@ -105,7 +105,7 @@ COMMIT;
INSERT INTO t1 VALUES(14);
INSERT INTO t1 VALUES(15);
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
SELECT * FROM t1;
i
@@ -114,10 +114,10 @@ i
5
8
9
-# On slave
+connection slave;
# Seconds_Behind_Master should be zero here because the slave is fully caught up and idle.
Seconds_Behind_Master = '0'
-# On slave
+connection slave;
include/stop_slave.inc
DO_DOMAIN_IDS (BEFORE) : 1, 2, 3, 4, 5, 6, 7, 8, 9
IGNORE_DOMAIN_IDS (BEFORE) :
@@ -125,7 +125,7 @@ CHANGE MASTER TO DO_DOMAIN_IDS=(), IGNORE_DOMAIN_IDS=(1), MASTER_USE_GTID=slave_
include/start_slave.inc
DO_DOMAIN_IDS (AFTER) :
IGNORE_DOMAIN_IDS (AFTER) : 1
-# On master
+connection master;
SET @@session.gtid_domain_id=2;
CREATE TABLE t2(i int) ENGINE=MYISAM;
CREATE TABLE t3(i int) ENGINE=INNODB;
@@ -133,28 +133,28 @@ SET @@session.gtid_domain_id=1;
BEGIN;
INSERT INTO t2 VALUES(1);
INSERT INTO t3 VALUES(1);
-# On slave
+connection slave;
include/stop_slave.inc
include/wait_for_slave_to_stop.inc
-# On master
+connection master;
INSERT INTO t2 VALUES(2);
INSERT INTO t3 VALUES(2);
COMMIT;
include/save_master_gtid.inc
-# On slave
+connection slave;
include/start_slave.inc
include/sync_with_master_gtid.inc
SELECT * FROM t2;
i
SELECT * FROM t3;
i
-# On master
+connection master;
SET @@session.gtid_domain_id=1;
BEGIN;
INSERT INTO t2 VALUES(3);
INSERT INTO t3 VALUES(3);
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
include/stop_slave.inc
DO_DOMAIN_IDS (BEFORE) :
@@ -163,12 +163,12 @@ CHANGE MASTER TO DO_DOMAIN_IDS=(), IGNORE_DOMAIN_IDS=(), MASTER_USE_GTID=slave_p
include/start_slave.inc
DO_DOMAIN_IDS (AFTER) :
IGNORE_DOMAIN_IDS (AFTER) :
-# On master
+connection master;
INSERT INTO t2 VALUES(4);
INSERT INTO t3 VALUES(4);
COMMIT;
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
SELECT * FROM t2;
i
@@ -177,13 +177,13 @@ SELECT * FROM t3;
i
3
4
-# On master
+connection master;
SET @@session.gtid_domain_id=1;
BEGIN;
INSERT INTO t2 VALUES(5);
INSERT INTO t3 VALUES(5);
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
include/stop_slave.inc
DO_DOMAIN_IDS (BEFORE) :
@@ -192,12 +192,12 @@ CHANGE MASTER TO DO_DOMAIN_IDS=(), IGNORE_DOMAIN_IDS=(1), MASTER_USE_GTID=slave_
include/start_slave.inc
DO_DOMAIN_IDS (AFTER) :
IGNORE_DOMAIN_IDS (AFTER) : 1
-# On master
+connection master;
INSERT INTO t2 VALUES(6);
INSERT INTO t3 VALUES(6);
COMMIT;
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
SELECT * FROM t2;
i
@@ -207,7 +207,7 @@ SELECT * FROM t3;
i
3
4
-# On slave
+connection slave;
include/stop_slave.inc
DO_DOMAIN_IDS (BEFORE) :
IGNORE_DOMAIN_IDS (BEFORE) : 1
@@ -215,14 +215,14 @@ CHANGE MASTER TO IGNORE_DOMAIN_IDS=(2), MASTER_USE_GTID=slave_pos;
include/start_slave.inc
DO_DOMAIN_IDS (AFTER) :
IGNORE_DOMAIN_IDS (AFTER) : 2
-# On master
+connection master;
SET @@session.gtid_domain_id=2;
BEGIN;
INSERT INTO t2 VALUES(7);
INSERT INTO t3 VALUES(7);
COMMIT;
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
include/stop_slave.inc
DO_DOMAIN_IDS (BEFORE) :
@@ -231,14 +231,14 @@ CHANGE MASTER TO IGNORE_DOMAIN_IDS=(), MASTER_USE_GTID=slave_pos;
include/start_slave.inc
DO_DOMAIN_IDS (AFTER) :
IGNORE_DOMAIN_IDS (AFTER) :
-# On master
+connection master;
SET @@session.gtid_domain_id=2;
BEGIN;
INSERT INTO t2 VALUES(8);
INSERT INTO t3 VALUES(8);
COMMIT;
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
SELECT * FROM t2;
i
@@ -250,6 +250,7 @@ i
3
4
8
+connection slave;
include/stop_slave.inc
DO_DOMAIN_IDS (BEFORE) :
IGNORE_DOMAIN_IDS (BEFORE) :
@@ -274,11 +275,11 @@ DO_DOMAIN_IDS (AFTER) :
IGNORE_DOMAIN_IDS (AFTER) :
CHANGE MASTER TO IGNORE_DOMAIN_IDS=(1), DO_DOMAIN_IDS=(), MASTER_USE_GTID=SLAVE_POS;
include/start_slave.inc
-# On master
+connection master;
SET @@session.gtid_domain_id=2;
DROP TABLE t1, t2, t3;
include/save_master_gtid.inc
-# On slave
+connection slave;
include/sync_with_master_gtid.inc
include/stop_slave.inc
CHANGE MASTER TO DO_DOMAIN_IDS=(), IGNORE_DOMAIN_IDS=();
View Lorry Controller Status