[MXS-4315] Access to maxscale status/config from within the database cli Created: 2022-09-23  Updated: 2023-10-04  Resolved: 2023-10-04

Status: Closed
Project: MariaDB MaxScale
Component/s: maxctrl
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Trivial
Reporter: Isaac Venn (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 1
Labels: Maxscale, SkySQL:Feature


 Description   

This is a request to expose some status and config variables of maxscale from within the database cli (mariadb/mysql/etc). The general idea is to log in to the database through the maxscale instance, and while within that database cli, commands could be issued that would return status values from the overlying maxscale instance.

example

$> mariadb -u username -h maxscale-host -P 4006
 
MariaDB [(none)]> show maxscle status like 'causal_r%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| causal_reads | ON    |
+---------------+-------+
1 row in set (0.005 sec)

This could allow for SkySQL clients to be able to view maxscale information.



 Comments   
Comment by markus makela [ 2022-09-26 ]

This could be quite implemented as a filter which would allow you to choose whether you want to pay the cost of having to parse the query for the custom SQL.

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