Skip navigation links

MySQL Forums :: Replication :: Replication doesn't write to database.


Advanced Search

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. 532 Nathan Wilkerson 02/14/2014 05:13PM
Re: Replication doesn't write to database. 244 Rick James 02/16/2014 12:16AM
Re: Replication doesn't write to database. 299 Nathan Wilkerson 02/16/2014 09:07AM
Re: Replication doesn't write to database. 255 Rick James 02/17/2014 11:44AM
Re: Replication doesn't write to database. 285 Nathan Wilkerson 02/17/2014 01:31PM
Re: Replication doesn't write to database. 270 Rick James 02/20/2014 12:44PM
Re: Replication doesn't write to database. 241 Nathan Wilkerson 02/26/2014 12:21PM
Re: Replication doesn't write to database. 238 Nathan Wilkerson 02/26/2014 03:33PM
Re: Replication doesn't write to database. 215 Rick James 02/27/2014 08:20PM
Re: Replication doesn't write to database. 248 Nathan Wilkerson 02/28/2014 11:07AM
Re: Replication doesn't write to database. 228 Nathan Wilkerson 03/03/2014 04:35PM
Re: Replication doesn't write to database. 238 Nathan Wilkerson 03/05/2014 10:15AM


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.