How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster on Docker
ProxySQL is an intelligent and high-performance SQL proxy which supports MySQL, MariaDB and ClickHouse. Recently, ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera...
HA for MySQL and MariaDB – Comparing Master-Master Replication to Galera Cluster
Galera replication is relatively new if compared to MySQL replication, which is natively supported since MySQL v3.23. Although MySQL replication is designed for master-slave unidirectional replication, it can be configured as an active master-master setup...
High Availability on a Shoestring Budget – Deploying a Minimal Two Node MySQL Galera Cluster
We regularly get questions about how to set up a Galera cluster with just 2 nodes. The documentation clearly states you should have at least 3 Galera nodes to avoid network partitioning. But there are...
Hybrid OLTP/Analytics Database Workloads in Galera Cluster Using Asynchronous Slaves
Using Galera cluster is a great way of building a highly available environment for MySQL or MariaDB. It is a shared-nothing cluster environment which can be scaled even beyond 12-15 nodes. Galera has some limitations,...
Running ProxySQL as a Helper Container on Kubernetes
ProxySQL commonly sits between the application and database tiers, in so called reverse-proxy tier. When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL in front of your database...
Webinar Replay: Monitoring on Steroids for MySQL, MariaDB, PostgreSQL and MongoDB
Thanks for joining us this week for our webinar on monitoring MySQL, MariaDB, PostgreSQL and MongoDB with freely available community tools and more specifically one: ClusterControl Community Edition. The replay and slides are now available...
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...
How to Recover MySQL Galera Cluster From an Asynchronous Slave
Introduction When running Galera Cluster, it is a common practice to add one or more asynchronous slaves in the same or in a different datacenter. This provides us with a contingency plan with low RTO,...
Improve Performance of Galera Cluster for MySQL or MariaDB
Galera Cluster comes with many notable features that are not available in standard MySQL replication (or Group Replication); automatic node provisioning, true multi-master with conflict resolutions and automatic failover. There are also a number of...
Running a MariaDB Galera Cluster Without Orchestration Tools – DB Container Management: Part Two
As we saw in the first part of this blog, a strongly consistent database cluster like Galera does not play well with container orchestration tools like Kubernetes or Swarm. We showed you how to deploy...
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...
How to Recover Galera Cluster or MySQL Replication From Split Brain Syndrome
You may have heard about the term “split brain”. What it is? How does it affect your clusters? In this blog post we will discuss what exactly it is, what danger it may pose to...