The Ultimate Guide to High Availability with MariaDB

Comments - MaxScale Troubleshooting

1 year, 5 months ago Testing User A Test
Re: MaxScale Troubleshooting

On all the nodes, I have the following section defined on /etc/maxscale.cnf:

[MariaDB-Monitor] type=monitor

  1. module=mariadbmon module=galeramon servers=server1,server2,server3 user=monitor password=testing monitor_interval=2s

I have already created the user 'monitor' on mariadb with the following statement:

CREATE USER 'monitor'@'%' IDENTIFIED BY 'testing';

 
1 year, 5 months ago Markus Mäkelä
Re: MaxScale Troubleshooting

The Failed to connect to server 'server1' error means the monitor was not able to connect to the server when it was checking if the user configured for it has all the required grants. Usually you'll also get other errors in the log stating what the actual problem was.

I'd recommend checking the user account on server1' for any problems.

 
1 year, 5 months ago Testing User A Test
Re: MaxScale Troubleshooting

The '1.' text was changed from '#', which is a comment line on 'module=mariadbmon' statement.

 
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.