MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Replication fails when i restart mysql service on master
Posted by: sunil divyeshvar
Date: June 25, 2011 03:41AM

Hi ,

I have simple master-slave replication setup .
whenever i restart mysql master's service (i.e. /etc/init.d/mysqld restart) my slave server shows Seconds_Behind_Master: NULL

so then after i always used to do STOP SLAVE ; START SLAVE and then it shows Seconds_Behind_Master: 0

Why after restarting my master's service slave not connect and sync with master automatically ?

Thanks in advance.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Replication fails when i restart mysql service on master
2909
sunil divyeshvar
June 25, 2011 03:41AM
Re: Replication fails when i restart mysql service on master
828
sunil divyeshvar
June 30, 2011 10:16PM
Re: Replication fails when i restart mysql service on master
912
Shawn Taylor
July 01, 2011 08:17AM
Re: Replication fails when i restart mysql service on master
837
sunil divyeshvar
July 01, 2011 11:07AM


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.