MySQL Forums
Forum List  »  Replication

Slave not getting updates
Posted by: A S
Date: September 08, 2014 07:37AM

Hi,
I am having a problem setting up master/slave replication for the first time.
The master is on an old Debian box running mysql 5.0.51, the slave is on an ubuntu box running 5.5.38. I want to implement one-way replication of a single database.

The problem is that although the slave reports that it is up-to-date (' Slave_IO_State: Waiting for master to send event', 'Seconds_Behind_Master: 0'), it is not actually replicating changes and the 'Read_Master_Log_Pos:' (996) is falling behind the position shown on the master (1098). Master log files match on master and slave

This is on a master database where no changes are currently taking place unless I initiate them (i.e. a record add or delete).
There are no errors in the logs of either the master or the slave

Sometimes - i'm not sure what triggers this, it could be a mysql restart on either the server or the slave), the slave will get up-to-date, but it is not happening on anything like a reliable, regular basis.

Any ideas what I do next?

mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 78.109.160.124
Master_User: slave_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000011
Read_Master_Log_Pos: 996
Relay_Log_File: mysqld-relay-bin.000027
Relay_Log_Pos: 923
Relay_Master_Log_File: mysql-bin.000011
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: admin_vouchers
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: 996
Relay_Log_Space: 1436
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
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1

mysql> show processlist\G;
*************************** 1. row ***************************
Id: 1
User: system user
Host:
db: NULL
Command: Connect
Time: 6678
State: Waiting for master to send event
Info: NULL
*************************** 2. row ***************************
Id: 2
User: system user
Host:
db: NULL
Command: Connect
Time: 3557
State: Slave has read all relay log; waiting for the slave I/O thread to update it
Info: NULL
*************************** 3. row ***************************

on master...

mysql> show processlist\G;
*************************** 1. row ***************************
Id: 12
User: mysqladmin
Host: localhost
db: admin_vouchers
Command: Sleep
Time: 6445
State:
Info: NULL
*************************** 2. row ***************************
Id: 17600
User: slave_user
Host: 5.57.57.18:35060
db: NULL
Command: Binlog Dump
Time: 2924
State: Has sent all binlog to slave; waiting for binlog to be updated
Info: NULL

mysql> show master status \G
*************************** 1. row ***************************
File: mysql-bin.000011
Position: 1098
Binlog_Do_DB: admin_vouchers
Binlog_Ignore_DB:

Options: ReplyQuote


Subject
Views
Written By
Posted
Slave not getting updates
2503
A S
September 08, 2014 07:37AM
1316
A S
September 08, 2014 09:07AM
1101
September 09, 2014 11:20AM
1127
A S
September 09, 2014 02:48PM
1205
September 09, 2014 04:28PM
1215
September 08, 2014 02:35PM
1439
A S
September 09, 2014 02:26AM
1064
September 09, 2014 10:48AM
1003
A S
September 09, 2014 11:18AM


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.