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

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;

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)

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)