Photo by Massimo Botturi on Unsplash

TiDB: The Best and Sexy Distributed SQL Database Platform for Horizontal Scalability, Strong Consistency, and High Availability!

The simple and effective solution for Horizontally scalable Relational Databases and Real-time Analytics cases.

Josue Luzardo Gebrim
8 min readDec 25, 2021

--

TiDB is an open source, MySQL-compatible NewSQL database created by PingCAP and its open source community.

Case Study:

These are some success cases where TiDB has been applied:

Ninja Van,

A company in the logistics sector with its operation mainly in Southeast Asia having clients like Amazon, Shopee, Lazada, Lineman, GradExpress, Zilingo, Tokopedia and being, after comparing Vitess, CockroachDB (CRDB), and TiDB, chose TiDB for its scalability from the Kubernetes node (K8s) to evolve your MySQL cluster environment.

They had about 70 virtual machines (VM’s) with more than 100 schemas that had tables that could reach 3.6 Terabytes (TB), besides having to use the Galera plugin, to guarantee high availability (HA) and ProxySQL, an open-source project that is a SQL compliant layer.

In this environment, they used ProxySQL to get consistent reads, but it is not very scalable and had recurring…

--

--

Josue Luzardo Gebrim
Josue Luzardo Gebrim

Written by Josue Luzardo Gebrim

As a platform engineer, ecosystems, and data solutions, I'm sharing my opinion and what little I know from time to time here.