MariaDB [(none)]> show global variables like '%osu%';
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| wsrep_osu_method | TOI |
|
+------------------+-------+
|
|
MySQL [toitest1]> create table toitest1 ( test1 boolean, test2 boolean, test3 boolean );
|
|
All nodes
|
MariaDB [toitest1]> desc toitest1;
|
+-------+------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------+------+-----+---------+-------+
|
| test1 | tinyint(1) | YES | | NULL | |
|
| test2 | tinyint(1) | YES | | NULL | |
|
| test3 | tinyint(1) | YES | | NULL | |
|
+-------+------------+------+-----+---------+-------+
|
|
|
MySQL [toitest1]> alter table toitest1 rename column test1 to test15;
|
Query OK, 0 rows affected (0.01 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
|
Writer node
|
MariaDB [toitest1]> desc toitest1;
|
+--------+------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+--------+------------+------+-----+---------+-------+
|
| test15 | tinyint(1) | YES | | NULL | |
|
| test2 | tinyint(1) | YES | | NULL | |
|
| test3 | tinyint(1) | YES | | NULL | |
|
|
All other nodes
|
|
MariaDB [toitest1]> desc toitest1;
|
+-------+------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------+------+-----+---------+-------+
|
| test1 | tinyint(1) | YES | | NULL | |
|
| test2 | tinyint(1) | YES | | NULL | |
|
| test3 | tinyint(1) | YES | | NULL | |
|
+-------+------------+------+-----+---------+-------+
|
3 rows in set (0.002 sec)
|