Online Analytical Processing use Starrocks
Recently, my discord group have a discussion about OLAP (Online Analytical Processing)
Run complex analytics query slow in normal mysql setup.
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
Here is quick start
- 8 CPU cores and 16 GB RAM to each FE node.
- 16 CPU cores and 64 GB RAM to each BE node.