March is not only the month when a pandemic closed all borders and people had to stay home on the quarantine; it’s also the month when daylight saving time change happens. For some regions, this is not only a time change but also a switch to a different timezone. For example, New York uses EST during winter and EDT during summer. If you use the system timezone and do not restart the MySQL server or a PXC node after the switch, you may notice that the change was not implemented.
You may end up with a situation where some of your cluster nodes still use the time zone before the switch (e.g. EST) and others use the timezone after the change (e.g. EDT).
$ date Sun Mar 8 03:03:28 EDT 2020 $ ./bin/mysql -h127.0.0.1 -P3373 -uroot test ... EDT node> show variables like '%zone%'; …[Read more]