We currently have a mariab galera cluster with 7 nodes; 3 on local and 4 on Azure cloud. All nodes are using Mariadb 10.5.16 version. My issue is that on my local cluster when I run the following query:
SELECT created_at,updated_at FROM stuffs WHERE ref_num = "XXX123";
My Local Nodes return: (incorrect time)
|2020-12-18 02:00:19||2020-12-18 02:01:51|
While my Azure nodes return: (correct time)
|2020-12-17 13:00:19||2020-12-17 13:01:51|
I checked the date and time on the servers and they return the same. Same with select NOW() and TIMESTAMP().
When the application inserts and fetched the data, it inserts and returns the correct date and time. But when queried from the local nodes it returns a different value.
Will there be any issues with the data itself on the database? Is there any way to fix this mismatch? Thanks