mirror of
https://github.com/MariaDB/server.git
synced 2026-02-19 09:08:41 +01:00
53173709b3
Variable `wsrep_new_cluster` now will be TRUE also when there is only `gcomm://` used in configuration. This configuration, even without --wsrep-new-cluster, is considered to bootstrap new cluster. Updated galera GTID test to ignore warning message when non bootstrap node have server-id different thant one cluster is initialized with. Reviewed-by: Jan Lindström <jan.lindstrom@mariadb.com>
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
|