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...
Video: Database Disaster Recovery with ClusterControl
This past week we debuted a series of videos on database disaster recovery. From basic backup and restore, to switchover & failover, to full cluster-to-cluster replication, these videos show how ClusterControl offers you end-to-end protection...
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...
An Overview of MariaDB Xpand (formerly ClustrixDB)
MariaDB Xpand is a new product from MariaDB. It was formerly known as ClustrixDB which was acquired in September of 2018 by MariaDB Corporation. ClustrixDB is no longer available as a separate entity, but is...
Tips for Monitoring MariaDB Replication with ClusterControl
MariaDB replication is one of the most popular high availability solutions for MariaDB and widely used by top companies like Booking.com and Google. It is very easy to set up, with some trade-offs on the...
MariaDB Server Database Encryption Basics
Encryption is one of the most important security features to keep your data as secure as possible. Depending on the data that you are handling, not always it is a must but you should at...
Comparing MariaDB Server to MariaDB Cluster
MariaDB Server and MariaDB Cluster are open source products powered by the MariaDB Corporation. MariaDB Server is one of the most popular relational databases, it was originally forked from MySQL server. MariaDB Cluster is a...
Tips for Monitoring MariaDB Cluster
In previous blog posts, we have covered topics for Monitoring Your Galera Cluster whether it's MySQL or MariaDB. Although the technology versions don't differ much, MariaDB Cluster has some major changes since version 10.4.2. In...
MaxScale Basic Management Using MaxCtrl for MariaDB Cluster
In the previous blog post, we have covered some introductions to MaxScale installation, upgrade, and deployment using MaxCtrl command-line client. In this blog post, we are going to cover the MaxScale management aspects for our...
How to Design a Geographically Distributed MariaDB Cluster
It is very common to see databases distributed across multiple geographical locations. One scenario for doing this type of setup is for disaster recovery, where your standby data center is located in a separate location...
Deploying MariaDB Replication for High Availability
MariaDB Server offers asynchronous and synchronous replication. It can be set up to have a multi-source replication or with a multi-master setup. For a read and write intensive application, a master-slave setup is common, but...