Verified with PXC 5.5.37.
On aync master:
mysql> use test; Database changed mysql> mysql> CREATE TABLE `t1` ( -> `i` int(11) NOT NULL AUTO_INCREMENT, -> `c` char(32) DEFAULT 'dummy_text', -> PRIMARY KEY (`i`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.06 sec)
mysql> select * from t1; Empty set (0.00 sec)
mysql> insert into t1(i) values(null); Query OK, 1 row affected (0.05 sec)
mysql> select * from t1; +---+------------+ | i | c | +---+------------+ | 1 | dummy_text | +---+------------+ 1 row in set (0.00 sec)
mysql> insert into t1(i) values(null), (null), (null); Query OK, 3 rows affected (0.03 sec) Records: 3 Duplicates: 0 Warnings: 0
mysql> select * from t1; +---+------------+ | i | c | +---+------------+ | 1 | dummy_text | | 2 | dummy_text | | 3 | dummy_text | | 4 | dummy_text | +---+------------+ 4 rows in set (0.00 sec)
on slave (PXC clusternode1/2/3)
mysql> show variables like '%increment%'; +------------------------------+-------+ | Variable_name | Value | +------------------------------+-------+ | auto_increment_increment | 3 | | auto_increment_offset | 1 | | div_precision_increment | 4 | | innodb_autoextend_increment | 8 | | wsrep_auto_increment_control | ON | +------------------------------+-------+ 5 rows in set (0.00 sec)
mysql> use test 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 mysql> mysql> mysql> select * from t1; +---+------------+ | i | c | +---+------------+ | 1 | dummy_text | | 2 | dummy_text | | 4 | dummy_text | | 7 | dummy_text | +---+------------+ 4 rows in set (0.00 sec)
mysql>
Verified with PXC 5.5.37.
On aync master:
mysql> use test;
Database changed
mysql>
mysql> CREATE TABLE `t1` (
-> `i` int(11) NOT NULL AUTO_INCREMENT,
-> `c` char(32) DEFAULT 'dummy_text',
-> PRIMARY KEY (`i`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.06 sec)
mysql> select * from t1;
Empty set (0.00 sec)
mysql> insert into t1(i) values(null);
Query OK, 1 row affected (0.05 sec)
mysql> select * from t1;
+---+------------+
| i | c |
+---+------------+
| 1 | dummy_text |
+---+------------+
1 row in set (0.00 sec)
mysql> insert into t1(i) values(null), (null), (null);
Query OK, 3 rows affected (0.03 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select * from t1;
+---+------------+
| i | c |
+---+------------+
| 1 | dummy_text |
| 2 | dummy_text |
| 3 | dummy_text |
| 4 | dummy_text |
+---+------------+
4 rows in set (0.00 sec)
on slave (PXC clusternode1/2/3)
mysql> show variables like '%increment%'; ------- ------- ------- ---+--- ----+ ------- ------- ------- ---+--- ----+ increment | 3 | offset | 1 | increment | 4 | autoextend_ increment | 8 | increment_ control | ON | ------- ------- ------- ---+--- ----+
+------
| Variable_name | Value |
+------
| auto_increment_
| auto_increment_
| div_precision_
| innodb_
| wsrep_auto_
+------
5 rows in set (0.00 sec)
mysql> use test
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
mysql>
mysql>
mysql> select * from t1;
+---+------------+
| i | c |
+---+------------+
| 1 | dummy_text |
| 2 | dummy_text |
| 4 | dummy_text |
| 7 | dummy_text |
+---+------------+
4 rows in set (0.00 sec)
mysql>