Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Not a Bug
Description
Hi,
I've configure a Galera Cluster between two sites (Site 1 and 2)
First node of site 1 is a slave of the current production Master (Percona 5.5.14 with standard replication).
Behind each nodes of the second site I've 3 RO replica with GTID method.
My problem is that I have the same GTID between each nodes except the node 1 of site 1 - node who's replica of the Master production.
I can switch a RO replica between each nodes except with the first one on site 1 because when I switch to it I've an error like this:
Last_Error: Could not execute Write_rows_v1 event on table test.tes1; Duplicate entry '195001708' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000002, end_log_pos 40652604
Need help to understand what happen.
On each config file I have:
log_bin=binlog
binlog_format=ROW
log_slave_updates=on
wsrep_gtid_mode=on
Regards