Online Analytical Processing use Starrocks
Recently, my discord group have a discussion about OLAP (Online Analytical Processing) Problem: Run complex analytics query slow in normal mysql setup. Solution: Use Starrocks to speedup the query. How It Works: From main application db (MySQL) have to turn-on the binlock Apache Flink will connect the mysql binlock to Starrocks Starrocks will store synced data from the binlock into column-oriented data using Apache Parquet How to: Here is quick start https://docs.starrocks.io/en-us/latest/quick_start/deploy_with_docker Hardware Requirement: 8 CPU cores and 16 GB RAM to each FE node. 16 CPU cores and 64 GB RAM to each BE node. Other Related Topics: HTAP - Hybrid Transactional and Analytical Processing [ medium ]