Status: Pending Release
Affects Version/s: None
**Reported in Launchpad by Przemek last update 07-12-2017 13:25:26
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 ENGINE LOGS
FLUSH BINARY LOGS
This may cause replication problems later as the cluster becomes inconsistent.
Somewhat related bugs:
How to repeat:
Test case seen in upstream report.
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.