What is included with Stackhero for ClickHouse?
We include ClickHouse and a reverse proxy with a TLS certificate, all pre-configured.
ClickHouse is ready to use straight away, with nothing else to install.
How many queries can I execute?
As many as your instance can support. Stackhero never charges per query, per terabyte scanned, or per compute credit: all the resources of your instance are fully dedicated to you, for a fixed hourly rate.
How much data can I store?
You can store data up to the disk capacity included in your selected plan. ClickHouse compresses columnar data efficiently, so each plan generally accommodates significantly more raw data than the disk size alone would indicate. As your requirements increase, you can upgrade to a higher 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 imported from files or streamed continuously from sources such as 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 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 using a firewall?
Absolutely! Your instance has its own firewall where you can decide which IPs have access to which port in two 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 exclusively to you.
This environment is private and isolated from other customers, ensuring a high level of security and optimal performance.
Everything is hosted on a bare-metal server running Stackhero DC OS, our own Linux distribution, with disks physically connected to your instance to provide maximum IOPS.
This isolation is achieved through a dedicated virtual machine for each customer, rather than shared containers on a multi-tenant host.
What about disk performance?
We use disks that are physically connected to your instances.
We do not 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 9am and finishes at 10am.
The file a.txt will contain data from 9am and b.txt will contain data from 10am.
This is typical in backup systems and presents a significant problem leading to 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 from the backup are taken exactly at the same time.
If your backup starts at 9am, all files will have data from 9am. 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 employs 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 appreciate that!
What certifications does Stackhero hold?
The primary mission of Stackhero 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 recognised 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.