# Test for @@wsrep_gtid_mode and @@wsrep_gtid_domain_id variables # # When @@wsrep_gtid_mode=ON, all DDL/DML commands and transactions that # are meant to be replicated over Galera cluster nodes are tagged with # galera gtid_domain_id (@@wsrep_gtid_domain_id), while others are tagged # with the local domain_id (@@gtid_domain_id). --source include/galera_cluster.inc --source include/have_innodb.inc --echo # On node_1 --connection node_1 # print initial GTIDs source include/print_gtid.inc; --echo # On node_2 --connection node_2 # print initial GTIDs source include/print_gtid.inc; --echo # 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; SELECT * FROM t2; source include/print_gtid.inc; --echo # On node_2 --connection node_2 SELECT * FROM t1; source include/print_gtid.inc; --echo # On node_1 --connection node_1 INSERT INTO t2 VALUES(1); SELECT * FROM t2; source include/print_gtid.inc; --echo # On node_2 --connection node_2 SELECT * FROM t2; source include/print_gtid.inc; --echo # On node_1 --connection node_1 # Cleanup DROP TABLE t1, t2; --echo #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; --source include/galera_end.inc --echo # End of test