How Galera Cluster Enables High Availability for High Traffic Websites
In today’s competitive technology environment, high availability is a must. There is no way around it - if your website or service is not available, then most probably you are losing money. It could relate...
ClusterControl and Galera Cluster on Docker Swarm
Our journey in adopting MySQL and MariaDB in containerized environments continues, with ClusterControl coming into the picture to facilitate deployment and management. We already have our ClusterControl image hosted in Docker Hub, where it can...
How to Deploy Asynchronous Replication Slave to MariaDB Galera Cluster 10.x
Combining Galera and asynchronous replication in the same MariaDB setup, aka Hybrid Replication, can be useful - e.g. as a live backup node in a remote datacenter or reporting/analytics server. We already blogged about this...
How to Set Up Asynchronous Replication from Galera Cluster to Standalone MySQL server with GTID
Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier since GTID got introduced in MySQL 5.6. Although it was fairly straightforward to replicate from a standalone MySQL server...
Video: ClusterControl for Galera Cluster
This video walks you through the features that ClusterControl offers for Galera Cluster and how you can use them to deploy, manage, monitor and scale your open source database environments. ClusterControl and Galera Cluster ClusterControl...
Video: Managing Your Galera Cluster with ClusterControl
In this video Art van Scheppingen shows you how easy it is to add your Galera setups to ClusterControl. ClusterControl provides you with a single console to deploy, manage, monitor, and scale your Galera setups...
Online Schema Upgrade in MySQL Galera Cluster Using RSU Method
This post is a continuation of our previous post on Online Schema Upgrade in Galera using TOI method. We will now show you how to perform a schema upgrade using the Rolling Schema Upgrade (RSU)...
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...
Calculating the Total Cost of Ownership for MySQL Management
Cost analysis and cost effectiveness for databases are hardly ever performed, while it actually makes a lot of sense to perform such calculations. The easiest method of gaining insights into these is by performing a...
MySQL High Availability Tools – Comparing MHA, MRM and ClusterControl
We previously compared two high availability solutions for MySQL - MHA and MariaDB Replication Manager and looked into how they performed fail-over. In this blog post, we’ll see how ClusterControl stacks up against these solutions....
Webinar Replay: Load balancing MySQL & MariaDB with ProxySQL & ClusterControl
Thanks to everyone who participated in our recent webinar on how to load balance MySQL and MariaDB with ClusterControl and ProxySQL! This joint webinar with ProxySQL creator René Cannaò generated a lot of interest …...