The database grew, but expanding the old server became expensive
Disk space was running out, requests were slowing down, and an NVMe drive of the required size cost almost half of the existing server. It was necessary to compare local upgrades with cloud migration.
First economy, then equipment
Buying a disk did not solve CPU, RAM, RAID limitations, or further database growth issues, so we considered the entire system.
Load profile
Measured the size of the database, data growth, IOPS, query times, and requirements for the migration window.
Comparison of options
NVMe, a new server, VPS, and cloud database were compared in terms of cost and risk.
Test migration
Backup was created, recovery was tested, and migration was run in a separate environment.
Description is anonymized: technical details and customer data are not disclosed.
Result
- The solution was chosen based on full cost, not just the price of storage.
- Compatibility and performance of the database were verified before switching.
- Rollback scenario is prepared in advance.
- The infrastructure has received a reserve for further data growth.
Is the database growing faster than the server?
Will assess load and compare NVMe, new server, VPS and cloud platform.