Comments - Configuring the MariaDB Monitor
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.
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:
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.