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
