Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
MXS-SPRINT-270
Description
Add ways to show the number of connected replicas to the binlogrouter. The de facto standard SHOW SLAVE HOSTS as well as SHOW REPLICA HOSTS should be added as well as potentially some output in the REST-API so that maxctrl show service reports it.
Original Title: maxctrl or the REST API command to get connected slave hosts to the binlogrouter
Original Description:
maxctrl show service <binlog-service-name>
reports only the total connection count (e.g., "Current Connections: 2"), but no per-client details (IP/host, server_id, binlog position, etc.).
The corresponding REST API endpoint /v1/services/<service-name> provides the same high-level stats.
There is no visible maxctrl show binlogrouter, list slaves, or module-specific command for connected slaves.
The only functional method found is connecting to the listener port with a replication user and running SHOW SLAVE HOSTS; which works but is less ideal for automated monitoring (requires credentials, direct network access to the port, and output parsing).
Is there currently any way to retrieve a list of connected replication slaves — including at least IP/host and server_id — through maxctrl or the REST API?