Apache Doris

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Overview

Apache Doris is an easy to use, high performance and unified analytical (OLAP) database for real-time analytics at scale. It uses a massively parallel processing (MPP) architecture and a columnar storage engine to answer interactive sub-second queries over very large datasets, and it speaks the MySQL network protocol so any MySQL client, BI tool or application driver connects to it without change. This image delivers Apache Doris fully installed and running as a single-node cluster, so an analytical database is accepting queries within minutes of launch.

Application Stack

The Apache Doris Frontend (FE) and Backend (BE) installed under a dedicated service account and run by systemd units that start them on boot and restart them on failure. The FE is a Java service that handles SQL parsing, planning and metadata; the BE is a native engine that stores the data and executes query fragments. The database storage lives on a dedicated data disk so the metadata and data are independently resizable. On a single instance the FE and BE run together as a complete, working cluster.

Real-Time Analytics

Load data with the Stream Load, Broker Load, Routine Load or INSERT interfaces, organize it into Duplicate, Aggregate or Unique key tables with automatic partitioning and bucketing, and query it in standard SQL through the MySQL protocol. Doris delivers high concurrency point lookups and high throughput complex aggregations from the same store, with materialized views, a cost based optimizer and vectorized execution.

Secure First Boot

Apache Doris ships a built-in root superuser with an empty password. On the first boot of your instance a one shot service generates a fresh root password, unique to that instance, registers the backend with the frontend, applies the new password to the database and writes it to a file only the root user can read. No shared or default database credentials ship in the image.

Ready To Use

Connect with any MySQL client on the query port and the cluster is already serving. Read the generated credentials, sign in as root, and create databases and tables straight away. The built-in Frontend web console is available on the FE HTTP port for cluster status, running queries and node health. The database storage lives on a dedicated, independently resizable data disk.

cloudimg Support

24/7 technical support by email and chat. Help with deployment, data loading, table and key model design, partitioning and bucketing, query and resource tuning, materialized views, BI tool integration and upgrade planning.

Use Cases

Real-time reporting and dashboards over fresh data. A high concurrency serving layer for user-facing analytics. Ad hoc interactive analysis of large datasets. A unified analytical store replacing a stack of single-purpose engines. A MySQL-protocol analytical backend for your BI tools.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.