Bug #93393 Some commit may not written to binlog

• Submitted: 29 Nov 2018 3:59
• Modified: 29 Nov 2018 9:49
• Reporter: Fengchun Hua
• Status: Not a Bug
• Category: MySQL Server: Replication
• Severity: S1 (Critical)
• Version: 5.7.23
• OS: Any
• CPU Architecture: Any

[29 Nov 2018 3:59] Fengchun Hua

Description:
If you have define a parameter like 'binlog-ignore-db = information_schema';
and use this database, and all do 'alter otherdatabase.table rename to newname'; this ddl will not written to binlog.

How to repeat:
1. parameter binlog-ignore-db = information_schema
2. use information_schema
3. do some commit on other database.

NOT WRITTEN TO BINLOG. 

Suggested fix:
check the database that real used, and decide whether write to binlog. Not in current way.

[29 Nov 2018 9:49] MySQL Verification Team

Hello Fengchun Hua,

Thank you for taking the time to write to us, but this is not a bug and this behavior is documented in our manual. Please double-check the documentation available at https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html & https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html#option_mysqld_...

regards,
Umesh