Public bug reported: Description: Many of the FLUSH commands are bin-logged (but not all), and if GTID mode enabled, adding GTID sequence with local UUID.
These commands also do not respect super_read_only=1. An example ones affected: FLUSH SLOW LOGS FLUSH HOSTS FLUSH STATUS FLUSH PRIVILEGES FLUSH USER_RESOURCES etc. Not affected: FLUSH LOGS FLUSH ENGINE LOGS FLUSH BINARY LOGS This may cause replication problems later as the cluster becomes inconsistent. Upstream report: https://bugs.mysql.com/bug.php?id=88720 Somewhat related bugs: https://bugs.mysql.com/bug.php?id=83232 https://bugs.launchpad.net/percona-server/+bug/1631816 How to repeat: Test case seen in upstream report. Suggested fix: I don't see much sense in actually replicating these FLUSH commands at all, especially that most of them are related to local resources, which can be different on the slave side. If though any of these *has* to be replicated/bin-logged for some reason, it should respect at least the super_read_only setting. ** Affects: mysql-server Importance: Unknown Status: Unknown ** Affects: percona-server Importance: Undecided Status: Confirmed ** Affects: percona-server/5.6 Importance: Undecided Status: Confirmed ** Affects: percona-server/5.7 Importance: Undecided Status: Confirmed ** Tags: i212904 ** Also affects: percona-server/5.6 Importance: Undecided Status: New ** Also affects: percona-server/5.7 Importance: Undecided Status: New ** Bug watch added: MySQL Bug System #88720 http://bugs.mysql.com/bug.php?id=88720 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=88720 Importance: Unknown Status: Unknown ** Changed in: percona-server/5.6 Status: New => Confirmed ** Changed in: percona-server/5.7 Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Server/Client Support Team, which is subscribed to MySQL. Matching subscriptions: Ubuntu Server/Client Support Team https://bugs.launchpad.net/bugs/1736921 Title: Inconsistent and unsafe FLUSH behavior in terms of replication To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1736921/+subscriptions -- Mailing list: https://launchpad.net/~enterprise-support Post to : [email protected] Unsubscribe : https://launchpad.net/~enterprise-support More help : https://help.launchpad.net/ListHelp
