Replication doesn't write to database.
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?
Subject
Views
Written By
Posted
Replication doesn't write to database.
1841
February 14, 2014 05:13PM
890
February 16, 2014 12:16AM
1364
February 16, 2014 09:07AM
864
February 17, 2014 11:44AM
1015
February 17, 2014 01:31PM
958
February 20, 2014 12:44PM
968
February 26, 2014 12:21PM
873
February 26, 2014 03:33PM
796
February 27, 2014 08:20PM
811
February 28, 2014 11:07AM
877
March 03, 2014 04:35PM
927
March 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.