connection node_2;
connection node_1;
# On node_1
connection node_1;
list of GTID variables :
gtid_domain_id	1
gtid_binlog_pos	
gtid_binlog_state	
gtid_current_pos	
gtid_slave_pos	
wsrep_gtid_domain_id	9999
wsrep_gtid_mode	1
# On node_2
connection node_2;
list of GTID variables :
gtid_domain_id	2
gtid_binlog_pos	
gtid_binlog_state	
gtid_current_pos	
gtid_slave_pos	
wsrep_gtid_domain_id	9999
wsrep_gtid_mode	1
# On node_1
connection node_1;
CREATE TABLE t1(i INT) ENGINE=INNODB;
CREATE TABLE t2(i INT) ENGINE=MEMORY;
INSERT INTO t1 VALUES(1);
SELECT * FROM t1;
i
1
SELECT * FROM t2;
i
list of GTID variables :
gtid_domain_id	1
gtid_binlog_pos	9999-1-3
gtid_binlog_state	9999-1-3
gtid_current_pos	9999-1-3
gtid_slave_pos	
wsrep_gtid_domain_id	9999
wsrep_gtid_mode	1
# On node_2
connection node_2;
SELECT * FROM t1;
i
1
list of GTID variables :
gtid_domain_id	2
gtid_binlog_pos	9999-1-3
gtid_binlog_state	9999-1-3
gtid_current_pos	
gtid_slave_pos	
wsrep_gtid_domain_id	9999
wsrep_gtid_mode	1
# On node_1
connection node_1;
INSERT INTO t2 VALUES(1);
SELECT * FROM t2;
i
1
list of GTID variables :
gtid_domain_id	1
gtid_binlog_pos	1-1-1,9999-1-3
gtid_binlog_state	1-1-1,9999-1-3
gtid_current_pos	1-1-1,9999-1-3
gtid_slave_pos	
wsrep_gtid_domain_id	9999
wsrep_gtid_mode	1
# On node_2
connection node_2;
SELECT * FROM t2;
i
list of GTID variables :
gtid_domain_id	2
gtid_binlog_pos	9999-1-3
gtid_binlog_state	9999-1-3
gtid_current_pos	
gtid_slave_pos	
wsrep_gtid_domain_id	9999
wsrep_gtid_mode	1
# On node_1
connection node_1;
DROP TABLE t1, t2;
#cleanup
connection node_1;
set global wsrep_on=OFF;
reset master;
set global wsrep_on=ON;
connection node_2;
set global wsrep_on=OFF;
reset master;
set global wsrep_on=ON;
connection node_2;
CALL mtr.add_suppression("Ignoring server id for non bootstrap node");
disconnect node_2;
disconnect node_1;
# End of test