|
Hi all,
We have a 3 node MariaDB Galera (versions 10.1.1[4,6]) with two async replicas.
When we load mysql_tzinfo_to_sql on one of the nodes all others get their tables emptied out.
The beginning of the mysql_tzinfo_to_sql statement truncates relevant tables and DDL statements get replicated throughout a Galera cluster.
Following insert statement, however, do not get replicated.
This may be because mysql_tzinfo_to_sql is expecting MyISAM tables and asks for replication of following DML commands but on MariaDB 10.1.1[4,6] these tables are on Aria.
After changing the tz load statement to:
root@db_host ~ # mysql_tzinfo_to_sql /usr/share/zoneinfo | sed -i 's#TRUNCATE TABLE#DELETE FROM#g' | mysql mysql it works flawlessly.
Thanks.
|