[MDEV-9043] plugin request: HTTP status for galera (groundwork for future REST server) Created: 2015-10-30 Updated: 2023-10-12 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Daniel Black | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Typical load balancing solutions check status with a TCP or HTTP connection. For galera, the presence of a TCP supported connection isn't sufficient. What would be ideal is if there was a small single threaded plugin that talked enough basic HTTP to convince a load balancer if galera is SYNCED. Access control can be done via firewall though like mysql a bind-address might be a viable configuration option. step 1: Galera URLs GET /galera/sync - returns 200 if in sync - 503 Sevice unavabilable enhancement 2: RESTFUL status and system variables retrieval retrieve global status/system variable value GET /status/max_used_connections - returns 200 response with status variable value enhancement 3: collection info GET /status - returns all global status enhancement 4: RESTFUL system variable change plugin variable = auth_token=xxxxxxsfsaf..... PUT /system/max_connections?auth_token=... - sets the value of a variable, enhancement 5: extend to other plugs Maybe other plugins could hook into their own base URL. |
| Comments |
| Comment by Ralf Gebhardt [ 2023-10-12 ] |
|
I have removed the fixVersion for this task as it is one of 5.5, 10.1, 10.2, 10.3, which are EOLed. Please add a new fixVersion if you plan to work on this task for a not EOLed versions. |