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]