Thread: Very Precision Time for Database Server

Very Precision Time for Database Server

From
alavoor
Date:
Hello:

You must maintain a very high precision and accurate time on database
servers.
This is required especially if you read and comapre data from different
databases located on different
servers at different continents. For example a database server located
in california and another in London city.

I had the trouble in having syncing to a standard time, there were no
program available.

I wrote a small script which I run thru cron which syncs to the Atomic
clock in USA every night at 3 a.m.

US govt. spent millions to build very precision atomic clock for
International Trade and Business.

Use this very small and tiny program written in PHP.

This program runs on MS Windows 95/98/NT/2000/XP/ME and MS Windows 3.11.

This program also runs on all flavors of Unix and Linux and Apple Mac.

Please download the program from:
    http://phpclasses.upperdesign.com/browse.html/package/285




Re: Very Precision Time for Database Server

From
Alvaro Herrera
Date:
On Sat, 4 Aug 2001, alavoor wrote:

Hi:

> You must maintain a very high precision and accurate time on database
> servers.
> This is required especially if you read and comapre data from different
> databases located on different
> servers at different continents. For example a database server located
> in california and another in London city.
[...]

We had to do this, and we just used NTP for the task. What's wrong about
it?

Sorry, I think this is off-topic.

--
Alvaro Herrera (<alvherre[@]atentus.com>)