A Guide to MySQL Galera Cluster Restoration Using mysqldump
Using logical backup programs like mysqldump is a common practice performed by MySQL admins for backup and restore (the process of moving a database from one server to another) and is also the most efficient...
Handling Large Transactions with Streaming Replication and MariaDB 10.4
Dealing with large transactions was always a pain point in Galera Cluster. The way in which Galera writeset certification works causes troubles when transactions are long or when a single row is being modified often...
Database High Availability for Camunda BPM using MySQL or MariaDB Galera Cluster
Camunda BPM is an open-source workflow and decision automation platform. Camunda BPM ships with tools for creating workflow and decision models, operating deployed models in production, and allowing users to execute workflow tasks assigned to...
How to Monitor MySQL or MariaDB Galera Cluster with Prometheus Using SCUMM
ClusterControl version 1.7 introduced a new way to watch your database clusters. The new agent-based approach was designed for demanding high-resolution monitoring. ClusterControl agentless, secure SSH-based remote stats collection has been extended with modern high-frequency...
How to Deploy a Production-Ready MySQL or MariaDB Galera Cluster Using ClusterControl
Deploying a database cluster is not rocket science - there are many how-to’s on how to do that. But how do you know what you just deployed is production-ready? Manual deployments can also be tedious...
Running a MariaDB Galera Cluster Without Container Orchestration Tools: Part One
Container orchestration tools simplify the running of a distributed system, by deploying and redeploying containers and handling any failures that occur. One might need to move applications around, e.g., to handle updates, scaling, or underlying...
Announcing MariaDB 10.2 Support – ClusterControl 1.5
Announced as part of the ClusterControl 1.5 release, we now provide full support for MariaDB version 10.2. This new version provides even greater integration with Galera Cluster, MariaDB’s HA solution of choice, and also features...
Full Restore of a MySQL or MariaDB Galera Cluster from Backup
Performing regular backups of your database cluster is imperative for high availability and disaster recovery. If for any reason you lost your entire cluster and had to do a full restore from backup, you would...
How to Bootstrap MySQL or MariaDB Galera Cluster – Updated
Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL/MariaDB Galera Cluster is a bit different. Galera requires you to start a node in a cluster as a reference point, before the...
How to Preform an Online Upgrade of MariaDB Galera Cluster 5.5 to MariaDB 10
The MariaDB team released a GA version of MariaDB Galera Cluster 10 in June 2014. MariaDB 10 is the equivalent of MySQL 5.6, and therefore, packed with lots of great features. In this blog post,...
How to Deploy High Availability CloudStack/CloudPlatform with MariaDB Galera Cluster
Apache CloudStack is a turnkey orchestration platform to deliver IaaS clouds. As a cloud infrastructure scales to hundreds or thousands of servers, with production environments supporting multiple applications and services, high availability becomes a key...
Multi-Source Replication with MariaDB Galera Cluster
MariaDB 10 supports multi-source replication, and each MariaDB Galera node can have up to 64 masters connected to it. So it is possible to use a MariaDB Cluster as an aggregator for many single-instance MariaDB...