2 ms·
If you can run MySQL you can run ClickHouse. They are both about the same level of effort operationally. Your case sounds pretty simple and can be addressed wit
by hodgesrm 4y ago
If you can run MySQL you can run ClickHouse. They are both about the same level of effort operationally. Your case sounds pretty simple and can be addressed with one or more single node systems.
As far as whether it works on a single core, you probably need to load data and test. That's the only way to answer that question for sure.
IMO the real question for any database is whether you can invest the time to learn how to fix problems and deal with boring but necessary operations like upgrade. If not, it's probably better to use a managed service. We operate a SaaS for ClickHouse but use managed MySQL and Kubernetes. That choice freed up resources to focus on making ClickHouse run well.
Disclaimer: I work for Altinity.