观察是否有违背GTID的语句

#观察是否有违背GTID的语句

mysql> set global enforce_gtid_consistency=warn;
mysql> show variables like '%gtid%';
+----------------------------------+------------------------------------------------+
| Variable_name                    | Value                                          |
+----------------------------------+------------------------------------------------+
| binlog_gtid_simple_recovery      | ON                                             |
| enforce_gtid_consistency         | WARN                                           |
| gtid_executed_compression_period | 1000                                           |
| gtid_mode                        | OFF                                            |
| gtid_next                        | AUTOMATIC                                      |
| gtid_owned                       |                                                |
| gtid_purged                      | 0e24756e-5f07-11e8-892f-fa163e41da23:1-1767285 |
| session_track_gtids              | OFF                                            |
+----------------------------------+------------------------------------------------+
8 rows in set (0.01 sec)

#观察日志

$ grep -i 'GTID' error3306.log
2018-09-03T14:52:40.952060+08:00 4973934 [Note] Changed ENFORCE_GTID_CONSISTENCY from OFF to WARN.

#插入违规语句

use school
mysql> create table student07 select * from student;
Query OK, 9 rows affected, 1 warning (0.02 sec)
Records: 9  Duplicates: 0  Warnings: 1

#观察日志

2018-09-03T14:57:53.038043Z 4 [Warning] Statement violates GTID consistency: CREATE TABLE ... SELECT.