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.

Wyszukiwarka

Podobne podstrony:
Decission for hospitalization The decision to admit a patient should be based on both social and med
28.    A reąuest received from the U.S.Committee that a Sub-Committee should be
28.    A reąuest received from the U.S.Committee that a Sub-Committee should be
The Chosen Alex Archer . rcaders should be oager for hor next ad/enture. —Pubłishers Weekly
considered from a regional point of view. At the same time imports should be placed under stronger e
Slave Errors During Replication If a statement produces the same error (identical error codę) on bot
53194 smpb 31 The road to health and strength is via the Atlas System seems rcally to be better than
sprintinst 8 Iever to slowly speed up engine . The pick-up from idle should be smooth and even. List
14FIG11 Routing Packets on the Same Ring "There s no Rl bit set on this packet, so I II ig
REYIEWS 249 In his Preface to the second edition, the aut hor said, “Things should be viewed and dis
(12) Provision should be madę for research into the paediatric use of medicinal products which
Logistyka - nauka means that they should be accessible for vessels of 1500 deadweight, they should h

więcej podobnych podstron