Multi-Cloud Deployment for MariaDB Replication Using WireGuard
In this blog post, we are going to look into how to deploy a MariaDB replication setup in a multi-cloud environment. Suppose our primary application is located at AWS, it's the best idea to set...
MariaDB Cluster Offline Installation for CentOS
Most of the installation steps available on the Internet cover the standard online installation, presuming the database hosts are having an active internet connection to the package repositories and satisfy all dependencies. However, installation steps...
Multi-Cloud Full Database Cluster Failover Options for MariaDB Cluster
High availability is paramount in today's business reality. But every service provider comes with an inherited risk of disruption -- and cloud service providers are no different. If they go down, even temporarily, then so...
Comparing Amazon RDS Point-in-Time Recovery to ClusterControl
The Amazon Relational Database Service (AWS RDS) is a fully-managed database service which can support multiple database engines. Among those supported are PostgreSQL, MySQL, and MariaDB. ClusterControl, on the other hand, is a database management...
My DBA is Sick – Database Failover Tips for SysAdmins
In case of a database failure, the best case scenario is that you have a good Disaster Recovery Plan (DRP) and a highly available environment with an automatic failover process in place. But what happens...
Preparing a MySQL or MariaDB Server for Production – Part Two
In the previous blog, we have covered some tips and tricks to prepare a MySQL server for production usage from a system administrator perspective. This blog post is the continuation... Use a Database Backup Tool...
How Performant is Your ProxySQL Node?
ProxySQL has gained a lot of interest right now in the MySQL and MariaDB database world, not to mention ClickHouse which helps make the case for ProxySQL. It’s safe to say that ProxySQL has become...
MariaDB Backups: What is mariabackup?
It is essential that you choose the right technology for backing up your database as you don’t want to take any risk with your important production data. Also, you want to select a backup tool...
Preparing a MySQL or MariaDB Server for Production – Part One
It is extremely important to install and configure a production MySQL server with the necessary packages and tools to smooth-out the operations in the long run. We have seen many cases where troubleshooting or tuning...
How to Replace an Intermediate MySQL or MariaDB Master with a Binlog Server using MaxScale
Binary logs (binlogs) contain records of all changes to the databases. They are necessary for replication and can also be used to restore data after a backup. A binlog server is basically a binary log...
How to Install and Configure MaxScale for MariaDB
There are different reasons for adding a load balancer between your application and your database. If you have high traffic (and you want to balance the traffic between different database nodes) or you want to...
How to Fix a Lock Wait Timeout Exceeded Error in MySQL
One of the most common InnoDB errors is InnoDB lock wait timeout exceeded, for example: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction The above simply means the transaction has reached the...