Software Alternatives & Reviews

Galera Cluster VS Patroni

Compare Galera Cluster VS Patroni and see what are their differences

Galera Cluster logo Galera Cluster

Galera Cluster for MySQL is a Multimaster Cluster based on synchronous replication.

Patroni logo Patroni

A Template for PostgreSQL HA with ZooKeeper, Etcd, or Consul
  • Galera Cluster Landing page
    Landing page //
    2023-04-19
  • Patroni Landing page
    Landing page //
    2022-11-01

Galera Cluster videos

Choosing between MySQL Galera, MariaDB Galera Cluster and Percona XtraDB Cluster

More videos:

  • Review - High Availability and Scalability with Galera Cluster for MySQL
  • Review - Galera Cluster DDLs and Schema Upgrades Galera Cluster Best Practises

Patroni videos

Patroni 2020-04-09

More videos:

  • Review - Management of High-Availability PostgreSQL clusters with Patroni | A.Klyukin, A.Kukushkin
  • Review - PATRONI 😋 MARIHUANA REVIEW

Category Popularity

0-100% (relative to Galera Cluster and Patroni)
Relational Databases
53 53%
47% 47
Databases
44 44%
56% 56
NoSQL Databases
49 49%
51% 51
Tool
100 100%
0% 0

User comments

Share your experience with using Galera Cluster and Patroni. For example, how are they different and which one is better?
Log in or Post with

Social recommendations and mentions

Based on our record, Patroni should be more popular than Galera Cluster. It has been mentiond 8 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

Galera Cluster mentions (2)

  • Centralize storage for docker. What protocol to use?
    You can do basic master/replica with mysql or mariadb too. Or even multimaster replication with Galera - not the easiest thing to properly configure however. Source: over 1 year ago
  • Index bloat reduced in PostgreSQL v14
    Especially since Galera entered the picture: * https://packages.debian.org/search?keywords=galera * https://galeracluster.com/ There's BDR, but it's a commercial product from 2ndQuadrant/EDB: * https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/. - Source: Hacker News / over 2 years ago

Patroni mentions (8)

  • Ask HN: Are there any open source forks of nomad smd consul?
    > I think etcd is basically a k8s only project now I hate etcd with the best of them, but etcd is used in a lot more places than just kubernetes: https://github.com/apache/apisix/blob/master/docs/en/latest/FAQ.md#why-does-apache-apisix-use-etcd-for-the-configuration-center, https://github.com/zalando/patroni#patroni-a-template-for-postgresql-ha-with-zookeeper-etcd-or-consul (this one shows up on HN quite a... - Source: Hacker News / 4 days ago
  • How to create postgres cluster in docker swarm?
    We have been using stolon + consul for years without issue in our swarm environments. It may also be possible with patroni. Source: 11 months ago
  • Why PostgreSQL High Availability Matters and How to Achieve It
    One of the solutions which made it pretty simple for us to run postgresql in a ha environment (mostly in k8s, but works standalone as well) is zalandos patroni: https://github.com/zalando/patroni (docker image: https://github.com/zalando/spilo) we've also tried other operators which were easier to get started, but they failed miserably (crunchyrolls operator is... - Source: Hacker News / 11 months ago
  • Docker: Patroni + HAProxy + Etcd + PgBouncer
    Hello. I am currently using this docker-compose model from Zalando repository. It does not include PgBouncer in its architecture by default. I've been trying to find a containerized implementation involving Patroni, HAProxy, Etcd and PgBouncer. I didn't find anything solid so far. Source: about 1 year ago
  • Can someone share experience configuring Highly Available PgSQL?
    General purpose: Patroni - Set up your own etcd + HAProxy + Patroni + Postgres components and it'll generally manage itself after that. Source: about 1 year ago
View more

What are some alternatives?

When comparing Galera Cluster and Patroni, you can also consider the following products

PostgreSQL - PostgreSQL is a powerful, open source object-relational database system.

Supabase - An open source Firebase alternative

Amazon RDS - Easy to manage relational databases optimized for total cost of ownership.

MariaDB - An enhanced, drop-in replacement for MySQL

Google Cloud Spanner - Google Cloud Spanner is a horizontally scalable, globally consistent, relational database service.

Citus - Worry-free Postgres for SaaS. Built to scale out.