ClickHouse preinstalled for AWS. The open source column oriented analytics database with the HTTP interface and the native TCP protocol, with a per instance default user password generated on first boot. Backed by 24/7 cloudimg support.
## ClickHouse by cloudimg
ClickHouse is the open source column oriented analytics database built for very fast queries over very large amounts of data. This Amazon Machine Image delivers ClickHouse fully installed and configured, so an analytics database is running within minutes of launch. The current stable release is provided.
## Application Stack
The image runs ClickHouse as a single node, installed from the official ClickHouse package repository, with the HTTP interface on port 8123 (which also serves the built in /play SQL playground), the native TCP protocol on port 9000 and inter server replication on port 9009. The clickhouse client command line tool is preconfigured for local administration. Database data is stored on a dedicated resizable volume and the service starts on boot.
## Secure First Boot
On the first boot of every instance a one shot service generates a fresh default user password, unique to that instance, applies it inside ClickHouse and writes it to a root only file. No shared or default credentials ship in the image.
## Ready To Use
The ClickHouse service, data directory, configuration and default user are all configured. Open the clickhouse client shell, run queries from any HTTP client or browse the built in /play SQL playground after restricting the HTTP port to trusted networks.
## cloudimg Support
cloudimg provides 24/7 technical support for this image, covering ClickHouse deployment, schema design, query tuning, replication and database administration.