Run these commands on MySQL shell, to find "where" replication failed and was broken.
Stop the slave.
SET GTID_NEXT="AUTOMATIC";
stop slave;
Find the point where replication broke.
show slave status\G;
Now find "Executed_Gtid_Set". Example value:
Executed_Gtid_Set: 44d966cc-d84d-11e8-be8d-20677cd3f384:1-2872
Increase of one step to 2873
SET GTID_NEXT="44d966cc-d84d-11e8-be8d-20677cd3f384:2873";
Now start the slave.
start slave;
show slave status\G;
Here is another useful tutorial, if the problem persists
https://www.percona.com/blog/2013/02/08/how-to-createrestore-a-slave-using-gtid-replication-in-mysql-5-6/
Continue the loop until no error occurs. Enjoy
Estrazioni del Lotto e numeri vincenti 10e lotto del 26 luglio 2024
-
Ecco le estrazioni del Lotto di oggi 26 luglio BARI 83 50 70 71 48 CAGLIARI
50 35 74 61 06 FIRENZE 14 76 62 50 83 GENOVA 89 32 85 53 05 MILANO 11 32 21
09 ...
10 ore fa
Nessun commento:
Posta un commento