TiDB shines when you want MySQL-like simplicity with cloud-scale architecture. It’s ideal for scalable, real-time workloads that combine OLTP and OLAP. Further, i would like to add that TiDB MySQL-compatible interface makes onboarding and usage piece of cake. Most SQL tools and skills translate directly. TiDB’s deployment with tools like tiup straightforward since it easy to implement as it is well documented. PingCAP provides strong support, and their GitHub community and slack forums are active providing support for most of the common issues. TiDB is best fit for high availability and horizontal scalability. Features like horizontal scaling, HTAP (Hybrid Transactional and Analytical Processing), and automatic sharding are extremely powerful. TiDB integrates with tools like Debezium, Kafka, and Grafana. TiCDC (change data capture) is also a strong asset. In the end i would like to add TiDB offers MySQL-compatible, scalable, HTAP capabilities, great integration, and cloud-native design Review collected by and hosted on G2.com.

While using the TiDB for the first time i felt that it comes with a steep learning curve for managing its distributed architecture and some feature caveats in MySQL compatibility. While SQL usage is simple, understanding the internal architecture (TiKV, PD, TiFlash, etc.) can be complex and has a learning curve.

For advanced setups (multi-region, disaster recovery), the complexity increases rapidly and requires significant ops expertise. Community support is solid, but free-tier users may find delayed responses. Deep debugging sometimes requires premium enterprise help. Not as helpful in small to mid-size projects—often overkill unless you really need distributed SQL and horizontal scaling. While TiDB is a feature-rich offering, not all MySQL features are 100% compatible (e.g., stored procedures, full-text search limitations). Some MySQL-based ORMs and drivers may hit compatibility quirks. Also, integrating TiFlash (columnar storage) requires deeper understanding and tuning on developer end. Review collected by and hosted on G2.com.

It's the comprehensive MySQL distributed database, there are many similar database in market but they have lot of restrictions like Amazon DSQL, Google Alloy, Amazon Aurora etc. none of them are true distributed solution as they assume many things and solve for specific usecases. Also none of them are HTAP databases which is an advantage for TiDB. Review collected by and hosted on G2.com.

Few things majorly CDC not being transactional consistent, very complex monitoring systems, hard to debug issues on your own. These are not major things but they definitely impact adoption. Review collected by and hosted on G2.com.

* Mostly MySQL compatible, makes it easier to migrate from mysql

* Much more scalable than single box mysql to support our business need

* Pingcap as the vendor is very responsive in answering our questions and address our concerns and feature request. Review collected by and hosted on G2.com.

* Some of the surrounding components may still need some work, including ticdc and log backup, though I've heard some improvements have been done in newer releases

* Not supporting shared lock, this makes some implementation on our side harder to work around the issue Review collected by and hosted on G2.com.

It’s super scalable and fast for big data, work seamlessly with MySQL and easy peasy set up to use Review collected by and hosted on G2.com.

In my experience, the performance isn’t always stable, especially with heavy queries. Even though it’s MySql compatible, i ran into a few issues where certain features weren’t fully supported. Also, some import Features are only available in the paid version which was a limiting for my use case Review collected by and hosted on G2.com.

tidb has both analytical and transactional nodes. so it will be helpful analytical kind of queries. we can scale compute and data nodes individually based on usage Review collected by and hosted on G2.com.

tidb is bit costly compared to other sql db. if we are going to run a very basic app, its going to cost you more, because we need 3 compute nodes by default and its costly. Most of the features and dashboards are available only for self hosting not for cloud hosting Review collected by and hosted on G2.com.

TiDB excels at its core task of providing horizontal scalability alongside the guarantees provided by traditional single-machine relational databases. The client interface has great compatibility with MySQL, and the incompatible aspects are well-documented. Review collected by and hosted on G2.com.

While the core components (TiDB, TiKV, PD) are mature, some others like TiCDC are less mature. They are however improving continuously. Review collected by and hosted on G2.com.

Hybrid approach, best of both worlds: OLTP and OLAP without handling sync. Review collected by and hosted on G2.com.

Does not always select the appropriate engine (TiFlash vs TiKV on version 7.5) Review collected by and hosted on G2.com.

1. TiDB combines the best of both worlds from relational and non relational database and levering the strong suit.

2. Open source-ness and transparency.

3. Efficient operations that handles the read heavy and write heavy workloads.

4. MySQL APIs are really helpful such that no special driver is required for TiDB.

5. Raft consensus protocol really stands out

6. Easy to learn and easy to setup, even the able to setup the instance in local Review collected by and hosted on G2.com.

Nothing much, some of the mysql functions, triggers were missing in the TiDB. Review collected by and hosted on G2.com.

TiDB is an excellent distributed database offering by Pingcap which provides all features along with great stability like scalability, availability, durability etc while also giving excellent performance both in terms of throughput and latency. We have managed to scale TiDB to scale to over 1 million QPS with less than 50ms latency at Flipkart which is sufficient for most requirements for SQL. Review collected by and hosted on G2.com.

The architecture is fairly complex due to which debugging latency or issues in SQL is a hastle and requires deep expertise. Review collected by and hosted on G2.com.

TiDB seamlessly combines the best of both OLTP and OLAP, allowing real-time analytics on live transactional data without ETL. Its MySQL compatibility makes migration extremely smooth, and the horizontal scalability ensures performance under high workloads. The HTAP architecture is a game-changer for businesses requiring both operational and analytical capabilities in one system. The community is active, the documentation is well-written, and tools like TiUP simplify deployment and upgrades. Review collected by and hosted on G2.com.

While TiDB is powerful, the learning curve can be a bit steep for teams unfamiliar with distributed systems. Proper configuration and tuning are essential to achieve optimal performance, especially for complex workloads. Also, while the ecosystem is growing, some third-party tool integrations still lag behind those of more established databases. However, the team is actively improving these aspects. Review collected by and hosted on G2.com.