I have a MySQL master with two slaves. Due to poor configuration both slaves had the same server-id.
My questions are:
- Is the slaves' data fully synced with the master or did they miss transactions and I should start a new replication ?
- During the past 4 days the master server was getting stuck randomly (3 times) with no apparent reason - is this the cause? if so, why would it get stuck? (By stuck I mean that it was running, no errors in the log, but not accepting connections)
- The slaves have been busy for 3 days with a big ALTER that the master long finished, does this have anything to do with it?