5 ms·
At a high level: - TiDB is Open Source (Apache 2.0 license). Several others that you mention here are commercial offerings. - The expected data volume for Ti
by morgo 8y ago
At a high level:
- TiDB is Open Source (Apache 2.0 license). Several others that you mention here are commercial offerings.
- The expected data volume for TiDB is larger than memory. I believe MemSQL, for example, is memory-only.
- The architecture of TiDB is inspired by Google Spanner.
- We try to be transparent on less-suited cases. See large+small transactions, single-threaded workloads from: https://www.pingcap.com/docs/sql/mysql-compatibility/ https://www.pingcap.com/docs/sql/mysql-compatibility/
In regards to the analytical piece:
- We suggest you use TiDB for "adhoc OLAP", and Spark for more complicated cases. While parallel, the data is still stored in a row-format (more on that next year!), so an OLAP-only solution may still have performance advantages. TiDB also supports hash joins/aggregation/sort merge joins etc. So compared to MySQL for example, you should see quite a performance improvement.
Hope this helps!
- polskibus 8y agoThanks for the info. As far as I know other HTAPs often use row storage and column storage together, moving data from row to column over time. It seems like lack of such structure could be a drawback for TiDB in comparison to others.
- gregwebs 8y agoYes, that's correct. Expect more development on this front soon.