Bug #72308 | Bad replication of manually inserted TIMESTAMP between different timezones | ||
---|---|---|---|
Submitted: | 10 Apr 2014 15:56 | Modified: | 23 Jun 2014 16:59 |
Reporter: | Giancarlo Nebiolo | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 5.6.11 | OS: | Linux |
Assigned to: | David Moss | CPU Architecture: | Any |
Tags: | mixed, replication, timestamp, timezones |
[10 Apr 2014 15:56]
Giancarlo Nebiolo
[10 Apr 2014 15:58]
Giancarlo Nebiolo
Adjusting the tags
[11 Apr 2014 15:01]
Hartmut Holzgraefe
When using MySQL timezone SYSTEM the master and slave assume that they are in the same timezone ... you need to explicitly set the mysql time_zone when replicating between servers in different time zones ...
[11 Apr 2014 16:40]
Giancarlo Nebiolo
Thanks for the tip Hartmut, I changed the value of the variable 'time_zone' of each server to the same value of the 'system_time_zone' variable and it worked. But I find troublesome that fact, if both servers have different values of the 'system_time_zone' both servers should detect that the value 'SYSTEM' in the 'time_zone' variable is not the same between them or at least that behavior must be documented in the MySQL reference manual to avoid that an inexperienced user fall in these types of problems. I had read the manual and didn't see anything nor in the section concerning the issues with replication and the time zones (http://dev.mysql.com/doc/refman/5.6/en/replication-features-timezone.html) nor in the "MySQL Server Time Zone Support" section (https://dev.mysql.com/doc/refman/5.6/en/time-zone-support.html), If you find that I am wrong please correct me.
[11 Apr 2014 16:49]
Hartmut Holzgraefe
Hmm ... I thought it was documented in the "Replication and Time Zones" section, but it indeed still isn't ... So maybe the bug category should be changed to "Documentation" to reflect this ...
[11 Apr 2014 18:38]
Giancarlo Nebiolo
Done, I changed the category from 'MySQL Server: Binlog(replication)' to 'MySQL Server: Documentation'
[18 Apr 2014 17:21]
Sveta Smirnova
Thank you for the feedback. Verified as described. While the page says that "The same system time zone should be set for both master and slave." it does not mention that time zone SYSTEM does not mean the same time zone for both servers.
[23 Jun 2014 16:59]
David Moss
Thanks for your feedback all. I have updated the time zone content to include your changes. Commit number 39127. The updated content is available here: http://dev.mysql.com/doc/refman/5.6/en/replication-features-functions.html http://dev.mysql.com/doc/refman/5.6/en/replication-features-timezone.html and also in the 5.7 refman.