# On 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
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
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
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
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
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
DROP TABLE t1, t2;
# End of test