Boosting High Availability and Performance with MariaDB Galera Cluster and MaxScale-Managed Replica

Abstract

In this session/talk, we will discuss the benefits and working principles of integrating a resilient Slave/Replica node within MariaDB Galera Cluster using MaxScale. The focus will be on how this architecture enhances high availability, ensuring that even if the nodes in the Galera cluster go down, the Slave/Replica node can automatically reconnect to the new node as long as at least one node remains operational. We’ll cover how this setup supports continuous operation, enables offloading complex read queries to the Slave/Replica node, and optimizes overall performance by reducing the load on the MariaDB Galera cluster. The session will also provide an overview of the key concepts and steps involved in implementing this solution, offering valuable insights into database resilience and scalability.

Pramod Mahto