MySQL Replication eror... and the Slave never catches up with the Master
Posted by:
Sachin KP
Date: July 17, 2007 11:36PM
I have a replication system with one Master and one Slave.
My problem is the slave never catches up with the Master.
I keep getting the error "10917 seconds behind"
The seconds behind time keeps on increasing and it never catches up with the master.
The Master MySQL box was upgraded recently to a new box with dual quadra processor. Ever since the upgradation was done, the Slave never catches up with the Master Server.
Is this problem is due to the upgradion/configuration?
Can any one help me out in this?
Here is the snapshot of the Slave status at 2 different instances.
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.1.40.112
Master_User: multi_admin
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysqldb-bin.000007
Read_Master_Log_Pos: 39773512
Relay_Log_File: custsql-powb02-relay-bin.000005
Relay_Log_Pos: 624326221
Relay_Master_Log_File: mysqldb-bin.000006
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: dbrestore01,dbrestore02,dbrestore03,dbrestore04,dbrestore05,dbrestore06,dbrestore07,dbrestore08,dbrestore09,dbrestore10
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: dbrestore01.%,dbrestore02.%,dbrestore03.%,dbrestore04.%,dbrestore05.%,dbrestore06.%,dbrestore07.%,dbrestore08.%,dbrestore09.%,dbrestore10.%
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 820825183
Relay_Log_Space: 733351502
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: 13082
1 row in set (0.00 sec)
ERROR:
No query specified
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.1.40.112
Master_User: multi_admin
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysqldb-bin.000007
Read_Master_Log_Pos: 40971302
Relay_Log_File: custsql-powb02-relay-bin.000005
Relay_Log_Pos: 624326221
Relay_Master_Log_File: mysqldb-bin.000006
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: dbrestore01,dbrestore02,dbrestore03,dbrestore04,dbrestore05,dbrestore06,dbrestore07,dbrestore08,dbrestore09,dbrestore10
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: dbrestore01.%,dbrestore02.%,dbrestore03.%,dbrestore04.%,dbrestore05.%,dbrestore06.%,dbrestore07.%,dbrestore08.%,dbrestore09.%,dbrestore10.%
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 820825183
Relay_Log_Space: 734549292
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: 13291
1 row in set (0.00 sec)
ERROR:
No query specified