VPS Configuration Advice for Medium-Traffic OpenCart Store

Good day professionals,
I am planning to migrate my OpenCart store from shared hosting to a VPS environment due to performance limitations. Could anyone suggest an appropriate CPU, RAM, and storage configuration suitable for a medium-traffic online shop? I am considering AMD-based servers for improved performance efficiency and would like advice on the best setup for stability and scalability. Proper database optimization and server-side caching are also important factors for me. Is Netshop-isp.com.cy vps hosting good? Any experiences to share here? thanks.

I would greatly value your professional input.