IMO, NTP is the way to go. Time synchronizing servers when doing replication is a part of the deal. Any other solution is a bit overworkilling, when kikking some sysadmin's bottom could do the job more efficiently ;)
On Tue, Jan 20, 2009 at 3:57 AM, Alex Karasulu <[email protected]> wrote: > Hi all, > > The first thread on replication after Emmanuel's comments started taking a > turn towards the question of time synchronization across replicating > servers. Time synchronization is very nice to have and forget about while > writing the code around replication. And yes we do not have control over it > since administrators can fudge this up. > > Another alternative would be to have all the servers in the cluster > communicate with one another on occasion to share their current time to > establish offsets. These offsets (differences in time) between servers in > replication agreements can be used to correct for any time variance we might > encounter. Furthermore if the time is adjusted on the hosts, the cluster > can adjust to time changes. > > WDYT? > > Alex > -- Regards, Cordialement, Emmanuel Lécharny www.iktek.com
