Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by confidus: -------------------------------- I am in the very early stages of testing out our Galara cluster with innodb databases. I have a tool that is comparing data against each node on the cluster and I have found that timestamps seem to be the only thing that is inconstant and by exactly 5 hours. I have a record in a Galera cluster that has a field with date time. I took one database and started comparing each table (one by one). I had several thousand records with different timestamps. An example is 2013-07-03 11:13:59, but another server, the date time is 2013-07-03 16:13:59. I would suspect that the times would be synced everywhere exactly the same. If I run a "SELECT NOW();" on all four servers at the same time, I see: +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ If I run a select @@global.time_zone, @@session.time_zone on all four nodes in the cluster, I also see +--------------------+---------------------+ | @@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | SYSTEM | SYSTEM | +--------------------+---------------------+ And if I enter date on all 4 machines, the time matches just fine. I have checked other non erip databases (some very large databases) and things are correct within those systems. [root@a2 ~]# mysql -u root -p********** -h a2 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 11:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ [root@a2 ~]# mysql -u root -p********** -h a3 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 16:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ [root@a2 ~]# mysql -u root -p********** -h a4 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 16:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/timestamps-are-different/