All pages
Powered by GitBook
1 of 1

Loading...

Galera Monitor

Designing for MaxScale's Galera Monitor

MaxScale's Galera Monitor (galeramon) monitors Galera Cluster deployments.

This page contains topics that need to be considered when designing applications that use the Galera Monitor.

  • ?

Additional information is available .

Understanding MaxScale's Galera Monitor

MaxScale's monitors deployments.

What Does the Support?

The Galera Monitor (galeramon) supports:

  • Monitoring deployments

  • Monitoring deployments

  • Query-based load balancing with the

  • Connection-based load balancing with the Read Connection Router (readconnroute)

Deploying Galera Monitor

  • Deploy MaxScale with Galera Monitor and Read/Write Split Router

  • Deploy MaxScale with Galera Monitor and Read Connection Router

Using SST Donors for Queries with MaxScale's Galera Monitor

MaxScale's monitors .

By default, when a node is chosen as a donor for a State Snapshot Transfer (SST), Galera Monitor does not route any queries to it. However, some SST methods are non-blocking on the donor, so this default behavior is not always desired.

Non-Blocking SST Methods

A cluster's SST method is defined by the system variable. When this system variable is set to mariadb-backup, the cluster uses to perform the SST. is a non-blocking backup method, so Galera Cluster allows the node to execute queries while acting as the SST donor.

Configuring Availability of SST Donors

  1. Configure the availability of SST donors by configuring the available_when_donor parameter for the Galera Monitor in maxscale.cnf.

For example:

  1. Restart the MaxScale instance.

How do I allow SST donors to execute queries
here
Galera Monitor (galeramon)
Galera Cluster
Galera Monitor
MariaDB Enterprise Cluster
MariaDB Galera Cluster
Read/Write Split Router (readwritesplit)
Galera Monitor (galeramon)
Galera Cluster
MariaDB Backup
MariaDB Backup
[galera-cluster]
type                     = monitor
module                   = galeramon
...
available_when_donor     = true
$ sudo systemctl restart maxscale
wsrep_sst_method