On Sun, Mar 12, 2006 at 08:58:08PM +1100, Zoong PHAM wrote:
> How do I change timezone with minimum impact to MySQL databases and web
> applications?
> Is that simple as:
> - stop Web apps
> - stop MySQL
> - rm /etc/localtime
> - ln /usr/share/zoneinfo/a_country/a_city /etc/localtime
> - reboot server.
>
> If the new timezone has the same time (same offset compared to GMT) as
> the current timezone, do I still have to stop web apps, MySQL before?
> And do I have to reboot the server after?
>
> The reason is to avoid dealing with daylight saving.
> The server is hosted at a data center in different country.
> The server time is set to the timezone where I live.
> Day light saving is applicable to both the timezone of the data center
> and where I live.
> The new timezone has no day light saving.
>
> I use the built-in ntp to sync time with pool.ntp.org.
>
> OpenBSD-3.6 with latest patches.
While upgrading the OpenBSD version might be advisable, the above should
more or less work. The least disruptive way to create the new file is
probably something like
ln -s /usr/share/zoneinfo/a_country/a_city /etc/localtime.new
mv /etc/localtime{.new,}
There is no need to reboot the server, but you might want to restart
some services - which, I'm not sure. Rebooting the server is by far the
easiest, though.
Joachim
