MySQL Forums
Forum List  »  Replication

Re: measuring slave lag without sysdate() - 4.1.13
Posted by: Rick James
Date: February 08, 2012 02:09AM

The goal of replication is to have exactly the same stuff on the slave -- including NOW(), RAND(), etc.

The Heartbeat should insert NOW() (or SYSDATE()), let it replicate, then check to see how out-of-date the value is when you read it on the slave. You need to Master and Slave to be reasonably synchronized, say by NTP.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: measuring slave lag without sysdate() - 4.1.13
1006
February 08, 2012 02: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.