Timeline for MySQL Replication Stops, But Still Says it is Running
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 17, 2018 at 7:31 | vote | accept | IGGt | ||
| Oct 17, 2018 at 7:30 | comment | added | IGGt | as the issue hasn't re-occurred I will accept @RolandoMySQLDBA s answer as it was very useful. | |
| Oct 4, 2018 at 9:50 | comment | added | IGGt |
Very useful, thankyou. The problem hasn't re-occurred since (un)fortunately. There were two things we found. One of the slave databases was MySQL 5.7 (in testing) and it had sync_binlog = 1 set. I removed this and replication generally improved. We also found some very processor intensive processes running on the hypervisor, and these have been stopped.
|
|
| Sep 28, 2018 at 20:51 | history | answered | RolandoMySQLDBA | CC BY-SA 4.0 |