Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.11, 10.1.13, 10.1.14
-
2.6.32-504.8.1.el6.x86_64
Description
I have asynchronous replication between 2 clusters (calling master cluster, slave cluster). As expected a node in the slave cluster receives async replication and galera transmits to the rest of the nodes of the slave cluster. When the gtid counter is being incremented on the nodes of this slave cluster, the node acting as the slave node is keeping track of master server id and incrementing the gtid by wsrep_domain_id, server_id, galera counter+1. However the other nodes of the slave cluster are not keeping track of the server id variable and increment gtid by wsrep_domain_id, galera counter+1. See below
Slave node of the slave cluster
show variables like '%gtid%'; |
+------------------------+-------------------------+ |
Variable_nameValue
|
+------------------------+-------------------------+ |
gtid_binlog_pos2-100-36261
|
gtid_binlog_state2-200-36263,2-100-36261
|
gtid_current_pos1-100-36261
|
gtid_domain_id22
|
gtid_ignore_duplicatesOFF
|
gtid_seq_no0
|
gtid_slave_pos1-100-36261
|
gtid_strict_modeOFF
|
last_gtid2-200-36263
|
wsrep_gtid_domain_id2
|
wsrep_gtid_modeON
|
+------------------------+-------------------------+ |
11 rows in set (0.00 sec) |
Another node in the slave cluster
show variables like '%gtid%'; |
+------------------------+-------------------------+ |
Variable_nameValue
|
+------------------------+-------------------------+ |
gtid_binlog_pos2-100-36265
|
gtid_binlog_state2-200-36264,2-100-36265
|
gtid_current_pos1-100-36259
|
gtid_domain_id22
|
gtid_ignore_duplicatesOFF
|
gtid_seq_no0
|
gtid_slave_pos1-100-36259
|
gtid_strict_modeOFF
|
last_gtid
|
wsrep_gtid_domain_id2
|
wsrep_gtid_modeON
|
+------------------------+-------------------------+ |
11 rows in set (0.00 sec) |
Please review and let me know if this is expected behavior or bug.
Attachments
Issue Links
- is caused by
-
-
- Closed
-
-
MDEV-20720 Galera: Replicate MariaDB GTID to other nodes in the cluster
-
- Closed
-
- relates to
-
-
- Open
-