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...
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...
Using the Percona Audit Log Plugin for Database Security
Why Do You Need To Use an Audit Plugin For Your Database? Auditing in a database doesn't deviate from its meaning as it shares the same connotation i.e. to inspect, examine, and evaluate for such...
Migrating Azure Database for MySQL/MariaDB to an On-Prem Server
Database migrations can impose huge challenges when you consider how to start, what tools to use, and how to achieve a full database migration successfully. Earlier, we have listed the top open source you can...
Migrating Amazon RDS (MySQL or MariaDB) to an On-Prem Server
Amazon Web Services is a technology giant, especially when it comes to pioneering itself in top-of-the-line cloud computing services. Its fully managed services products (Amazon RDS) is one of a kind. But then again, while...
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...
Top Open Source Tools for MySQL & MariaDB Migrations
Large organizations that are using MySQL or MariaDB database platforms are often faced with a need to perform a database migration from one place to another. Regardless of the platform, type of database software (such...
How to Upgrade from MariaDB 10.4 to MariaDB 10.5
MariaDB 10.5 was released as GA in June 2020. In the release, there has been added support for Amazon S3 or any third-party public or private cloud that supports S3 API. It also features sophisticated...
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...
A Guide to MySQL Indexes
When MySQL query optimization is mentioned, indexes are one of the first things that get covered. Today, we will try to see why they are so important. What are Indexes? In general, an index is...
Database Load Balancing: Distributed vs Centralized Setups
A database load balancer, or database reverse proxy, distributes the incoming database workload across multiple database servers running behind it. The goals of having database load balancers are to provide a single database endpoint to...