mysql使用 replication 做主從,如果從上添加觸發器,insert 語句有 now()時,需要在服務器啟動項中添加default-time-zone。否則會引發時區問題。
?
16.4.1.31.?Replication and Time Zones
?
The same system time zone should be set for both master and slave. Otherwise, statements depending on the local time on the master are not 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_name
mysqld_safe
?script or by setting the?
TZ
?environment variable. See also?
Section?16.4.1.14, “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 zone. That is, the?
--default-time-zone
?parameter should have the same value for both master and slave.
CONVERT_TZ(...,...,@@session.time_zone)
?is properly replicated only if both master and slave are running MySQL 5.0.4 or newer.
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
