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

              Assignee:
              danblack Daniel Black
              Reporter:
              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.