StarRocks on Ubuntu 24.04 LTS

Azure Databases

StarRocks, a high performance MPP analytical database that speaks the MySQL protocol, so your existing SQL tools query it directly and results come back fast.

Base
Hardened build
minimal ports, security patches applied at build time
Access
Unique credentials
generated on first boot, readable only by root
Verified
Boots working
services pass a health gate before release
Support
24/7, 365 days
by email and live chat, 24 hour response SLA

Overview

StarRocks is an open source, massively parallel analytical database built for sub second queries over large datasets. It pairs a vectorised execution engine with a cost based optimiser and a columnar storage layer, so aggregations, joins and group by queries over hundreds of millions of rows return in the time an ordinary database would spend planning. Because it speaks the MySQL wire protocol, every client, driver, BI tool and dashboard that already talks to MySQL connects to it unchanged, with no new driver to install and no new query language to learn.

It runs as two cooperating roles: a Frontend that handles SQL parsing, planning and metadata, and a Backend that stores data and executes the query fragments. As well as its own native tables, StarRocks can query external data in place through catalogs for Hive, Iceberg and Paimon, so a lakehouse can be queried with the same SQL as local tables. It suits analytics and data platform teams who want interactive query speed over large volumes, real time dashboards that stay responsive as data grows, and a warehouse they run inside their own cloud account.

Why the cloudimg image

cloudimg delivers a complete single node StarRocks ready to query: the Frontend and Backend are installed, memory tuned and registered with each other, so a working MySQL endpoint answers real analytical SQL within minutes of boot with nothing to wire up. It is secure by default in a way that matters here, because StarRocks' built in root account ships with no password at all: on the first boot of every instance a unique root password is generated and written to a root only file, and it is set inside a firewall window that keeps the database unreachable from every network interface until that password is proven live, so no instance is ever exposed with an unauthenticated root. The internal Frontend and Backend ports stay on the loopback interface and only the MySQL protocol port is serviceable. The image is also fully open source licensed: two Oracle proprietary JDBC jars that upstream bundles are removed at build time, which means the Oracle external catalog connector is not available, while native tables and the Hive, Iceberg and Paimon catalogs are unaffected. Data lives on a dedicated volume captured into the image, memory limits adapt to whatever size you launch, the base is fully patched with unattended security upgrades enabled, and every deployment is paired with a step by step deploy guide and backed by 24/7 cloudimg support.

Common uses

  • Run interactive, sub second analytical SQL over hundreds of millions of rows
  • Power real time dashboards and BI tools through the MySQL protocol they already speak
  • Query lakehouse data in Hive, Iceberg and Paimon alongside native tables