Skip to main content

Posts

Featured

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 ]

Latest Posts

Insomnia alternative to Postman for API Development Collaboration

Zero Trust alternative to Ngrok for tunnel with custom domain

Separation of Layout and Logic in Flutter

Using Error Reporting in Cloudrun with Laravel PHP

Dart FormBuilder Dotted-Style Map To Nested Map

Having 'Open With Vscode' in Windows Context Menu

Having PHP5.6 works with SQL Server Driver on Windows

Setup SSL for Litespeed Webadmin