What our engineers handle on ClickHouse
This is the hands-on work, done by a person: the jobs the automatic tools cannot do for you.
- 1Set memory and query limits so one query cannot take the server
- 2Design retention with TTL and partitions, and watch the merge backlog
- 3Back up with clickhouse-backup or snapshots and test restoring
- 4Set up replication and plan upgrades between versions
Problems we fix
Problem
The server runs out of disk quickly
What we do
We find the large tables and parts, set TTL and compression and clean old partitions safely.
Problem
Queries are killed for memory or run very slowly
What we do
We review the table design, sorting key and query limits, and adjust what matters most.
Problem
Too many parts errors on inserts
What we do
We batch inserts, change merge settings and fix the application that writes row by row.
Automatic tools, and our team for the rest
RootManage is automatic server management with every tool in one place. The tools run by themselves on a schedule and report to one dashboard. Everything they cannot do, and every emergency, is handled by our engineers by hand.
Automatic
RootManage tools, running by themselves
- Server Health agent reports load, disk use and failed login attempts to your dashboard.
- Metrics agent draws CPU, memory, disk and network charts, sampled every five minutes.
- Uptime checks check the server every minute and email you when it stops answering, and again when it recovers.
- Backup agent runs scheduled backups at 02:00 IST to storage we provide or to your own SFTP or S3 box, with help restoring.
Manual, by our engineers
Everything else, and every emergency
- Hands-on work. Fixes, tuning, migrations, upgrades and the other jobs listed above on this page.
- Emergency work. A hacked site, an outage or a failed update is handled by a person who investigates and fixes it, not by a script.
- Things we do not automate. Anything the tools do not cover is done by hand, over SSH, WHM or RDP, on a login you can remove at any time.
The tools are optional, run on Linux servers and are installed by you with one command each. Every job our team does is recorded as a task in your dashboard with the details, and you get an email when it is updated.
How it works
- 1
Sign up
Create an account, choose a plan and add the server you want managed.
- 2
Install the tools
Run one command per tool. They then work by themselves and report to your dashboard. For hands-on work you give us a login you can remove at any time.
- 3
Automatic, with people behind it
The tools watch, scan and back up automatically and alert you. Our engineers do the rest by hand and handle every emergency, and you follow each task in your dashboard.
Questions about ClickHouse
Is ClickHouse right for my data?
It is excellent for large analytical or log data and not for small transactional records. We tell you honestly if a normal database is a better fit.
Can you move data from PostgreSQL to ClickHouse?
Yes. We set up the pipeline and verify counts, and design the target tables for your queries.
What does it cost to have ClickHouse managed?
Managed plans start at ₹1,999 a month for one server, and ClickHouse is managed as part of the server. The pricing page lists what each plan includes. If a server is already infected, the emergency cleanup is a one-time ₹9,000 job.