mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
96 lines
1.9 KiB
Text
96 lines
1.9 KiB
Text
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 4294967295
|
|
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 4294967295
|
|
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 4294967295-1-3
|
|
gtid_binlog_state 4294967295-1-3
|
|
gtid_current_pos 4294967295-1-3
|
|
gtid_slave_pos
|
|
wsrep_gtid_domain_id 4294967295
|
|
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 4294967295-1-3
|
|
gtid_binlog_state 4294967295-1-3
|
|
gtid_current_pos
|
|
gtid_slave_pos
|
|
wsrep_gtid_domain_id 4294967295
|
|
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,4294967295-1-3
|
|
gtid_binlog_state 1-1-1,4294967295-1-3
|
|
gtid_current_pos 1-1-1,4294967295-1-3
|
|
gtid_slave_pos
|
|
wsrep_gtid_domain_id 4294967295
|
|
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 4294967295-1-3
|
|
gtid_binlog_state 4294967295-1-3
|
|
gtid_current_pos
|
|
gtid_slave_pos
|
|
wsrep_gtid_domain_id 4294967295
|
|
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
|