How to Improve Replication Performance in a MySQL or MariaDB Galera Cluster
In the comments section of one of our blogs a reader asked about the impact of wsrep_slave_threads on Galera Cluster’s I/O performance and scalability. At that time, we couldn’t easily answer that question and back...
ClusterControl Performance and Health Monitoring
In the previous two blog posts we covered both deploying the four types of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL) and managing/monitoring your existing databases and clusters. So, after reading these two first blog...
How to Set Up Asynchronous Replication Between MySQL Galera Clusters
The Galera Cluster enforces strong data consistency, where all nodes in the cluster are tightly coupled. Although network segmentation is supported, replication performance is still bound by two factors: The round trip time (RTT) to...
Galera Cluster Recovery 101 – A Deep Dive Into Network Partitioning
One of the cool features in Galera is automatic node provisioning and membership control. If a node fails or loses communication, it will be automatically evicted from the cluster and remain unoperational. As long as...
Safeguarding your Data with ClusterControl
In the past four posts of the blog series, we covered deployment of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health and in...
How to Fail or Crash Your MySQL Instances for Testing
You can take down a MySQL database in multiple ways. Some obvious ways are to shut down the host, pull out the power cable, or hard kill the mysqld process with SIGKILL to simulate an...
How to Stop or Throttle SST Operation on a Galera Cluster
State Snapshot Transfer (SST) is one of the two ways used by Galera to perform initial syncing when a node is joining a cluster, until the node is declared as synced and part of the...
How to Automate Galera Cluster Using the ClusterControl CLI
As sysadmins and developers, we spend a lot our time in a terminal. So we brought ClusterControl to the terminal with our command line interface tool called s9s. s9s provides an easy interface to the...
Monitoring Galera Cluster for MySQL or MariaDB – Understanding Metrics (Updated)
To operate any database efficiently, you need to have insight into database performance. This might not be obvious when everything is going well, but as soon as something goes wrong, access to information can be...
Multiple Data Center Setups Using Galera Cluster for MySQL or MariaDB
Building High Availability, one Step at a Time When it comes to database infrastructure, we all want it. We all strive to build a highly available setup. Redundancy is the key. We start to implement...
A How-To Guide for Galera Cluster
Since it was originally published more than 63,000 people (to date) have leveraged the MySQL for Galera Cluster Tutorial to both learn about and get started using MySQL Galera Cluster. Galera Cluster for MySQL is...
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,...