Comments - Configuring the MariaDB Monitor

8 months, 1 week ago Henrik J

It would seem that this list of privileges is woefully inadequate - At least on MaxScale 23.08 with MariaDB 11.0.x - 11.2.x. After several hours of trial and error, and a myriad of error messages from MaxScale about missing privileges, I've ended up with the following list of needed privileges for the monitor user, when it also needs to be able to execute automatic failover:

GRANT REPLICATION CLIENT on *.* to 'monitor_user'@'%';
GRANT SUPER, RELOAD on *.* to 'monitor_user'@'%';
GRANT SLAVE MONITOR on *.* to 'monitor_user'@'%';
GRANT READ_ONLY ADMIN on *.* to 'monitor_user'@'%';

GRANT BINLOG ADMIN on *.* to 'monitor_user'@'%';

GRANT REPLICATION SLAVE ADMIN on *.* to 'monitor_user'@'%';

GRANT REPLICATION SLAVE on *.* to 'monitor_user'@'%';

GRANT SELECT ON mysql.user TO 'monitor_user'@'%';
GRANT SELECT ON mysql.db TO 'monitor_user'@'%';
GRANT SELECT ON mysql.tables_priv TO 'monitor_user'@'%';
GRANT SELECT ON mysql.columns_priv TO 'monitor_user'@'%';
GRANT SELECT ON mysql.procs_priv TO 'monitor_user'@'%';
GRANT SELECT ON mysql.proxies_priv TO 'monitor_user'@'%';
GRANT SELECT ON mysql.roles_mapping TO 'monitor_user'@'%';

This inadequate documentation really made me doubt the entire project, as my first experience into R/W-splitting, and whether this was actually a production ready piece of software.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.