SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Hybrid View
-
Dec 25, 2008, 20:26 #1
Replication is not running all of a sudden! How to fix this?
Hello,
We have 2 servers in replication mode.
The Slave server all of a sudden is not getting updated with the data from Master. That is when one issues the command Show Slave Status on slave server all one sees is:
Seconds_Behind_Master: NULL
I am MySQL developer but not the MySQL Admin.
Our Admin is gone away for a long end of the year holidays, so I am at my wits end to get this URGENT problem fixed.
Your help in this matter is greatly appreciated.
-
Dec 26, 2008, 23:04 #2
What version of MySQL are you running? Was the server recently restarted? Did you try the MySQL command start slave; ??
-
Dec 26, 2008, 23:40 #3
Hi,
MySQL running on Master & Slave server is:
mysql Ver 14.7 Distrib 4.1.11, for redhat-linux-gnu (i686)
About whether server was recently started, I think yes.
Well we have a start slave script, batch file to be exact, which I have issued many times. It is: start_slave
which contains this directive:
/usr/bin/mysql --user=root --password=xxxx95 --execute "SLAVE START;"
And still nothing, the Replication keeps not running, with this result:
Seconds_Behind_Master: NULL
indicating that Replication is not running.
Thanks for your help on this urgent matter.
BTW, I am prepared to pay you even to have this problem resolved at once since it is so urgent. I think it should not take more than 1 hour of some one who is really competent in MySQL with some expertise in Replication to figure out quickly want went wrong all of a sudden that has caused Replication to stop running.
Regards,
-
Dec 27, 2008, 11:16 #4
Hi,
Just wanted to let you know of some more related info.
I went MyTop and observed the MySQL processes running on Slave server,
and saw that it seems to be hanging at this point: That is at PID 8671
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
8674 root localhost test 0 Query show full processlist
8671 system us 200 Connec Has read all relay log; waiting for the slave I/O thread to up
In fact this process was up to 145000 Seconds until I killed it and re-started Slave. After I restarted Slave then again it started hanging at this process that is reporting:
Has read all relay log; waiting for the slave I/O thread to up
Regards,
Bookmarks