723 karma · joined April 30, 2018
- Using 2 tools Sysbench and YCSB cannot tell the strength of both databases, but we can make some judgments about the 2 databases to apply them to the actual problems.
- According to the benchmark statistics above, we see that TiDB is capable of performing Read, Read-Update transactions like the select, select update, select delete very well, whereas YugabyteDB performs well in write transactions like insert, delete, update.
- For queries that do not use transactions, both TiDB and YugabyteDB have shown their abilities, but YugabyteDB is better than TiDB in throughput and latency P99.
- For OLTP workload and some ad-hoc queries, you can use TiDB + TiKV. One of our adopters has a production cluster with 300+ TB data and can easily cope with the spike caused by the brought by COVID-19.
- For more complex queries, TiSpark+ TiKV might work well; for heavier queries, we added a columnar store, TiFlash, see https://pingcap.com/blog/delivering-real-time-analytics-and-...
Specifically full case studies: https://www.pingcap.com/success-stories/tidb-in-iqiyi/ https://www.pingcap.com/success-stories/tidb-in-zhuanzhuan/ https://www.pingcap.com/success-stories/tidb-in-eleme/ https://www.pingcap.com/success-stories/tidb-in-mobike/ https://www.pingcap.com/success-stories/tidb-in-yuanfudao/