Making an HTAP Database a Reality: What I Learned from PingCAP's VLDB Paper
pingcap.com
pingcap.com
Oracle's In-Memory option offers dual Row and Columnar storage for Hybrid Transactional/Analytical workloads. The paper describing the feature was published to VLDB in 2015 : https://dl.acm.org/doi/10.14778/2824032.2824061
They're always "the first", "the best" or "the fastest". So I tried TiDB on our real life workload and it was 5x slower than a single MySQL instance when running 3 shards. This doesn't jive with any of the blog posts they release.
I really think they're running a marketing racket with a bunch of sockpuppets on various social media platforms. Such speculation on here usually summons Dang but I don't see how they can otherwise get to front page of HN and other coder forums so regularly. It doesn't make sense.
Having "a paper" that's high impact but somewhat plagiarized fits their MO to me. I'm an admitted conspiracy theorist and I am ever sceptical of their claims
As for referring our PVLDB as “the first industry paper”, thanks @karsinkk for pointing out. We admit that the original description was inaccurate and just updated it to be “This is the first paper in the industry to describe the Raft-based implementation of a distributed Hybrid Transactional/Analytical Processing (HTAP) database.”
However, we have never claimed ourselves as “the best, the fastest.” If you find such occurrences and think they are inaccurate, please do share with us and we will correct the same ASAP. As pointed in https://pingcap.com/blog/9-why's-to-ask-when-evaluating-a-di..., “There's no single technology that can be the elixir to all your problems. The database realm is no different. If your data can fit on a single MySQL instance without too much pressure on your server, or if your performance requirement for complex queries isn't high, then a distributed database may not be a good choice. Choosing to use a distributed database typically means additional maintenance cost, which may not be worthwhile for small workloads. “
Regarding your comparison between TiDB and MySQL, there are differences between MySQL and TiDB as stated here: https://opensource.com/article/18/11/key-differences-between.... If you are still interested in trying out TiDB with your real life workload, we are very happy to help you. Please reach out to us in our community Slack: https://slack.tidb.io/invite?team=tidb-community&channel=eve...