SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2007
    Posts
    65
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Data is not replicating to slave

    Data is not being replicated to one of my slave servers. The slave server has slave_skip_errors=off in my.cnf. Other servers are replicating data properly.

    On SHOW SLAVE STATUS it does not show any error and
    Seconds_Behind_Master: 0
    After posting in the forum, I was continuously looking at SHOW SLAVE STATUS output. Once I noticed the following (bold letters)
    Slave_IO_State: Reconnecting after a failed master event read
    Master_Host: 192.168.0.61
    Master_User: user
    Master_Port: 3306
    Connect_Retry: 60
    Master_Log_File: mysql-bin.000343
    Read_Master_Log_Pos: 83728304
    Relay_Log_File: bg5-relay-bin.000058
    Relay_Log_Pos: 1336401
    Relay_Master_Log_File: mysql-bin.000343
    Slave_IO_Running: No
    Slave_SQL_Running: Yes
    Replicate_Do_DB: database_name
    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: 83728304
    Relay_Log_Space: 1336401
    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: NULL
    How can I find the issue?
    Last edited by gyro; Apr 30, 2008 at 07:56. Reason: Added SHOW SLAVE STATUS output

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    have you looked through this page yet? http://dev.mysql.com/doc/refman/5.1/...-problems.html
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  3. #3
    SitePoint Enthusiast
    Join Date
    Sep 2007
    Posts
    65
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I had already fixed the problem with the help of a sentence on the same page i.e.
    If you have followed the instructions, and your replication setup is not working, the first thing to do is check the error log for messages.
    I checked the error log and found that I need to increase max allowed packet size. And this fixed my problem.

    Thanks longneck.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •