How to Deploy the Open edX MySQL Database for High Availability
Open edX is a platform for online educational activities. Given the situation the world is in, all such platforms are encountering higher loads and their importance has significantly increased. Those are not just the “helper”...
Installing ClusterControl to Deploy a Database Cluster Using Vagrant
If you are dealing with a bunch of virtual machines, using Vagrant is probably the best tool to build, automate and manage the virtual machines to increase efficiency and productivity, especially in a development environment....
What is a Query Outlier and How to Fix It
The MySQL database workload is determined by the number of queries that it processes. There are several situations in which MySQL slowness can originate. The first possibility is if there are any queries that are...
How to Deploy MariaDB Cluster 10.5 for High Availability
MariaDB Cluster 10.5 deployment has been supported in ClusterControl since version 1.8.1. MariaDB 10.5 is equipped with: More Granular Privileges InnoDB Performance Improvements Full GTID Support for Galera Cluster More Metadata for Replication and...
How to Deploy Percona XtraDB Cluster 8 for High Availability
Percona XtraDB Cluster 8.0 is based on Percona Server for MySQL 8.0 embedded with Galera writeset replication API and Galera replication library, to form a highly available multi-master replication for MySQL-based database server. Percona XtraDB...
An Overview of ProxySQL Clustering in ClusterControl
ProxySQL is a well known load balancer in MySQL world - it comes with a great set of features that allow you to take control over your traffic and shape it however you see it...
Announcing ClusterControl 1.8.1: Improved Security, Backup for MongoDB Sharded Clusters & Galera 4 Support
We’re excited to announce the 1.8.1 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. In addition to several new security enhancements, ClusterControl...
Monitoring Percona XtraDB Cluster – Key Metrics
Percona XtraDB Cluster is a very well known high availability solution in MySQL world. It is based on Galera Cluster and it does provide virtually synchronous replication across multiple nodes. As with every database, it...
How to Deploy Percona XtraDB Cluster
Percona XtraDB Cluster is a cluster solution based on the synchronous replication handled by Galera library. It is one of the most common high availability solutions for MySQL. It supports multiple writers and the conflict...
An Overview of the Percona XtraDB Cluster Kubernetes Operator
If you have been around in the container world, you would know that it is pretty challenging to adopt a full Kubernetes automation for a clustered database system, which commonly adds a level of complexity...
How to Perform an Online Upgrade of Percona XtraDB Cluster to Percona XtraDB Cluster 8.0
Percona XtraDB Cluster based on MySQL 8.0 has been out there for some time, so it’s not surprising more and more people are attempting to migrate into it. You may wonder how to approach this...
Scaling Out the Moodle Database
Moodle is a very popular platform to run online courses. With the situation we see in 2020, Moodle, along with communicators like Zoom forms the backbone of the services that allow online learning and stay-at-home...