Software Alternatives & Reviews

TiDB VS Patroni

Compare TiDB VS Patroni and see what are their differences

TiDB logo TiDB

A distributed NewSQL database compatible with MySQL protocol

Patroni logo Patroni

A Template for PostgreSQL HA with ZooKeeper, Etcd, or Consul
  • TiDB Landing page
    Landing page //
    2023-09-26
  • Patroni Landing page
    Landing page //
    2022-11-01

TiDB

Categories
  • Databases
  • NoSQL Databases
  • Relational Databases
  • Key-Value Database
Website github.com

Patroni

Categories
  • Databases
  • Relational Databases
  • NoSQL Databases
  • Database Management
Website github.com

TiDB videos

Hands-On TiDB - Episode 1: A Brief Introduction to TiDB

More videos:

  • Review - TiDB Contributor 学习之路
  • Tutorial - TiDB Binlog Tutorial

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 TiDB and Patroni)
Databases
55 55%
45% 45
NoSQL Databases
47 47%
53% 53
Relational Databases
48 48%
52% 52
Key-Value Database
100 100%
0% 0

User comments

Share your experience with using TiDB and Patroni. 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 TiDB and Patroni

TiDB Reviews

20+ MongoDB Alternatives You Should Know About
TiDB is another take on MySQL compatible sharding. This NewSQL engine is MySQL wire protocol compatible but underneath is a distributed database designed from the ground up.
Source: www.percona.com

Patroni Reviews

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

Social recommendations and mentions

Based on our record, TiDB should be more popular than Patroni. It has been mentiond 14 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.

TiDB mentions (14)

  • Ask HN: Who is hiring? (January 2023)
    PingCAP | https://www.pingcap.com | Database Engineer, Product Manager, Developer Advocate and more | Remote in California | Full-time We work on a MySQL compatible distributed database called TiDB https://github.com/pingcap/tidb/. - Source: Hacker News / about 1 year ago
  • Apache Pegasus – A a distributed key-value storage system
    Isn't TiDB built on top of TiKV?[0] [0]: https://github.com/pingcap/tidb. - Source: Hacker News / over 1 year ago
  • What is your experience with mixed workload (OLTP and OLAP) databases?
    OLTP usually comes with high throughput of transactions, which means usually write(e.g., IUD - insert, update, delete) to read (e.g., select) ratio is above 4 or 5 or even higher. There are some good benchmarks to test OLTP workload like TPC-C (https://www.tpc.org/tpcc/), and some benchmarks to test OLAP workload like TPC-H (https://www.tpc.org/tpch/). For mixed or hybrid OLTP and OLAP (it's called HTAP, see this... - Source: Hacker News / over 1 year ago
  • NewDB: Fate of an Open Source Database
    I am very agree with some options of this blog. As the maintainer of the open source distributed database TiDB https://github.com/pingcap/tidb, we also face the same problem of choice. We have a community version, an enterprise version(of course, we must sell it to our customers to earn money) and also a cloud service named TiDB cloud. Seven years before, we started to build TiDB to solve MySQL sharding problem,... - Source: Hacker News / over 1 year ago
  • I Don't Want to Shard (MySQL)
    Yes, hardware has limits and you just cannot have a single machine with unlimited number of cores and disks. But as the article mentioned, NewSQL is already there. DBs in this category has actually been awhile. I think Spanner's paper was 10 years ago. And it is ubiquitous across Google. So let's just accept that we should think things differently in 2022. Distributed RDBMS is already a thing, used in production,... - Source: Hacker News / over 1 year ago
View more

Patroni mentions (7)

  • 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: 9 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 / 10 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: almost 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
  • Postgresql HA using repmgr and Keepalived
    I don't have a great answer for you except that it sounds like you are trying to create your own version of patroni. Is there a good reason to not just use patroni? Source: about 1 year ago
View more

What are some alternatives?

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

Redis - Redis is an open source in-memory data structure project implementing a distributed, in-memory key-value database with optional durability.

Supabase - An open source Firebase alternative

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

MariaDB - An enhanced, drop-in replacement for MySQL

ClickHouse - ClickHouse is an open-source column-oriented database management system that allows generating analytical data reports in real time.

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