MySQL Forums
Forum List  »  Replication

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Replication eror... and the Slave never catches up with the Master
4244
July 17, 2007 11:36PM


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.