Re: [gentoo-server] [friendly reminder] sys-libs/timezone-data and MySQL

[Francesco Riosa]

>Hi!
>
>On Fri, Dec 01, 2006 at 10:30:15AM +0100, Francesco Riosa wrote:
>> > after an upgrade of sys-libs/timezone-data is good advice to update the
>> > mysql timezones tables too:
>
>Hmm... What can be affected by this? How MySQL use timezone information,
>which part of timezone information may change (and so require updates of
>sys-libs/timezone-data) and why these changes may be important for MySQL?

I did prepared a (possibly) decent answer then my MUA decided to crash and
destroy it, must be something karmik so here there is the shortened version:

sys-libs/timezone-data can change daylight saving switching day, also leap
seconds, time mangling/conversion stuff in general.
Strictly speaking you need to update timezone-data to have a sane system,
think also at "cron"ed scripts.

[TMZ] leave make suppose that most of [DTM] functions are affected. At least
if your server timezone is changed in the latest timezone-data release.

Running replication? Then [REP] will tell you subtly things that can happen
to timestamps and UPDATE/INSERT using date functions if the servers are not
in sync i.e. using the same timezone data.

Clustering? No idea and I don't even want to try.

Regards,
Francesco

[TMZ] http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
[REP] http://dev.mysql.com/doc/refman/5.0/en/replication-features.html
[DTM] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

-- 
gentoo-server@g.o mailing list