Hi,
Depending on you environment, rdate might work. On solaris, it can sync 2
clocks, on Digital UNIX, it gets the 'average' of clocks it can find.
Regards
Quentin
-----Original Message-----
From: Leonardo Dias [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 09:27
To: [EMAIL PROTECTED]
Subject: Problems with Replication
The problem I'd like to report is when there's an insert with now() in a
datetime field.
The problem is that, when both servers doesn't have their clocks
synchronized, the value of the now() in the Master will be different
from that in the Slave.
I've tried it with MySQL 3.23.32 in both servers.
I believe MySQL should do a simple conversion so that the binary log
would record the values of that INSERT and pass those values to the
slave. Or maybe MySQL should do its own time syncronization, I'm not
sure what's best.
Either way, I'm looking for a faster solution. Is there a good tool to
sync clocks in two computers (one acting as master)?
Thanks,
--
Leonardo Dias
Catho Online
WebDeveloper
http://www.catho.com.br/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
