Sample Header Ad - 728x90

fixing GTID based multi source replication error on selected source

0 votes
1 answer
359 views
I can't find or think of a solution when ever i encounter db replication errors on affected source and repositioning the GTID in the replica. What i do is retrieve from (four) masters gtid postion (show master status) then copy it to the replica server. In replica server. set global gtid_slave_pos="1-10-1111111,2-20-2222222,3-30-3333333,4-40-444444" Is there a way to reposition the gtid_slave_posonly the affected source and will not cause any sync issues on other source that has no errors. I'm using MariaDB 10.5 for master and replica.
Asked by wagop (1 rep)
Sep 29, 2022, 06:43 AM
Last activity: Mar 2, 2025, 07:03 AM