I need to migrate a website with a catalog of approximately 100,000 items. It's a custom-built PHP + MySQL application with many filters and a product search feature. Traffic is moderate for now, but the database is constantly growing.
For the server, I'm looking at 8 CPU cores / 16 GB RAM / 200 GB NVMe, plus daily backups. I'm checking out hostpro.com, but I'm not sure if I need that configuration right from the start.
What would you choose for a project like this, and which resource is most likely to become a bottleneck?