What is MariaDB Enterprise and How to Manage it with ClusterControl?
Have you ever wondered what products MariaDB Enterprise has to offer? Is it different from MariaDB Community? Can I manage them with ClusterControl? MariaDB provides two distributions of their software — Enterprise and Community. The...
Migrating from Maxscale to the ProxySQL Load Balancer
A database load balancer, or proxy, is a middleware service between application layer and database layer. Application connects to the database proxy, and the proxy forwards the connection to the database. There are some benefits...
MaxScale Basic Management Using MaxCtrl for MariaDB Cluster – Part Two
In the previous blog post, we have covered 4 basic management components using the MaxCtrl command-line client. In this blog post, we are going to cover the remaining part of the MaxScale components which are...
How Load Balancing Works with DBaaS Setups
Database as a Service (DBaaS) takes away the pain of operating a database. So as a user, when you decide to use a DBaas from a cloud service provider, you would only know the database...
MaxScale Basic Management Using MaxCtrl for MariaDB Cluster
In the previous blog post, we have covered some introductions to MaxScale installation, upgrade, and deployment using MaxCtrl command-line client. In this blog post, we are going to cover the MaxScale management aspects for our...
Deploying MariaDB Replication for High Availability
MariaDB Server offers asynchronous and synchronous replication. It can be set up to have a multi-source replication or with a multi-master setup. For a read and write intensive application, a master-slave setup is common, but...
What's New in MariaDB MaxScale 2.4
MaxScale 2.4 was released on December 21st, 2019, and ClusterControl 1.7.6 supports the monitoring and managing up to this version. However, for deployment, ClusterControl only supports up to version 2.3. One has to manually upgrade...
Introduction to MaxScale Administration Using maxctrl for MariaDB Cluster
MariaDB Cluster consists of MariaDB Server with Galera Cluster and MariaDB MaxScale. As a multi-master replication solution, any MariaDB Server with Galera Cluster can operate as a primary server. This means that changes made to...
Database Load Balancing in a Multi-Cloud Environment
Multi-cloud environments are a very good solution to implement disaster recovery and very high level of high availability. They help to ensure that even a full outage of a whole region of one cloud provider...
How to Replace an Intermediate MySQL or MariaDB Master with a Binlog Server using MaxScale
Binary logs (binlogs) contain records of all changes to the databases. They are necessary for replication and can also be used to restore data after a backup. A binlog server is basically a binary log...
How to Install and Configure MaxScale for MariaDB
There are different reasons for adding a load balancer between your application and your database. If you have high traffic (and you want to balance the traffic between different database nodes) or you want to...
How to Use the Failover Mechanism of MaxScale
Ever since ClusterControl 1.2.11 was released in 2015, MariaDB MaxScale has been supported as a database load balancer. Over the years MaxScale has grown and matured, adding several rich features. Recently MariaDB MaxScale 2.2 was...