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...
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...
Building a Highly Available Database for Moodle Using MariaDB (Replication & MariaDB Cluster)
Face-to-face meetings, nowadays, are limited to the bare minimum, online activities have taken over as the main way for teacher - student interaction. It increased the stress on the existing online “meeting” platforms (is there...
MySQL Storage Engine Optimization: Configuring InnoDB Optimization For High Performance
InnoDB is one of the most widely used storage engines in MySQL. This storage engine is known as a high-reliability and a high-performance storage engine and its key advantages include supporting row-level locking, foreign keys...
Comparing MariaDB Enterprise Backup to ClusterControl Backup Management
MariaDB Enterprise Backup is a backup solution from MariaDB Corporation with a number of features such as non-blocking backups, full backup, incremental backup, partial backup and Point in Time Recovery. We often get questions about...