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.
1851
February 14, 2014 05:13PM
897
February 16, 2014 12:16AM
1371
February 16, 2014 09:07AM
872
February 17, 2014 11:44AM
1019
February 17, 2014 01:31PM
962
February 20, 2014 12:44PM
975
February 26, 2014 12:21PM
888
February 26, 2014 03:33PM
798
February 27, 2014 08:20PM
823
February 28, 2014 11:07AM
879
March 03, 2014 04:35PM
937
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.