View Single Post
  #2  
Old 20th September 2008, 13:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,900
Thanked 2,702 Times in 2,545 Posts
Default

Quote:
Originally Posted by marchost View Post
1)If server1 reboot, will it resync automatically with server2 upon restart?
Yes, provided that the server's downtime is < expire_logs_days. If not, then there are no logs so that the server doesn't know what to replicate.


Quote:
Originally Posted by marchost View Post
2)My second question is about replication in general. Again I will suppose that server1 rebooted.

If I do (on server1)

show slave status;

I will get a "Read_Master_Log_Pos:" that does not match the output of "Position" :

(on server 2)
show master status;


Will the replication still work???
What is important is that Slave_IO_Running and Slave_SQL_Running both show Yes.
The servers might not always be 100% in sync - depending on network load or server load it can take a few seconds until a server catches up.

If you need to repair replication, this tutorial might be interesting: http://www.howtoforge.com/how-to-rep...ql-replication
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote