89473

Replication and Time Zones

The same system time zonę should be set for both master and slave. Otherwise, State ments

depending on the local time on the master are not replicated properly, such as statements that use

the NOWO [1240] or FROM_UNIXTIME () [1238] functions. You can set the time zonę in which MySQL

server runs by using the --timezone= timezone_name [239] option of the

mysqld_safe script or by

setting the TZ em/ironment variable. See also Section 16.4.1.15, "Replication and System Functions".

If the master is MySQL 4.1 or earlier, both master and slave should also use the same default

connection time zonę. That is, the --default-time-zone [434] parameter should have the same

value for both master and slave.

CONVERT_TZ    @gsession. time_zone) [1232] is properly replicated

only if both master

and slave are running MySQL 5.0.4 or newer.