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...
Performance Testing Using MySQLdump and the MySQL Shell Utility
In my previous post I explained how to take a logical backup using the mysql shell utilities. In this post, we shall compare the speed of the backup and restoration process. MySQL Shell Speed Test ...
How to Monitor Your Databases with ClusterControl and Opsgenie
ClusterControl is a platform for monitoring and managing open source databases. It will provide you with a single pane of glass to understand what is happening in the system, it will let you know via...
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...
MongoDB Backup Management Tips for Sharded Clusters
Making proper backups of the database is a critical task. Besides setting the high availability architecture of your MongoDB for database services, you also need to have backups of your databases to ensure the availability...
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 Server for MongoDB – Key Metrics
When running critical database services in production, we need to know and monitor the database. You need to understand the key metrics in the database that you are using. For example, when you run MongoDB...
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 a Highly Available Canvas LMS with a PostgreSQL Database Cluster
In these pandemic times, Learning Management System (LMS) platforms are getting more and more important to allow you to continue learning remotely when the traditional education system just isn’t available anymore. Having an LMS platform...
Comparing the Features of Percona Monitoring & Management (PMM) to ClusterControl Database Monitoring
You may have heard about Percona Monitoring and Management (PMM), a solution from Percona that is focused on the monitoring of open source databases. It is a quite popular and free solution that provides access...