Running Multiple PostgreSQL Instances on a Single Host
We recently announced the release of ClusterControl 1.7.3 which includes a variety of improvements and newly added features. One of these new features is the addition of support in ClusterControl to allow a user to...
Announcing ClusterControl 1.7.3: Improved Support PostgreSQL & New Cloud Deployment Options
We’re excited to announce the 1.7.3 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. In this release we have added support for...
MySQL Replication with ProxySQL on WHM/cPanel Servers: Part Two
In the first part of the series, we showed you how to deploy a MySQL Replication setup with ProxySQL with WHM and cPanel. In this part, we are going to show some post-deployment operations for...
MySQL Replication with ProxySQL on WHM/cPanel Servers: Part One
WHM and cPanel is no doubt the most popular hosting control panel for Linux based environments. It supports a number of database backends - MySQL, MariaDB and PostgreSQL as the application datastore. WHM only supports...
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...
How to Setup Asynchronous Replication Between MariaDB Galera Clusters
Galera Cluster, with its (virtually) synchronous replication, is commonly used in many different types of environments. Scaling it by adding new nodes is not hard (or just as simple a couple of clicks when you...
Exploring the Different Ways to Encrypt Your MariaDB Data
Encrypting your MariaDB database, whether it is in-transit and at-rest, is one of the most important things that an organization should consider if you value your data. Organizations that deal with financial transactions, medical records,...
How to Automate Deployment of MySQL Galera Cluster using s9s CLI and Chef
In our previous blog, we showed how devops can automate your daily database tasks with Chef. Now, let's see how we can quickly deploy a MySQL Galera Cluster with Chef using s9s CLI. Setting up...
Database-Aware Load Balancing: How to Migrate from HAProxy to ProxySQL
HAProxy and ProxySQL are both very popular load balancers in MySQL world, but there is a significant difference between both those proxies. We will not go into details here, you can read more about HAProxy...
How to Deploy PostgreSQL to a Docker Container Using ClusterControl
Docker has become the most common tool to create, deploy, and run applications by using containers. It allows us to package up an application with all of the parts it needs, such as libraries and...
How to Automate Database Failover with ClusterControl
Recovery Time Objective (RTO) is the time period within which a service must be restored to avoid unacceptable consequences. By calculating how long it can take to recover from a database failure, we can know...
Introducing ClusterControl Spotlight Search
Included in the latest release, ClusterControl 1.7.2 introduces our new and exciting search functionality we’re calling “ClusterControl Spotlight.” ClusterControl Spotlight allows you to... Navigate the application faster Execute any action from any page within the...