Database Performance Tuning for MariaDB
(Updated on 17 September 2024) Ever since MySQL was originally forked to form MariaDB it has been widely supported and adopted quickly by a large audience in the open source database community. Originally a drop-in...
Full MariaDB Encryption At-Rest and In-Transit for Maximum Data Protection – Part Two
In the first part of this series, we have covered in-transit encryption configuration for MariaDB replication servers, where we configured client-server and replication encryptions. Taken from the first post, where we had partially configured our...
Full MariaDB Encryption At-Rest and In-Transit for Maximum Data Protection – Part One
In this blog series, we are going to give you a complete walkthrough on how to configure a fully encrypted MariaDB server for at-rest and in-transit encryption, to ensure maximum protection of the data from...
Maximizing Database Query Efficiency for MySQL – Part One
Slow queries, inefficient queries, or long running queries are problems that regularly plague DBA's. They are always ubiquitous, yet are an inevitable part of life for anyone responsible for managing a database. Poor database design...
Handling Replication Issues from non-GTID to GTID MariaDB Database Clusters
We recently ran into an interesting customer support case involving a MariaDB replication setup. We spent a lot of time researching this problem and thought it would be worth sharing this with you in this...
Building a Hot Standby on Amazon AWS Using MariaDB Cluster
Galera Cluster 4.0 was first released as part of the MariaDB 10.4 and there are a lot of significant improvements in this version release. The most impressive feature in this release is the Streaming Replication...
Database Load Balancing in the Cloud – MySQL Master Failover with ProxySQL 2.0: Part One (Deployment)
The cloud provides very flexible environments to work with. You can easily scale it up and down by adding or removing nodes. If there’s a need, you can easily create a clone of your environment....
A Guide to MySQL Galera Cluster Streaming Replication: Part Two
In the first part of this blog we provided an overview of the new Streaming Replication feature in MySQL Galera Cluster. In this blog we will show you how to enable it and take a...
What’s New in MySQL Galera Cluster 4.0
MySQL Galera Cluster 4.0 is the new kid on the database block with very interesting new features. Currently it is available only as a part of MariaDB 10.4 but in the future it will work...
How to Troubleshoot MySQL Database Issues
As soon as you start running a database server and your usage grows, you are exposed to many types of technical problems, performance degradation, and database malfunctions. Each of these could lead to much bigger...
Comparing DBaaS Failover Solutions to Manual Recovery Setups
We have recently written several blogs covering how different cloud providers handle database failover. We compared failover performance in Amazon Aurora, Amazon RDS and ClusterControl, tested the failover behavior in Amazon RDS, and also on...
Database Switchover and Failover for Drupal Websites Using MySQL or PostgreSQL
Drupal is a Content Management System (CMS) designed to create everything from tiny to large corporate websites. Over 1,000,000 websites run on Drupal and it is used to make many of the websites and applications...