I have a master DB running on internal network and an AWS RDS slave replica from the Master DB. When I upload a fresh copy of the master, the slave will replicate for few days with no issues. After a couple of days, the slave status says its correct but records will be missing on the DB. I ran both
show master status
show slave status
The Master_log_file and Read_Master_log_Pos are matching. One thing to mention we ran a huge dump on the master daily from a legacy system.
What could be the reason for the discrepancy between the two and how to fix it ?
Thanks in Advance.
Update: Today we got yesterday data. It is possible that the amount of data we are replicating everyday cause the slave to get clogged and take time to get update ?
After leaving Slave during the weekend. the Seconds_behind_Master went down to zero. Also here the result of show slave status
Slave_IO_State: Waiting for master to send event,
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it,