Software Alternatives & Reviews

Patroni VS MySQL

Compare Patroni VS MySQL and see what are their differences

Patroni logo Patroni

A Template for PostgreSQL HA with ZooKeeper, Etcd, or Consul

MySQL logo MySQL

The world's most popular open source database
  • Patroni Landing page
    Landing page //
    2022-11-01
  • MySQL Landing page
    Landing page //
    2022-06-17

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

MySQL videos

MySQL IN 10 MINUTES (2020) | Introduction to Databases, SQL, & MySQL

More videos:

  • Review - A Review of MySQL Open Source Software

Category Popularity

0-100% (relative to Patroni and MySQL)
Databases
3 3%
97% 97
NoSQL Databases
6 6%
94% 94
Relational Databases
3 3%
97% 97
Developer Tools
100 100%
0% 0

User comments

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

Reviews

These are some of the external sources and on-site user reviews we've used to compare Patroni and MySQL

Patroni Reviews

We have no reviews of Patroni yet.
Be the first one to post

MySQL Reviews

MariaDB Vs MySQL In 2019: Compatibility, Performance, And Syntax
MySQL: MySQL is an open-source relational database management system (RDBMS). Just like all other relational databases, MySQL uses tables, constraints, triggers, roles, stored procedures and views as the core components that you work with. A table consists of rows, and each row contains a same set of columns. MySQL uses primary keys to uniquely identify each row (a.k.a...
Source: blog.panoply.io
20+ MongoDB Alternatives You Should Know About
MySQL® is another feasible replacement. MySQL 5.7 and MySQL 8 have great support for JSON, and it continues to get better with every maintenance release. You can also consider MySQL Cluster for medium size sharded environments. You can also consider MariaDB and Percona Server for MySQL
Source: www.percona.com

Social recommendations and mentions

Based on our record, Patroni should be more popular than MySQL. 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.

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 / 2 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

MySQL mentions (4)

  • I have a recurring issue with a MySQL DB where I continually run out of disk space due to logs being filled. I've tried everything I can think of. Can anyone think of anything else I should try?
    So, I did a quick read through the mysql reference and found a bunch of flush related commands. I tried:. Source: 11 months ago
  • MMORPG design resources
    MySQL: Any SQL or DB knock-off, really... mysql.com - mariadb.org - sqlite.org. Source: over 1 year ago
  • Probably a syntax error
    15 years and five strokes ago. I was a Unix sysadmin. ALthough I was never an actual programmer, I did maintenance/light enhancement for the organization's website, in php. Now, as self-administered cognative therapy, I'm going back to it. This is an evil HR application that uses the mysql.com employees sample database. The module below enables the evil HR end user to generate a list of the oldest workers so... Source: almost 3 years ago
  • An absolute nightmare with mysql 8.0.25
    I always use the packages from mysql.com, that way I don't have to deal with strange configuration stuff along those lines, but anyway, I'm afraid I'm out of ideas. Surely someone else would have run in to the same issue here though. Source: almost 3 years ago

What are some alternatives?

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

Supabase - An open source Firebase alternative

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

MariaDB - An enhanced, drop-in replacement for MySQL

Microsoft SQL - Microsoft SQL is a best in class relational database management software that facilitates the database server to provide you a primary function to store and retrieve data.

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

MongoDB - MongoDB (from "humongous") is a scalable, high-performance NoSQL database.