mirror of
https://github.com/MariaDB/server.git
synced 2025-10-26 16:38:11 +01:00
95 lines
2.9 KiB
Text
95 lines
2.9 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connection node_1;
|
|
select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode;
|
|
@@gtid_domain_id @@server_id @@wsrep_gtid_domain_id @@wsrep_gtid_mode
|
|
0 11 1 1
|
|
connection node_2;
|
|
call mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
|
|
select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode;
|
|
@@gtid_domain_id @@server_id @@wsrep_gtid_domain_id @@wsrep_gtid_mode
|
|
0 12 1 1
|
|
connection node_1;
|
|
CREATE TABLE t1(id int not null primary key) engine=innodb;
|
|
INSERT INTO t1 values (1);
|
|
show global variables like '%gtid%';
|
|
Variable_name Value
|
|
binlog_gtid_index ON
|
|
binlog_gtid_index_page_size 4096
|
|
binlog_gtid_index_span_min 65536
|
|
gtid_binlog_pos 1-11-2
|
|
gtid_binlog_state 1-11-2
|
|
gtid_cleanup_batch_size 64
|
|
gtid_current_pos 1-11-2
|
|
gtid_domain_id 0
|
|
gtid_ignore_duplicates OFF
|
|
gtid_pos_auto_engines
|
|
gtid_slave_pos
|
|
gtid_strict_mode OFF
|
|
wsrep_gtid_domain_id 1
|
|
wsrep_gtid_mode ON
|
|
connection node_2;
|
|
SET SESSION wsrep_sync_wait=15;
|
|
show global variables like '%gtid%';
|
|
Variable_name Value
|
|
binlog_gtid_index ON
|
|
binlog_gtid_index_page_size 4096
|
|
binlog_gtid_index_span_min 65536
|
|
gtid_binlog_pos 0-12-1,1-11-2
|
|
gtid_binlog_state 0-12-1,1-11-2
|
|
gtid_cleanup_batch_size 64
|
|
gtid_current_pos 0-12-1
|
|
gtid_domain_id 0
|
|
gtid_ignore_duplicates OFF
|
|
gtid_pos_auto_engines
|
|
gtid_slave_pos
|
|
gtid_strict_mode OFF
|
|
wsrep_gtid_domain_id 1
|
|
wsrep_gtid_mode ON
|
|
SET GLOBAL server_id=200;
|
|
ERROR 42000: Variable 'server_id' can't be set to the value of '200'
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Warning 1231 Can't change server_id because wsrep and wsrep_gtid_mode is set. You can set server_id only with wsrep_new_cluster.
|
|
Error 1231 Variable 'server_id' can't be set to the value of '200'
|
|
SET SESSION server_id=200;
|
|
ERROR 42000: Variable 'server_id' can't be set to the value of '200'
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Warning 1231 Can't change server_id because wsrep and wsrep_gtid_mode is set. You can set server_id only with wsrep_new_cluster.
|
|
Error 1231 Variable 'server_id' can't be set to the value of '200'
|
|
INSERT INTO t1 values(2);
|
|
show global variables like '%gtid%';
|
|
Variable_name Value
|
|
binlog_gtid_index ON
|
|
binlog_gtid_index_page_size 4096
|
|
binlog_gtid_index_span_min 65536
|
|
gtid_binlog_pos 0-12-1,1-11-3
|
|
gtid_binlog_state 0-12-1,1-11-3
|
|
gtid_cleanup_batch_size 64
|
|
gtid_current_pos 0-12-1
|
|
gtid_domain_id 0
|
|
gtid_ignore_duplicates OFF
|
|
gtid_pos_auto_engines
|
|
gtid_slave_pos
|
|
gtid_strict_mode OFF
|
|
wsrep_gtid_domain_id 1
|
|
wsrep_gtid_mode ON
|
|
connection node_1;
|
|
show global variables like '%gtid%';
|
|
Variable_name Value
|
|
binlog_gtid_index ON
|
|
binlog_gtid_index_page_size 4096
|
|
binlog_gtid_index_span_min 65536
|
|
gtid_binlog_pos 1-11-3
|
|
gtid_binlog_state 1-11-3
|
|
gtid_cleanup_batch_size 64
|
|
gtid_current_pos 1-11-3
|
|
gtid_domain_id 0
|
|
gtid_ignore_duplicates OFF
|
|
gtid_pos_auto_engines
|
|
gtid_slave_pos
|
|
gtid_strict_mode OFF
|
|
wsrep_gtid_domain_id 1
|
|
wsrep_gtid_mode ON
|
|
DROP TABLE t1;
|