Dear List,
As recently as last Sunday January 14, 2007, we have enabled
replication between two servers in our organization.
The master server runs MySQL 4.1.10a, the slave runs 5.0.18.
Since then, we have had a number of interruptions in replication when
the slave server stopped replicating for different reasons.
I was able to fix the problems pointed out by the error log on the slave
server, but I am witnessing strange behavior on the part of the slave.
Every time, I look up slave status using "show slave status", I see the
value of Seconds_Behind_Master getting bigger nor smaller as one would
expect.
I am pasting actual reports of "show slave status" at the end of this
E-mail.
Could anyone help me to find out why the slave reports such thing, and
how to overcome it.
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: saruman
Master_User: alatarreplica
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: SB2000-bin.000139
Read_Master_Log_Pos: 857395571
Relay_Log_File: alatar-relay-bin.000005
Relay_Log_Pos: 190740012
Relay_Master_Log_File: SB2000-bin.000139
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: secdocs
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: 190663065
Relay_Log_Space: 858304045
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: 285342
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: saruman
Master_User: alatarreplica
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: SB2000-bin.000139
Read_Master_Log_Pos: 857395745
Relay_Log_File: alatar-relay-bin.000005
Relay_Log_Pos: 190740012
Relay_Master_Log_File: SB2000-bin.000139
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: secdocs
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: 190663065
Relay_Log_Space: 858304221
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: 285344
1 row in set (0.00 sec)
ERROR:
No query specified
Your help is greatly appreciated,
Mikhail Berman
Ives Group
