Comments - Changes & Improvements in MariaDB 10.0
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hello,
With multi-source replication, will data only remain consistent if all Masters are on the same timezone as the Slave? Is there plans to migrate the Global time-zone value to a per-connection basis, when it comes to multi-source replication?
If you know how to make the data inconsistent with multi-source replication and the different time-zone values, please submit a bug report at mariadb.org/jira
Perhaps my original question needs clarification.
With multi-source replication, you are obviously dealing with multiple Masters going to a single Slave. What if one (or more) of those Masters were configured for a different time zone? How does multi-source replication cater for Masters that are on a different time zone to the Slave? Wouldn't there be a conflict as far as date values are concerned?
Each slave is running in a different connnection and each connection can have and work with different timezones. That means that each connection in a multi-source setup works exactly like if you would have a normal master-slave setup.
Timestamp and NOW() are replicated in GMT, and is thus independent of timezones.
TIME, DATETIME and DATE are replicated verbatim and there is no timezone involved either on master or slave.