Bug #90698 Add X protocol Read-only Changed Notice
Submitted: 30 Apr 2018 18:13 Modified: 30 Sep 2020 13:08
Reporter: Jason Rahman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Connection Handling Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[30 Apr 2018 18:13] Jason Rahman 
Description:
Documentation does not list a notice for read_only flag being changed on the instance. Having a read_only changed notice would be extremely helpful for clients that only want to read the most up to date information from the master. It would also allow proxies to track changes to the current master by observing notices from MySQL.

How to repeat:
Documentation indicates this doesn't exist yet

Suggested fix:
Add a new Global notice type when the server has changed the read_only flag. The notice should contain the new value of the flag. Currently only session variable changes via a Local notice are supported.
[30 Apr 2018 18:13] Jason Rahman 
Update priority
[30 Sep 2020 13:08] MySQL Verification Team 
Thank you for the feature request.