[MXS-1750] Add SHOW GRANTS support to MaxInfo Created: 2018-03-29  Updated: 2019-05-18  Resolved: 2019-05-18

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

Type: New Feature Priority: Trivial
Reporter: Massimo Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None


 Description   

Overview

Adding a dummy response to SHOW GRANTS allows monyog to monitor MaxScale.

Original description

In order to get external tool that monitor Mysql compatible with maxscale instance, we need to have the command :

"show grants;" get a result while we query [MaxInfo]

maxscale ~]$ mysql -u monitor -h 127.0.0.1 -p -P9003
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 22785
Server version: 10.0.0 2.1.5-maxscale 2.1.5

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> show grants;
ERROR: Unsupported show command 'grants'
MySQL [(none)]>

[MaxInfo]
type=service
router=maxinfo
user=monitor

 Comments   
Comment by markus makela [ 2018-06-12 ]

massimo.disaro downgrading priority until more details are given.

Comment by Massimo [ 2018-06-12 ]

Monyog to confirm a connection works with the server is monitoring it need that "show grants" respond succeed. If not, server is mark as down. Be able to get "show grants" responce , even standard, on maxscale, will give us the possibility to monitor maxscale status ( up and down and get s1 in case is down), monitor also the ssh stats, which can help if any memory leak are found or cpu bound. For the 'error log' i cant say how it will work but it will be a good step ahead.

Let me know if you need more info

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