MariaDB MaxScale Load Balancer

Table of Contents

• Installing MariaDB MaxScale Load Balancer
• Machine and ssh key
• Adding a new MaxScale Load Balancer
• Settings tab
• Checks tab
• Operations tab

Installing MariaDB MaxScale Load Balancer

FromDual Ops Center only supports MariaDB MaxScale version 6 (v2.6) and newer.

Before you start you should install the MariaDB MaxScale Load Balancer package on the machines where the MaxScale Load Balancer should reside.

MariaDB MaxScale can be downloaded from here: Download MariaDB.

Note: MariaDB MaxScale is licensed under Business Source License (BSL).

When you have downloaded the package you can install it as follows:

apt install ./maxscale-*.deb   # for Debian and Ubuntu
dnf localinstall ./maxscale-*.rpm   # For Redhat based distributions

Machine and ssh key

Ideally you add a Machine in Ops Center where the MaxScale Load Balancer resides. If you omit this step you should copy over at least the ssh Public Key of the Web-Server user to the Machine the Galera Load Balancer resides. For a Debian based distribution this is done as follows:

sudo ssh-copy-id -i /var/www/.ssh/id_?sa.pub -p 22 root@10.139.158.117

Adding a new MaxScale Load Balancer

To add a new Load Balancer to the Ops Center click on the Load Balancer item in the menu on the left and then click the Add Load Balancer button:

If MaxScale is added successfully to the Ops Center repository start the Load Balancer under the Operations tab...

Settings tab

Coming soon...

Checks tab

Coming soon...

Operations tab

Here you can do the following actions: Stop Load Balancer, Start Load Balancer, Restart Load Balancer and Drain node or Undrain node on the icons to the right.

Note: Configuration of MariaDB MaxScale with Ops Center is currently NOT possible. You have to do it manually in the MariaDB MaxScale configuration file on the Machine.

At the bottom of the page you can see the last 20 lines of the MaxScale error log (journalctl