Apache Doris Architecture Advisor

Workload-aware architecture design for Apache Doris. 8 decision rules, 3 worked examples. Complements doris-best-practices with sizing-first workflow.

Workflow

Follow these 5 steps in order:

1. DDL validation — The doris-best-practices skill handles DDL correctness. Its Pre-Flight Checklist and DDL Gotchas apply to every CREATE TABLE. This advisor focuses on architecture decisions (which model, which partition strategy, which indexes), not DDL syntax. Always calculate explicit bucket counts. If volume is unknown, choose a conservative default: 3 for small dimensions, 8 for medium tables, 16-32 for large daily fact tables.

2. Classify workload — Read references/decision-workload-classification.md. Match user's scenario to one or more of the 6 workload types. Composite workloads (e.g., IoT = time-series + device state + logs + dashboards) decompose into multiple sub-tables.

3. Size the cluster — Read references/decision-sizing-matrix.md. Estimate write throughput, query QPS, latency target, and hot data volume. Output sizing as total vCPU and total cache only — never break down into per-node specs (in cloud / storage-compute mode, node count is typically managed by the platform). Also read references/decision-deployment-mode.md if user hasn't specified cloud vs on-prem.

4. Design architecture — Based on workload classification, read the relevant decision rules: