Confirming bug on 5.6 as well but slightly different outcome:
On node1: mysql> show master status; +------------------+----------+--------------+------------------+------------------------------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+----------+--------------+------------------+------------------------------------------+ | mysql-bin.000003 | 191 | | | 34408038-5c99-11e7-b402-00163e4de30b:1-4 | +------------------+----------+--------------+------------------+------------------------------------------+ 1 row in set (0.00 sec)
mysql> select @@sql_log_bin; +---------------+ | @@sql_log_bin | +---------------+ | 1 | +---------------+ 1 row in set (0.00 sec)
mysql> select @@global.sql_log_bin; +----------------------+ | @@global.sql_log_bin | +----------------------+ | 1 | +----------------------+ 1 row in set (0.00 sec)
mysql> set sql_log_bin=0; Query OK, 0 rows affected (0.01 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> create table nobinlog (id int primary key auto_increment not null, s varchar(10)) engine=innodb; Query OK, 0 rows affected (0.03 sec)
mysql> show master status; +------------------+----------+--------------+------------------+------------------------------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+----------+--------------+------------------+------------------------------------------+ | mysql-bin.000003 | 191 | | | 34408038-5c99-11e7-b402-00163e4de30b:1-4 | +------------------+----------+--------------+------------------+------------------------------------------+ 1 row in set (0.00 sec)
One node2: before create table: mysql> show master status; +------------------+----------+--------------+------------------+------------------------------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+----------+--------------+------------------+------------------------------------------+ | mysql-bin.000004 | 191 | | | 34408038-5c99-11e7-b402-00163e4de30b:1-4 | +------------------+----------+--------------+------------------+------------------------------------------+ 1 row in set (0.00 sec)
after create table: mysql> show master status; +------------------+----------+--------------+------------------+----------------------------------------------------------------------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+----------+--------------+------------------+----------------------------------------------------------------------------------+ | mysql-bin.000004 | 408 | | | 34408038-5c99-11e7-b402-00163e4de30b:1-4, 4dd1edef-ba4b-ee18-54a6-350f9802ffe9:1 | +------------------+----------+--------------+------------------+----------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
See the extra GTID on node2 after the CREATE.
Confirming bug on 5.6 as well but slightly different outcome:
On node1: ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+ ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+ 5c99-11e7- b402-00163e4de3 0b:1-4 | ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+
mysql> show master status;
+------
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------
| mysql-bin.000003 | 191 | | | 34408038-
+------
1 row in set (0.00 sec)
mysql> select @@sql_log_bin;
+---------------+
| @@sql_log_bin |
+---------------+
| 1 |
+---------------+
1 row in set (0.00 sec)
mysql> select @@global. sql_log_ bin; ------- ------- --+ sql_log_ bin | ------- ------- --+ ------- ------- --+
+------
| @@global.
+------
| 1 |
+------
1 row in set (0.00 sec)
mysql> set sql_log_bin=0;
Query OK, 0 rows affected (0.01 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> create table nobinlog (id int primary key auto_increment not null, s varchar(10)) engine=innodb;
Query OK, 0 rows affected (0.03 sec)
mysql> show master status; ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+ ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+ 5c99-11e7- b402-00163e4de3 0b:1-4 | ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+
+------
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------
| mysql-bin.000003 | 191 | | | 34408038-
+------
1 row in set (0.00 sec)
One node2: ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+ ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+ 5c99-11e7- b402-00163e4de3 0b:1-4 | ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- --+
before create table:
mysql> show master status;
+------
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------
| mysql-bin.000004 | 191 | | | 34408038-
+------
1 row in set (0.00 sec)
after create table: ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + 5c99-11e7- b402-00163e4de3 0b:1-4, ba4b-ee18- 54a6-350f9802ff e9:1 | ------- -----+- ------- --+---- ------- ---+--- ------- ------- -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- +
mysql> show master status;
+------
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------
| mysql-bin.000004 | 408 | | | 34408038-
4dd1edef-
+------
1 row in set (0.00 sec)
See the extra GTID on node2 after the CREATE.