Bug #90699 Add X protocol replication topology change notice
Submitted: 30 Apr 2018 18:19 Modified: 30 Sep 2020 13:07
Reporter: Jason Rahman Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Connection Handling Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[30 Apr 2018 18:19] Jason Rahman
MySQL doesn't support a notice type that indicates when the replication topology changes, which is useful for clients that care about knowing the topology of slaves and current master, and for responding to changes to that topology, as well as proxies that may want to know about that information as well.

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

Suggested fix:
Add a new notice type that describes the state of the replication topology when it changes, including what node is the current master. Additionally, support custom key-value pairs to be included in the notice that can be set by the administrative queries that trigger voluntary promotions. For Group Replication, the topology is determined by the GR plugin, while for normal MySQL replication, register slave, and the various replication queries control the replication state.
[30 Sep 2020 13:07] MySQL Verification Team
Thank you for the feature request.