List:Replication« Previous MessageNext Message »
From:Chad Morland Date:September 8 2011 8:54pm
Subject:5.0 Master -> 5.1 Slave replication issues
View as plain text  
I have a new slave server that has MySQL 5.1 on it and I have a 5.0
Master server. As I understand it this is a valid setup.

It seems as if the 5.1 server's replication is falling far behind the
master even though it appears as if replication is functioning
properly otherwise. As you can see from the master it is on binlog
mysqld-bin.000492 but the slave thinks it is on mysqld-bin.000479.

I added this server yesterday and at first it was replicating as
expected but sometime between then and now replication has fallen
behind.

How can I debug this or is there something going on that I am missing?

On the master:
mysql> show master status;
+-------------------+----------+--------------+------------------+
| File              | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| mysqld-bin.000492 | 30577992 |              |                  |
+-------------------+----------+--------------+------------------+

On the slave:
Slave_IO_State: Waiting for master to send event
....
Master_Log_File: mysqld-bin.000479
Read_Master_Log_Pos: 501583254
Relay_Log_File: mysqld-relay-bin.000029
Relay_Log_Pos: 28558189
Relay_Master_Log_File: mysqld-bin.000479
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
...
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 501582733
Relay_Log_Space: 501583694
...
Seconds_Behind_Master: 0
Thread
5.0 Master -> 5.1 Slave replication issuesChad Morland8 Sep
  • Re: 5.0 Master -> 5.1 Slave replication issuesPrabhat Kumar8 Sep
    • Re: 5.0 Master -> 5.1 Slave replication issuesRick James8 Sep
      • Re: 5.0 Master -> 5.1 Slave replication issuesChad Morland9 Sep
        • Re: 5.0 Master -> 5.1 Slave replication issuesSuresh Kuna9 Sep