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.
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.