I have two databases that sync data through Master-Master replication.
The setup was created using the following guide:
Until 2 days ago the system had been running fine for over a year, but now I have this weird issue.
- Slave status,Master status & my.cnf replication settings: https://i.cloudup.com/IjK7fPVaN9-3000x3000.jpeg
- Slave status,Master status & my.cnf replication settings: https://i.cloudup.com/sDyBxeuqt2-1200x1200.jpeg
As you can see, Server 2 is synced correctly but Server 1 is way behind the master position of Server 2. Server 1's slave read position does not attempt to "catch up" or attempt to match the master status. When I manually make them match using:
CHANGE MASTER TO MASTER_HOST = 'xx.xx.xx.xx, MASTER_USER = 'username', MASTER_PASSWORD = 'password', MASTER_LOG_FILE = 'mysql-bin.000001', MASTER_LOG_POS = 001;
Server 1's slave matches Server 2's master bin log position but after an hour or two, it falls behinds and stays behind.
We are running:
- Ubuntu (Server 1) & debian (Server 2) OS
- Both MySQL running 5.5.3
I have no idea why up till 2 days ago, this was working fine and now Server 1 is extremely lagging behind server 2. Is it possible an issue with the connection between the two servers?
Can anyone shed some light on this issue?