How to recover stopped replication on MySQL?

Ask Question

Asked 11 months ago

Modified 11 months ago

Viewed 90 times

Several times now my Google Cloud MySQL read replica just stopped replication of the master. Visible symptoms are:

Replication lags rises on the slave.
The Relay_Log_Pos value of show slave status is stuck while the Read_Master_Log_Pos rises in line with the master.
On the slave there is an entry for Reading event from the relay log that has run very long

So far I had to recreate the read replica to get it working again, but I would like to avoid that.

What can I do to restore proper replication when the slave is stuck like this, without rebuilding the replica?

mustaccio

25.1k21 gold badges56 silver badges70 bronze badges

asked Dec 13, 2022 at 12:43

Laures

1111 bronze badge

1

Try STOP SLAVE; START SLAVE; on the Replica.
– Rick James
Dec 13, 2022 at 16:12
Google Cloud SQL is a managed service. That means only they can run diagnostic commands to debug and fix this issue. Open a support ticket.
– John Hanley
Dec 13, 2022 at 18:30

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.