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 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...
Deploy a Homogeneous Galera Cluster with etcd
In the previous blog post, we have looked into the multi-host networking capabilities with Docker with native network and Calico. In this blog post, our journey to make Galera Cluster run smoothly on Docker containers...
Answering Eurofunk’s Database SOS Call
Eurofunk replaces Oracle with feature-rich Severalnines ClusterControl Today we’re happy to announce Eurofunk, one of the largest European command centre system specialists, as our latest customer. Severalnines was brought on board to help manage the...
Schema Upgrades in Galera Cluster for MySQL and MariaDB – How to Avoid RSU Locks
Working as MySQL DBA, you will often have to deal with schema changes. Changes to production databases are not popular among DBAs, but they are necessary when applications add new requirements on the databases. If...
Database Cluster Management: Manual vs Automation
In a previous blog, we looked at the efficiency gains when automating the deployment of a Galera cluster for MySQL. In this post, we are going to dive into cluster management. Should we manage our...