Hacker News Reader

Comment by jerryjerryjerry | Hacker News Reader

This is a good HTAP system for PostgreSQL ecosystem. Emm, what about a MySQL compatible HTAP system? An open source project (https://www.vldb.org/pvldb/vol13/p3072-huang.pdf) seems a good fit in this area that process both transactional and analytical workload at real-time.

View on HN

Thanks for mentioning TiDB here. It is mysql compatible HTAP database. But different with AlloyDB. We do not reuse the code of MySQL/PostgreSQL. So there is no legacy code and more suitable for the HTAP scenario. It is easy to scale out and available on any cloud. More information here: https://docs.pingcap.com/tidb/dev/quick-start-with-htap

The mixed column and row store HTAP approach is very similar to how single store works (https://www.singlestore.com/) which offers a mysql compatible interface with a few small differences.

MariaDB Columnstore! And now Xpand has columnar indexes.

Columnstore was previously known as InfiniDB and Xpand, Clustrix. Both have been in production for over 10 years and I have been a very happy user of them.

Even the HTAP cloud service is available to try: https://en.pingcap.com/tidb-cloud/

HTAP?

>Recently, at Google I/O, we announced AlloyDB for PostgreSQL, a fully-managed, PostgreSQL-compatible database for demanding, enterprise-grade transactional and analytical workloads.

This is exactly what a HTAP(Hybrid Transactional and Analytical Processing) system does.

Reply on news.ycombinator.com