MySQL Forums
Forum List  »  Replication

replication across different time zones
Posted by: Andrew Nimmo
Date: February 07, 2005 08:09AM

i have a replication setup with a master in timezone Europe/Madrid and a slave in Europe/London. the slave server is started with TZ=Europe/Madrid to ensure both servers use the same times and dates. is this sufficient? there are occasions where the slave doesn't update (almost) immediately on a master update but instead can take some minutes, or 10's of minutes. i will shortly be doing further tests to determine if there's a pattern to the delays.

Options: ReplyQuote

Written By
replication across different time zones
February 07, 2005 08:09AM

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.