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

Add new mode to wsrep_OSU_method in which Galera checks storage engine of the effected table

    XMLWordPrintable

Details

    Description

      Currently, if wsrep_OSU_method is set to TOI, then Galera Cluster will replicate all DDL statements. This is true even if the effected table does not support Galera replication.

      https://mariadb.com/kb/en/library/galera-cluster-system-variables/#wsrep_osu_method

      To confirm this, I performed the following test with a 3-node cluster running MariaDB 10.3.16:

      Node 1:
       
      SET SESSION wsrep_OSU_method='TOI';
      USE db1;
      CREATE TABLE aria_tab (id int primary key) ENGINE=Aria;
      INSERT INTO aria_tab VALUES (1);
      SELECT * FROM aria_tab;
       
      Node 2:
       
      USE db1;
      SELECT * FROM aria_tab;
      INSERT INTO aria_tab VALUES (2);
      SELECT * FROM aria_tab;
       
      Node 3:
       
      USE db1;
      SELECT * FROM aria_tab;
      INSERT INTO aria_tab VALUES (3);
      SELECT * FROM aria_tab;
       
      Node 1:
       
      SELECT * FROM aria_tab;
      TRUNCATE TABLE aria_tab;
      SELECT * FROM aria_tab;
       
       
      Node 2:
       
       
      SELECT * FROM aria_tab;
       
       
      Node 3:
       
       
      SELECT * FROM aria_tab;
      

      First, the output of the CREATE and INSERT portion:

      Node 1:
       
       
      MariaDB [(none)]> SET SESSION wsrep_OSU_method='TOI';
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> USE db1;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
       
      Database changed
      MariaDB [db1]> CREATE TABLE aria_tab (id int primary key) ENGINE=Aria;
      Query OK, 0 rows affected (0.010 sec)
       
      MariaDB [db1]> INSERT INTO aria_tab VALUES (1);
      Query OK, 1 row affected (0.001 sec)
       
      MariaDB [db1]> SELECT * FROM aria_tab;
      +----+
      | id |
      +----+
      |  1 |
      +----+
      1 row in set (0.000 sec)
       
       
      Node 2:
       
       
      MariaDB [(none)]> USE db1;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
       
      Database changed
      MariaDB [db1]> SELECT * FROM aria_tab;
      Empty set (0.000 sec)
       
      MariaDB [db1]> INSERT INTO aria_tab VALUES (2);
      Query OK, 1 row affected (0.001 sec)
       
      MariaDB [db1]> SELECT * FROM aria_tab;
      +----+
      | id |
      +----+
      |  2 |
      +----+
      1 row in set (0.000 sec)
       
       
      Node 3:
       
       
      MariaDB [(none)]> USE db1;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
       
      Database changed
      MariaDB [db1]> SELECT * FROM aria_tab;
      Empty set (0.000 sec)
       
      MariaDB [db1]> INSERT INTO aria_tab VALUES (3);
      Query OK, 1 row affected (0.001 sec)
       
      MariaDB [db1]> SELECT * FROM aria_tab;
      +----+
      | id |
      +----+
      |  3 |
      +----+
      1 row in set (0.000 sec)
      

      The CREATE was replicated, but the INSERTs were not.

      Next, the output of the TRUNCATE portion:

      Node 1:
       
       
      MariaDB [db1]> SELECT * FROM aria_tab;
      +----+
      | id |
      +----+
      |  1 |
      +----+
      1 row in set (0.000 sec)
       
      MariaDB [db1]> TRUNCATE TABLE aria_tab;
      Query OK, 0 rows affected (0.010 sec)
       
      MariaDB [db1]> SELECT * FROM aria_tab;
      Empty set (0.000 sec)
       
       
      Node 2:
       
       
      MariaDB [db1]> SELECT * FROM aria_tab;
      Empty set (0.000 sec)
       
       
      Node 3:
       
       
      MariaDB [db1]> SELECT * FROM aria_tab;
      Empty set (0.000 sec)
      

      We can see that the TRUNCATE was also replicated.

      It may be a good idea to add a new method to wsrep_OSU_method in which the storage engines of any tables effected by DDL statements are checked. If the underlying table does not support Galera's replication, then the DDL is not replicated in TOI mode.

      Usually, this would mean that only DDL statements that effect InnoDB tables should be replicated.

      However, if wsrep_replicate_myisam were enabled, then DDL statements that effect MyISAM tables should also be replicated.

      https://mariadb.com/kb/en/library/galera-cluster-system-variables/#wsrep_replicate_myisam

      If we decide to implement MDEV-20050, then we should also include Aria.

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.