Have tried the 4vcore&8gRam vultr vps (Yes, I'm kind of stingy and whimsical), and obviously i I failed.
So there are other buddy have this experience?
Thanks
Try nginx will help you more or try load balancer for manage servers
400k a day is not a lot of traffic.
* Use Nginx and fine tune it.
* Use MariaDB instead of MySql. Fine tuning it is an art of it's own. It has to be done with live traffic to find the best parameters for my.cnf
* Use PHP caching ( PHP APC )
* Use Redis / Memcached if your tracker makes use of it
* Run optimize tables frequently on your DB.
* Backup / Dump / Clean your DB once it reaches over 20GBs of size
There are other smaller things but these should make 80% of the difference.
P.S Yep the 8GB ram might be able to handle it with the above changes.