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?

Why not give one of these VPS hosts a try?
1) RightServers.com
2) DigitalCloud.pro
3) Ovhcloud.com
Reliability has been consistent from day one.
Reliable, secure, and perfectly suited to e-commerce sites like mine.

Quality and reliable VPS providers for me are: justvps.pro and 4goodhosting.com.
They offer excellent customer service, and value for money. It is a relief to be working with them after unsatisfactory experiences with another company.

Check out Hostingsource.com packages. The host is easy to navigate, servers are highly responsive, and support is always ready to help.
Infrastructure reliability stands out clearly. Get vps hosting for your first month from just $3 — use coupon code: $3VPSM1ALL