How to maintain timezones in multi datacenter replication of mysql -

How to maintain timezones in multi datacenter replication of mysql -

we want new set of multi-datacenter replication mysql, placed in 2 different time zones. in scenario, right maintain single time zone in datacenters or not?

you should utilize utc ie. timestamp can used displaying right time accordig timezone.

whenever referring particular moment in time, persist time according unified standard not affected daylight savings. gmt , utc have been mentioned different people, though utc seems mentioned often. ?? include local time offset (including dst offset) when storing timestamps. ?? store timestamps utc or epochs(number of seconds since 1970) without time zone or offset. include original time zone name, can reconstruct original time @ later point , display right offsets if needed.

please refer below link, helpful

daylight saving time , time zone best practices

mysql