Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10439

mysql_tzinfo_to_sql DDL clears other tables on Galera cluster

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              tcx tiago caxias
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.