[MXS-4754] More information via list servers Created: 2023-09-12  Updated: 2023-12-15

Status: Open
Project: MariaDB MaxScale
Component/s: maxctrl
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Bryan Bancroft (Inactive) Assignee: Joe Cotellese
Resolution: Unresolved Votes: 0
Labels: None
Environment:

any version



 Description   

Maxscale requires GTID repl for failover but servers show gtid by default. I would like a better display of information on this since if a slave is rebuilt and misconfigured with basic binlog_pos it at a glance looks like maxscale is heathy but is in fact no longer HA. This is disastrous if a master goes and stays down to get a replica promoted.

For usability a display like below is ideal to see what the current service status really is

[ACME] root@maxscale-1: etc # maxctrl list servers
┌───────────┬──────────────┬──────┬─────────────┬─────────────────┬────────┬─────────────────┐
│ Server    │ Address      │ Port │ Connections │ State           │ GTID   │ Monitor         │
├───────────┼──────────────┼──────┼─────────────┼─────────────────┼────────┼─────────────────┤
│ fooshop-1 │ 131.21.1.185 │ 3306 │ 0           │ Master, Running │ 0-1-90 │ MariaDB-Monitor │
├───────────┼──────────────┼──────┼─────────────┼─────────────────┼────────┼─────────────────┤
│ fooshop-2 │ 131.21.1.248 │ 3306 │ 0           │ Slave, Running  │ NOT USING GTID REPL │ MariaDB-Monitor │
├───────────┼──────────────┼──────┼─────────────┼─────────────────┼────────┼─────────────────┤
│ fooshop-3 │ 131.21.1.89  │ 3306 │ 0           │ Slave, Running  │ NOT USING GTID REPL │ MariaDB-Monitor │
└───────────┴──────────────┴──────┴─────────────┴─────────────────┴────────┴─────────────────┘

The slaves here are clearly configured but ineligible for failover



 Comments   
Comment by markus makela [ 2023-09-13 ]

The GTID is the GTID position, not how the GTIDs are being replicated. Not displaying it for the cases where file+position replication is used would break it for all users who use it. I think this would be better solved by adding the information in maxctrl show services and show monitors (have you checked these already?) where the other fine details of replication are located.

Generated at Thu Feb 08 04:30:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.