PDA

View Full Version : Date on servers out of sync>


stan
06-09-2001, 05:29 PM
After looking at some anomaly in the output of my code for some hours, I found that the time is not the same on all servers:


$ date ; mysql -h mysql.watchmouse.com[nbsp][nbsp]-e 'select now()'
Sat Jun[nbsp][nbsp]9 16:21:15 EDT 2001
+---------------------+
| now()[nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp] |
+---------------------+
| 2001-06-09 16:14:20 |
+---------------------+


Anything I can do 'bout it?

- Stan
[This message has been edited by stan (edited 06-09-01@4:32 pm)]

Terra
06-09-2001, 05:57 PM
I'll have to work on the Time Synchronization daemons for the MySQL servers...

All of the Community Servers were overhauled using taiclock, however the MySQL servers have not been brought into the system...

I will schedule this into my task list for next week...

--
Terra
--Geez, how time flies by--
FutureQuest

stan
06-10-2001, 04:24 AM
That's great. Was thinkingof a way to get the remote time or so. Thanks,