Time Zones / Multi-Source Replication
You are viewing an old version of this question. View
the current version here.
Agenda and notes from day 2 of the MariaDB Developer Meeting in Athens, Greece.
Agenda
| Time | Main Track | Side Track |
|---|---|---|
| 09:00‑10:00 | Email & Hacking time (Public) | |
| 10:00-11:00 | GIS in MariaDB: Current status, upcoming milestones. (Public) | |
| 11:00‑11:15 | Small break | |
| 11:15-12:30 | Replication in MariaDB (Public) | |
| 12:30‑13:30 | Lunch | |
| 13:30‑14:00 | Email and hacking time. | |
| 14:00‑15:15 | Xentio Presentation (Public) | |
| 15:15‑15:45 | Coffee break | |
| 15:45-16:30 | MariaDB 5.3: Technical Status (Public) | |
| 16:30-17:30 | MariaDB 5.5: Planning (features, release theme, release dates, etc...) (Public) |
Printed Schedule (pdf)
Notes
Answer
Copying the answer from this comment:
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.
Comments
Comments loading...
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.
