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) Análise coletada por e hospedada no G2.com.
At the time this review written, TiDB lack of Postgres compatibility and not support any kind of stored procedure Análise coletada por e hospedada no G2.com.
14 de 15 Avaliações Totais para TiDB
Sentimento Geral da Revisão para TiDB
Entre para ver o sentimento das avaliações.
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. Análise coletada por e hospedada no G2.com.
1. Sometimes it may causes higher resource consumption for smaller workloads scenario.
2. Currently does not support azure. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no G2.com.
Upgrading across major versions may encounter some unknown issues. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no G2.com.
1. Lack of data compression capability; 2. TiFlash testing performance is not good enough, and it requies much higher hardware resource. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no G2.com.
TiDB is a bit more expensive.
TiDB requires powerful hardware. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no G2.com.
Resource consumption is a little high.
There is a certain threshold for operation and maintenance. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no G2.com.
Continuous improvement in product stability is essential. Análise coletada por e hospedada no G2.com.
