Several times now my Google Cloud MySQL read replica just stopped replication of the master. Visible symptoms are:
- Replication lags rises on the slave.
show slave statusis stuck while the
Read_Master_Log_Posrises in line with the master.
- On the slave there is an entry for
Reading event from the relay logthat 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?