I’m struggling trying to set up async replication between 2 xtradb 5.7.31 clusters. Each cluster has 3 nodes.
If i only start one node of the secondary cluster and start re plication, it works fine, but as soon as i start another node and it joins after performing an SST, the async replication breaks due to a duplicated key.
At first i thought it was because when it performs an SST, it also brings the slave information and it starts the slave in the new node, but i put on my.cnf the skip-slave-start option, but keeps failing.
I have tried also to start the cluster in RO just to be sure nobody else writes, but i still have the same problem.
Last thing i have tried is setup the IGNORE_SERVER_IDS on change master query, but still keeps failing.
the change master query is this one
CHANGE MASTER TO
MASTER_HOST = “MY_SERVER_IP”,
MASTER_PORT = 3306,
MASTER_USER = “replic”,
MASTER_PASSWORD = “what_a_passwd”,
MASTER_AUTO_POSITION = 1, # to auto-position using GTID on slave
IGNORE_SERVER_IDS = (1,2,3);
for the records, both clusters have GTID enabled
i guess i’m missing something, but i cannot see what. Any ideas / suggestions are more than welcomed,
thanks in advance,