The same system time zone should be set for both master and
slave. Otherwise, some statements will not be replicated
properly, such as statements that use the
NOW() or
FROM_UNIXTIME() functions. You
can set the time zone in which MySQL server runs by using the
--timezone=
option of the timezone_namemysqld_safe script or by
setting the TZ environment variable.
Starting with MySQL 4.1.3, both master and slave should use the
same default connection time zone. That is, the
--default-time-zone parameter
should have the same value for both master and slave. However,
if the master runs MySQL 5.0 or later, this is not necessary.
CONVERT_TZ(...,...,@@global.time_zone)
is not properly replicated.

User Comments
Add your own comment.