FAQ about Stackhero for ClickHouse cloudClickHouse

Stackhero is a 🇪🇺 European company, GDPR compliant, with servers in 🇪🇺 Europe and 🇺🇸 USA according to your preferences.

What is included with Stackhero for ClickHouse?

We provide ClickHouse and a reverse proxy with a TLS certificate, all pre-configured.
ClickHouse is ready to use right away, with nothing else to install.

How many queries can I run?

As many as your instance can support. Stackhero never charges per query, per terabyte scanned, or per compute credit: all your instance's resources are fully dedicated to you, for a fixed hourly rate.

How much data can I store?

You can store data up to the disk size included in your selected plan. ClickHouse efficiently compresses columnar data, so each plan usually accommodates much more raw data than the disk size alone would indicate. As your needs grow, you can upgrade to a larger plan with just one click.

How do I connect and import my data?

ClickHouse provides both the native protocol and an HTTP interface, allowing you to use official clients, JDBC/ODBC drivers, and most BI tools. Data can be loaded from files or streamed continuously from sources like Kafka, S3, PostgreSQL, and MySQL.

Can I use my own domain?

Yes. You can configure a custom domain with a TLS certificate (SSL/HTTPS), so your ClickHouse service uses your branded URL.

Which version of ClickHouse do you offer?

Stackhero is committed to always providing you with a recent and stable version of ClickHouse, so you can benefit from the latest features and security updates.

Is it possible to connect to the instance using SSH?

Stackhero offers managed services, so SSH access is not available. If you have a specific requirement, please contact support and we will help you find a solution.

Is it possible to restrict access based on IPs with a firewall?

Absolutely! Your instance has its own firewall where you can decide which IPs have access to which port in just 2 clicks.

Which cloud providers are used by Stackhero?

We developed our own cloud software solution, making us entirely independent from cloud providers. We deploy this innovative solution directly on bare-metal servers, offering you exceptional performance and stability.

Where is the data hosted?

Stackhero is a French company operating under European and French laws.
Servers are located, depending on your choice, either in the European Union (France) or in the USA.
Backups are stored in the European Union.

What is the software infrastructure?

Your service consists of several subservices, each running in containers within an environment dedicated entirely to you.
This environment is private and isolated from other customers, ensuring strong security and optimal performance.
Everything is hosted on a bare-metal server running Stackhero DC OS, our own Linux distribution, with disks physically attached to your instance to provide maximum IOPS.

This isolation is guaranteed by a dedicated virtual machine for each customer, not by shared containers on a multi-tenant host.

What about disk performance?

We use disks that are physically connected to your instances.
We don't use network disks, unlike traditional cloud solutions, which are slow and costly.
This way, we ensure optimal performance and exceptional IOPS.

What is the atomic backup system?

The issue with traditional backup systems is that files are saved at different time intervals.
Let's say you have 2 files, a.txt and b.txt. Your backup starts at 9 a.m. and finishes at 10 a.m.
The file a.txt will contain data from 9 a.m. and b.txt will contain data from 10 a.m.
This is common in backup systems and leads to significant consistency issues.

This is why we developed an in-house backup system that captures an atomic image of your instance at a precise moment.
Atomic in the sense that we can guarantee all files in the backup are captured at exactly the same time.
If your backup starts at 9 a.m., all files will have data from 9 a.m. You have a perfectly consistent and reliable backup.

Are the backups encrypted?

Backups are initially sent to a dedicated server, which verifies and validates the data. Once these checks are approved, the backups are encrypted and archived.
Encryption uses ECDH and Curve25519 as part of the OpenPGP protocol, with a unique key generated for each backup.

How does billing work?

At the start of each month, our system calculates the number of hours your services were operational, and a detailed invoice is generated.
You receive a single monthly invoice that consolidates all your services, clearly explained and easy to understand. Your accounting department will love it!

What certifications does Stackhero hold?

Stackhero's primary mission is to provide a platform that is easy to use, extremely reliable, and highly secure.
A key element in achieving this mission is the annual attainment of the ISO 27001 certification, a globally recognized quality and security label.
This certification, awarded following a rigorous audit conducted by an independent external body, attests to compliance with the strictest international standards in information security.
Launch ClickHouse in just 2 minutes (coming soon to Stackhero).
Query billions of rows in milliseconds.