MySQL Forums
Forum List  »  Replication

Replication doesn't write to database.
Posted by: Nathan Wilkerson
Date: February 14, 2014 05:13PM

We have had replication setup between two servers for a long while. Recently the slave would stop replicating data with out any errors or warnings. The only way to identify this is by setting up a heartbeat service.


mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Connect_Retry: 60
Master_Log_File: mysql-bin.000789
Read_Master_Log_Pos: 593352168
Relay_Log_File: data04-relay-bin.000008
Relay_Log_Pos: 593352313
Relay_Master_Log_File: mysql-bin.000789
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 593352168
Relay_Log_Space: 593352517
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0

Log positions change and the relay log continues to grow but no data in the database is updated.

No errors in the error log, bin log or system logs.

Any ideas what might be happening or causing this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication doesn't write to database.
1395
February 14, 2014 05:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.