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

How to: 
Here is quick start

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:


Popular Posts