blog
Galera Cluster Resources
Galera Cluster is a true multi-master cluster solution for MySQL and MariaDB, based on synchronous replication. Galera Cluster is easy-to-use, provides high-availability, as well as scalability for certain workloads.
ClusterControl provides advanced deployment, management, monitoring, and scaling functionality to get your Galera clusters up-and-running using proven methodologies.
Here are just some of the great resources we’ve developed for Galera Cluster over the last few years…
Tutorials
Galera Cluster for MySQL
Galera allows applications to read and write from any MySQL Server. Galera enables synchronous replication for InnoDB, creating a true multi-master cluster of MySQL servers. Allows for synchronous replication between data centers. Our tutorial covers MySQL Galera concepts and explains how to deploy and manage a Galera cluster.
Deploying a Galera Cluster for MySQL on Amazon VPC
This tutorial shows you how to deploy a multi-master synchronous Galera Cluster for MySQL with Amazon’s Virtual Private Cloud (Amazon VPC) service.
Training: Galera Cluster For System Administrators, DBAs And DevOps
The course is designed for system administrators & database administrators looking to gain more in depth expertise in the automation and management of Galera Clusters.
On-Demand Webinars
MySQL Tutorial – Backup Tips for MySQL, MariaDB & Galera Cluster
In this webinar, Krzysztof Książek, Senior Support Engineer at Severalnines, discusses backup strategies and best practices for MySQL, MariaDB and Galera clusters; including a live demo on how to do this with ClusterControl.
9 DevOps Tips for Going in Production with Galera Cluster for MySQL / MariaDB
In this webinar replay, we guide you through 9 key tips to consider before taking Galera Cluster for MySQL / MariaDB into production.
Deep Dive Into How To Monitor MySQL or MariaDB Galera Cluster / Percona XtraDB Cluster
Our colleague Krzysztof Książek provided a deep-dive session on what to monitor in Galera Cluster for MySQL & MariaDB. Krzysztof is a MySQL DBA with experience in managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard.
Become a MySQL DBA – webinar series: Schema Changes for MySQL Replication & Galera Cluster
In this webinar, we discuss how to implement schema changes in the least impacting way to your operations and ensure availability of your database. We also cover some real-life examples and discuss how to handle them.
Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
In this webinar, we walk you through what you need to know in order to migrate from standalone or a master-slave MySQL / MariaDB setup to Galera Cluster.
Introducing Galera 3.0
In this webinar you’ll learn all about the new Galera Cluster capabilities in version 3.0.
Top Blogs
MySQL on Docker: Running Galera Cluster on Kubernetes
In our previous posts, we showed how one can run Galera Cluster on Docker Swarm, and discussed some of the limitations with regards to production environments. Kubernetes is widely used as orchestration tool, and we’ll see whether we can leverage it to achieve production-grade Galera Cluster on Docker.
ClusterControl for Galera Cluster for MySQL
Galera Cluster is widely supported by ClusterControl. With over four thousand deployments and more than sixteen thousand configurations, you can be assured that ClusterControl is more than capable of helping you manage your Galera setup.
How Galera Cluster Enables High Availability for High Traffic Websites
This post gives an insight into how Galera can help to build HA websites.
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. In this blog post, we will show you how to replicate a Galera Cluster to a MySQL server with GTID, and how to failover the replication in case the master node fails.
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. This blog post provides a series of best practices on how to fully restore a MySQL or MariaDB Galera Cluster from backup.
How to Bootstrap MySQL or MariaDB Galera Cluster
Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL or MariaDB Galera Cluster is a bit different. Galera requires you to start a node in a cluster as a reference point, before the remaining nodes are able to join and form the cluster. This process is known as cluster bootstrap. Bootstrapping is an initial step to introduce a database node as primary component, before others see it as a reference point to sync up data.
Schema changes in Galera cluster for MySQL and MariaDB – how to avoid RSU locks
This post shows you how to avoid locking existing queries when performing rolling schema upgrades in Galera Cluster for MySQL and MariaDB.
Deploy an asynchronous slave to Galera Cluster for MySQL – The Easy Way
Due to its synchronous nature, Galera performance can be limited by the slowest node in the cluster. So running heavy reporting queries or making frequent backups on one node, or putting a node across a slow WAN link to a remote data center might indirectly affect cluster performance. Combining Galera and asynchronous MySQL replication in the same setup, aka Hybrid Replication, can help
Top Videos
ClusterControl for Galera Cluster – All Inclusive Database Management System
Galera Cluster – ClusterControl Product Demonstration
ClusterControl delivers on an array of features to help manage and monitor your open source database environments:
- Deploy Database Clusters
- Add Node, Load Balancer (HAProxy, ProxySQL) or Replication Slave
- Backup Management
- Configuration Management
- Full stack monitoring (DB/LB/Host)
- Query Monitoring
- Enable SSL Encryption Galera Replication
- Node Management
- Developer Studio with Advisors
Learn more about how ClusterControl can help you drive high availability with Galera Cluster here.
We hope that these resources prove useful!
Happy Clustering!
