Sold by: Manage StacksÂ
Deployed on AWS
AWS Free Tier
Fully automated ClickHouse deployment with SSL, Apache reverse proxy, and Basic Auth. Ready in minutes with domain mapping and secure web access.
Overview
This Amazon Machine Image (AMI) provides a fully automated, production-ready ClickHouse setup powered by Docker Compose. Designed for developers, analysts, and data engineers, it simplifies installation and configuration with secure HTTPS access, Apache reverse proxy, and built-in Basic Authentication.
On first boot, the AMI automatically guides you through domain setup, SSL certificate generation (via Let's Encrypt), and ClickHouse credential configuration. The included Tabix Web UI allows you to manage and query ClickHouse directly from your browser.
Features & Automation:
Interactive first-boot setup for domain mapping and SSL issuance
Preconfigured Docker environment for ClickHouse and Tabix web client
Apache reverse proxy with HTTPS and Basic Auth protection
Automatic data persistence and container management
Works seamlessly with any custom domain name
This AMI is ideal for teams looking for a fast, secure, and reproducible ClickHouse deployment on AWS - ready to use within minutes after launch.
Highlights
- One-Click Setup: Automated domain mapping, SSL configuration, and ClickHouse initialization on first boot.
- Secure by Default: HTTPS enabled with Let's Encrypt SSL and password-protected Basic Auth for web access.
- Web Access Included: Built-in Tabix client for visual data management through a browser interface.
Details
Sold by
Delivery method
Delivery option
64-bit (x86) Amazon Machine Image (AMI)
Latest version
Operating system
Ubuntu 24.04
Deployed on AWS
Unlock automation with AI agent solutions
Fast-track AI initiatives with agents, tools, and solutions from AWS Partners.
Features and programs
Financing for AWS Marketplace purchases
AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
Pricing
Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time.
Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.
Dimension | Cost/hour |
|---|---|
t2.medium Recommended | $0.00 |
t3.micro AWS Free Tier | $0.00 |
m6in.32xlarge | $0.00 |
c5ad.8xlarge | $0.00 |
c7i.large | $0.00 |
i7i.2xlarge | $0.00 |
c5a.xlarge | $0.00 |
m5a.4xlarge | $0.00 |
r6idn.xlarge | $0.00 |
c6id.32xlarge | $0.00 |
Vendor refund policy
This product is currently offered free of charge on AWS Marketplace. Since there are no fees associated with the use of this AMI, refunds are not applicable.
Buyers may cancel use of the product at any time by terminating the associated Amazon EC2 instance.
For any questions or concerns, please contact: Perimattic.com Email: aws@perimattic.comÂ
Legal
Vendor terms and conditions
Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA)Â .
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
-
Automated ClickHouse Deployment: Fully preconfigured ClickHouse environment using Docker Compose, featuring ClickHouse Server and Tabix Web Client for seamless analytical query management and data exploration.
-
Guided First-Boot Setup: Interactive initialization script automates domain mapping, admin email setup, password generation, and DNS validation with real-time user prompts and error handling.
-
Automated SSL/TLS Provisioning: Integrated with Let's Encrypt and Certbot for automatic SSL certificate issuance, ensuring secure HTTPS access to ClickHouse and Tabix via Apache reverse proxy.
-
Secure Configuration Management: Environment variables stored in a centralized .env file manage domain details, admin credentials, and passwords, enabling consistent and secure deployments.
-
Optimized Container Architecture: Docker Compose-based configuration orchestrates ClickHouse and Tabix containers for improved performance, data persistence, and simplified updates.
-
Apache Virtual Host Automation: Automatically generates Apache virtual hosts for both HTTP and HTTPS, dynamically replacing placeholders with user-specified domain information during setup.
-
Custom Domain & DNS Verification: Validates DNS mapping before SSL issuance, ensuring that the provided domain correctly resolves to the instance's IP address for reliable and secure configuration.
-
Built-in Web Client (Tabix): Includes a fully configured Tabix Web UI for querying and managing ClickHouse directly from a browser with Basic Authentication protection.
-
Failsafe Setup & Recovery: Intelligent failsafe script (failsafe.sh) ensures that all initialization steps execute reliably, automatically retrying any failed steps and recovering from interruptions.
-
Production-Ready Analytical Database: Tuned for high-performance OLAP workloads and real-time analytics, this AMI enables instant deployment of a secure, web-accessible ClickHouse server within minutes.
Additional details
Usage instructions
-
Launch an Instance
From AWS Marketplace, click Continue to Subscribe and then Continue to Configuration.
-
Choose the Recommended Instance Type
Select t2.medium or larger for optimal performance and stability.
-
Configure Security Group
Allow inbound traffic on the following ports:
- 22 (SSH) - for secure terminal access
- 80 (HTTP) - for initial domain verification and SSL setup
- 443 (HTTPS) - for secure access to ClickHouse and Tabix Web UI
- 28123 - ClickHouse HTTP port (optional external access)
- 28124 - Tabix Web UI port (optional direct access)
-
Connect to the Instance
ssh -i <your-key.pem> ubuntu@<public-ip>
-
First-Boot Setup
On first launch, the initialization scripts automatically perform the following actions:
- Detect your public IP address
- Prompt you to enter a custom domain for ClickHouse access
- Validate your DNS A record to ensure it resolves to your instance
- Prompt for an admin email (used for SSL and notifications)
- Automatically generate or accept a ClickHouse root password
- Configure Apache virtual hosts and prepare for SSL provisioning
-
Configure DNS (if using a custom domain)
- Add an A record in your DNS provider pointing your domain (e.g., example.com) to the instance's public IP.
- The setup automatically checks DNS propagation using multiple resolvers before continuing.
-
Automatic SSL Setup
- Once DNS validation is complete, Certbot issues and installs a Let's Encrypt SSL certificate for your domain.
- Apache is automatically configured to serve ClickHouse and Tabix securely over HTTPS.
-
Start ClickHouse
The ClickHouse and Tabix containers are automatically started using Docker Compose. To manually verify or restart the containers, run:
cd /opt/app docker compose ps docker compose restart
-
Access ClickHouse and Tabix
Access securely via https://<your-domain>
The Tabix interface allows direct querying and management of your ClickHouse instance.
-
Login Credentials
Default credentials are stored in the environment file located at:
cat /opt/app/.env
- Username: root
- Password: (stored securely in .env as SOFTWARE_PASSWORD)
-
Environment File
All configuration details - domain, admin email, credentials, and SSL status - are stored in:
/opt/app/.env
This file is automatically created and updated during the first boot.
Support
Vendor support
For any assistance or inquiries, our dedicated support team is here to help 24/7. Feel free to reach out to us anytime. Email: support@cro-digital.co.uk We are committed to providing timely and effective solutions to meet your needs.
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Similar products
Aiven's Platform provides AWS users a comprehensive set of popular open source data technologies, such as PostgreSQL®, Apache Kafka®, ClickHouse® and OpenSearch®, as a fully managed service.
NetApp® Instaclustr is the leading managed service provider for enterprise deployments of open source data products. Instaclustr offers scalable, performant and reliable databases.
Get EKS monitoring and automated cost optimization in one easy-to-use platform. We show you how much you spend on EKS, and then we reduce your cost by 50 to 75% automatically. With active smart and automated rightsizing and pricing arbitrage, your cluster is continuously efficient.
24/7 in-house monitoring service, in addition to the system development and tuning security rules of Trend Micro Cloud On Workload Security, on AWS
Production grade bitcoin node, fully synchronized with the bitcoin blockchain running the latest versions of Ubuntu and Bitcoin Core.
Migrating to AWS isn't just a cost-saving move, it's a chance to modernize.
-Lower overhead cost by eliminating VMware licensing, hardware refresh cycles, and data center operating expenses
-Predict costs with per-VM and flexible billing plans
-Right-size resources with EC2 instances optimized for your workloads
-Scale instantly to match business needs
-Prepare for the future with managed services options like RDS, EKS, and Lambda
All backed by a proven migration roadmap delivered by Opti9's migration experts.
Deliver fast, fresh insights to your end-users with our easy-to-use analytics platform, built by the original authors of Apache Pinot.
Customer reviews
No customer reviews yet
Be the first to review this product . We've partnered with PeerSpot to gather customer feedback. You can share your experience by writing or recording a review, or scheduling a call with a PeerSpot analyst.