1. It is a fully managed database as a service running on AWS, cost saving for operation and management.
2. On-demand expansion nodes for peak traffic.
3. Mysql ecosystem compatibility.
4. supports processing both TP and AP workloads. Review collected by and hosted on G2.com.
1. Sometimes it may causes higher resource consumption for smaller workloads scenario.
2. Currently does not support azure. Review collected by and hosted on G2.com.
14 out of 15 Total Reviews for TiDB
Overall Review Sentiment for TiDB
Log in to view review sentiment.
There are a lot of useful features. I will bring up the 4 top most useful features for us:
1. MySQL compatibility
2. Built-in high availability
3. Horizontal scaling
4. Built-in CDC (Change Data Capture) Review collected by and hosted on G2.com.
At the time this review written, TiDB lack of Postgres compatibility and not support any kind of stored procedure Review collected by and hosted on G2.com.
Easy to use because it is highly compatible with MySQL protocol, reduces the costs of operations and migration.
It can consolidate all upstream MySQL instance data in one TiDB cluster, we do not need to care about underlying data sharding.
One-stack HTAP simplifies the data stack.
And good technical support. Review collected by and hosted on G2.com.
For some complex analysis queries, the pressure of TiKV storage resource is still relatively large.
Lack of robust resource control capabilities in current v6 version. Review collected by and hosted on G2.com.
1. The distributed architecture provides seamless scalability, making the data platform more agile.
2. One stack real-time HTAP capability
3. It is compatible with MySQL protocol, we do not change the app codes.
4. Avoid the cloud vendor lock-in, and the support team is good. Review collected by and hosted on G2.com.
1. The sync diff function is imperfect and cannot compare the json and timestamp fields.
2. There is no mechanism for redirecting to TiKV when TiFlash is down, it will cause some query problems. Review collected by and hosted on G2.com.
As a DBA with a foundation in MySQL, moving to TiDB requires almost no learning cost and is very user-friendly.
Each component in the TiDB cluster has achieved high availability design.
The Resource Control feature was good for the multi-tenant needs of different businesses. Review collected by and hosted on G2.com.
Upgrading across major versions may encounter some unknown issues. Review collected by and hosted on G2.com.
Overall we are satisfied with TiDB adoption. TiDB has many good features I love, here I highlight some top useful features for our company: 1. Finalcial-grade HA; 2. Online elastic expansion and contraction; 3. Support high concurrency and analytics workload; 4. Rich ecosystem of useful tools. Review collected by and hosted on G2.com.
1. Lack of data compression capability; 2. TiFlash testing performance is not good enough, and it requies much higher hardware resource. Review collected by and hosted on G2.com.
TiDB solves the issue of MySQL’s large single instances being unable to scale up.
TiDB provides a relatively convenient way to scale up and down. Review collected by and hosted on G2.com.
TiDB is a bit more expensive.
TiDB requires powerful hardware. Review collected by and hosted on G2.com.
TiDB's HTAP capability enables real-time analytics based on the transactional data, it is very important for us to generate instant insights and make decisions.
Horizontal scaling is another one, it benefits us to manage the workload efficiently. Review collected by and hosted on G2.com.
1. TiDB needs to enhance the optimization for wide table use case.
2. The management console can integrate more clinic and monitoring tools to simply daily operations. Review collected by and hosted on G2.com.
By TiDB's navtive HA with multiple replicas and good read/write performance, it smoothly addressed the challenges of large data volumes and heavy queries, notably reducing the query time and improving overall efficiency. Review collected by and hosted on G2.com.
Some complex SQL executions may lead to OOM issues. The stability needs to enhance to make sure it does not impact cluster operations. Review collected by and hosted on G2.com.
Good stability and scalability.
Easy to adopt data from MySQL.
Easy to be deployed in Kubernetes cluster using TiDB operator.
Offering OLAP features speeding up our statistics. Review collected by and hosted on G2.com.
Resource consumption is a little high.
There is a certain threshold for operation and maintenance. Review collected by and hosted on G2.com.
TiDB supports horizontal scalability and it can handle large single table without sharding manually. It is highly compatible with MySQL protocols, almost no need to do the application changes. Review collected by and hosted on G2.com.
Continuous improvement in product stability is essential. Review collected by and hosted on G2.com.
