By the RentServers team at Wells Software Consulting LLC · Updated
Recommended setup
| OLTP (Postgres, MySQL) | High-memory dedicated server with NVMe in RAID 1/10 |
|---|---|
| Analytics (ClickHouse) | Many cores, large NVMe, high memory bandwidth |
| Cache (Redis, Valkey) | High-memory server; CPU less important |
| Resilience | Replica in a second facility |
Size RAM to your working set, not your total data size, and put write-ahead logs on the fastest NVMe available.
Always run a replica. A single dedicated server is a single point of failure, however reliable the hardware.