I've been hearing mixed opinions about using local storage, particularly with cnpg and general database setup. While it's known that local NVMe disks are faster than networked block storage volumes, I'm a bit concerned about how I'll handle disk upgrades later on. I'm weighing the choice between going for local storage on Hetzner's NVMe disks, and figuring out scaling as I grow, or playing it safe with Hetzner's cloud volumes which may come with performance trade-offs. I've read that there can be a significant performance drop with cloud volumes, but some say they still work fine for most workloads. How do others manage this? Is it really that much of an issue using networked volumes, and should I strongly stick to cnpg's advice of using local storage for better performance?
4 Answers
I've run some benchmarks with networked storage and had decent performance—up to 20k TPS under certain conditions. The key is finding the right setup; cloud volumes aren't always slow but historically haven't been optimized for heavy workloads. If you need to move compute power easily, network storage could be beneficial.
CNPG is tailored for PostgreSQL and leverages existing replication features well. If you’re looking for options beyond local storage, consider that network disks can simplify the scaling process. But make sure you weigh the drawbacks, like the max disk size limits; going dedicated might be necessary for long-term growth.
Honestly, unless it's just a hobby or small project, I wouldn't trust cloud volumes for databases. The performance hit is real—like, 5K IOPS when you really need more. And when it comes to scaling local storage, you're right; it generally means moving data to a larger local VM, which feels a bit wasteful. But with CNPG, adding a bigger disk as a replica could simplify things when scaling up.
It really boils down to how critical performance is for your databases. For small-scale applications, Hetzner cloud volumes work without any issues. But if you need top-tier performance, local storage is the way to go. You can get up to 60K IOPS on local storage compared to the max 7500 IOPS with cloud volumes, which can really impact performance under heavy loads.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically