3 ms·
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/p3
by jerryjerryjerry 4y ago
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 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.
- shenli3514 4y agoThanks 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 https://docs.pingcap.com/tidb/dev/quick-start-with-htap
- throwaway894345 4y agoHTAP?
- jerryjerryjerry 4y ago>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.
- jerryjerryjerry 4y agoEven the HTAP cloud service is available to try: https://en.pingcap.com/tidb-cloud/ https://en.pingcap.com/tidb-cloud/
- al_james 4y agoThe mixed column and row store HTAP approach is very similar to how single store works (https://www.singlestore.com/ https://www.singlestore.com/) which offers a mysql compatible interface with a few small differences.
- mathnode 4y agoMariaDB 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.