Sold by: Lynxroute
Deployed on AWS
Free Trial
This is a repackaged open source software product wherein additional charges apply for hardening, security configuration, and setup support.
ClickHouse is an open-source column-oriented OLAP database written in C++ for real-time analytics on billions of rows. This Lynxroute build is hardened and ready out of the box: a strong random password generated at first boot and stored as SHA-256 hex, UFW firewall pre-configured, fail2ban and AppArmor enabled, and a CIS Level 1 hardened Ubuntu 24.04 LTS base.
Apache-2.0 license - fully auditable, no vendor lock-in.
Overview
This is a repackaged open source software product wherein additional charges apply for hardening, security configuration, and setup support.
WHAT IS CLICKHOUSE
ClickHouse is an open-source column-oriented online analytical processing (OLAP) database management system written in C++ and distributed as a single compiled native binary. It is designed for low-latency analytical queries over very large tables: aggregations, time-series rollups, ad-hoc SQL on billions of rows. Features include the MergeTree storage engine with automatic part merges and partitioning, distributed and replicated tables for horizontal scale-out, materialized views, dictionaries, projections, an HTTP REST API on port 8123, a fast native binary protocol on port 9000, and a built-in web SQL console at /play. SQL is extended with array, tuple, nested, JSON, and IPv4/IPv6 types. Standard ODBC and JDBC drivers and client libraries for most popular languages are available. Data is persisted on local disk under /var/lib/clickhouse - no external database required for single-node deployments. Apache-2.0 license, no vendor lock-in. A self-hosted alternative to proprietary cloud data warehouses for hot-data analytics, keeping all data inside your own AWS account.
WHAT THIS AMI ADDS
Security hardening:
- Strong random 32-character password generated per instance at first boot for the ClickHouse default user
- Password stored only as SHA-256 hex in users.d drop-in - never written in plain text inside the AMI
- UFW firewall pre-configured - ports 8123 and 9000 open externally for buyer use, port 22 for SSH; all other inbound traffic dropped
- fail2ban, AppArmor enabled
- CVE scan - every image is scanned for vulnerabilities before release
OS hardening (CIS Level 1):
- CIS Ubuntu 24.04 LTS Level 1 benchmark applied via ansible-lockdown
- auditd, SSH hardening (key-only, PermitRootLogin no, LoginGraceTime 60), Kernel hardening (ASLR, reverse path filtering, SYN cookies, kexec disabled, IPv6 off), IMDSv2 enforced
Compliance artifacts:
- SBOM - CycloneDX 1.6 at /etc/lynxroute/sbom.json
- CIS Conformance Report at /etc/lynxroute/cis-report.html
- CIS Tailored Profile at /usr/share/doc/lynxroute/CIS_TAILORED_PROFILE.md
Highlights
- ClickHouse security baked in: strong random password for the default user generated at first boot and stored as SHA-256 hex, UFW firewall pre-configured, fail2ban and AppArmor enabled.
Details
Sold by
Categories
Delivery method
Delivery option
64-bit (x86) Amazon Machine Image (AMI)
Latest version
Operating system
Ubuntu 24.04
Deployed on AWS
New
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
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
Free trial
Try this product free for 5 days according to the free trial terms set by the vendor. Usage-based pricing is in effect for usage beyond the free trial terms. Your free trial gets automatically converted to a paid subscription when the trial ends, but may be canceled any time before that.
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 |
|---|---|
m6i.xlarge Recommended | $0.05 |
m6i.2xlarge | $0.05 |
t3.large | $0.05 |
t3.xlarge | $0.05 |
Dimensions summary
You pay by the hour based on the EC2 instance size you run. Four instance options are available: t3.large, t3.xlarge, m6i.xlarge, and m6i.2xlarge. The t3 options use burstable instances, while the m6i options use general-purpose instances with more consistent compute. Within each family, the larger size (xlarge or 2xlarge) provides more CPU and memory. Billing is hourly, so your cost scales with how long each instance runs. All four options deliver the same hardened ClickHouse image; you choose the instance based on your workload size.
Top-of-mind questions for buyers
Each option maps to an AWS EC2 instance type. The t3.large and t3.xlarge run on burstable instances with baseline CPU and burst credits. The m6i.xlarge and m6i.2xlarge run on general-purpose instances with steady compute. Larger sizes add more vCPUs and memory for heavier ClickHouse workloads.
Software charges meter running instance-hours. When you stop the instance, the hourly software charge stops accruing. Stopped instances may still incur underlying AWS storage fees for attached volumes, billed separately by AWS. You pay the software rate only while the instance runs.
Yes. Every option ships the same CIS Level 1 hardened Ubuntu 24.04 image with ClickHouse pre-installed. Each includes CVE scanning, a CycloneDX SBOM, a CIS Conformance Report, and unique credentials generated at first boot. You choose the instance by workload size, not by feature set.
lynxroute.com
Helpful?
Vendor refund policy
We do not offer refunds for this product. AWS infrastructure charges (EC2, EBS, data transfer) are billed separately by AWS and are not refundable by us.
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
ClickHouse 26.7.5.10
- ClickHouse 26.7.5.10 on Ubuntu 24.04 LTS - patch update from 26.7.3.19 on the 26.7 line. Apache-2.0 unchanged
- Fixes a Nullable(Tuple(...)) column being flattened across several CSV fields, which gave a row-dependent column count and broke CSVWithNames / CSVWithNamesAndTypes round-trips
- Fixes uniq, uniqExact, uniqHLL12 and uniqTheta returning a wrong result for an argument wrapped in an injective function that hides nullability
- Fixes SELECT count(arrayJoin(arr)) returning the stored row count instead of the number of array elements, and 0 over file() and url()
- Fixes has, indexOf, countEqual, mapContainsKey, mapContainsValue and Map subscript returning "not found" for a constant LowCardinality needle equal to the element type's default
- Fixes a settings profile carrying a Map-valued setting (http_response_headers, additional_table_filters) being stored unreadably and left permanently unloadable after a restart
- Rejects a corrupted or malicious dictionary before the buffer write, and fixes setting propagation and NULL handling in accurateCastOrDefault
- Rebuilt on the latest CIS Level 1 hardened Ubuntu 24.04 LTS base
Additional details
Usage instructions
- Launch instance (m6i.xlarge recommended; t3.large minimum, m6i.2xlarge for enterprise / large indexes)
- Open Security Group - allow TCP 8123 and TCP 9000 from your IP only
- SSH: ssh -i key.pem ubuntu@<PUBLIC_IP>
- Read credentials: sudo cat /root/clickhouse-credentials.txt
- Test the HTTP API: curl -u "default:<password>" "http://<PUBLIC_IP>:8123/?query=SELECT+version()"
- Open the web SQL console: http://<PUBLIC_IP>:8123/play - log in as user "default" with the password from the credentials file
- Connect via native protocol from your workstation: clickhouse-client --host <PUBLIC_IP> --password "<password>" --query "SELECT 1"
The default-user password is generated at first boot and saved to /root/clickhouse-credentials.txt (mode 600). For production use, restrict TCP 8123 and 9000 to trusted IPs (never 0.0.0.0/0) and terminate TLS in a reverse proxy in front of the HTTP endpoint. Data is persisted at /var/lib/clickhouse - for production attach a dedicated gp3 EBS volume mounted there for higher IOPS.
Resources
Vendor resources
Support
Vendor support
Lynxroute is not affiliated with ClickHouse, Inc. - this AMI packages the Apache-2.0 open-source ClickHouse distribution; ClickHouse(R) is a registered trademark of ClickHouse, Inc.
Visit us online: https://lynxroute.com
For ClickHouse documentation: https://clickhouse.com/docs For ClickHouse upstream issues: https://github.com/ClickHouse/ClickHouse/issues For AWS infrastructure issues:
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
ClickHouse Cloud is an extraordinarily fast, seamlessly scalable and delightfully easy-to-use online analytical database. Start today and receive $300 in free credits.
ClickHouse Cloud is an extraordinarily fast, seamlessly scalable and delightfully easy-to-use online analytical database.
ClickHouse connector for AWS Glue, built on DataSourceV2 API.
This product has charges associated with it for image hardening, maintenance, and support. ClickHouse columnar OLAP database on Amazon Linux 2023, security-hardened for production: minimal package set, SSH key-only access, IMDSv2-only, bound to loopback with no default remote access, and continuously patched images.
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.