Ive recently taken the plunge and started renting a VPS for my web projects. As the demands on the system get higher so do the costs. MY VPS is US based due to costs, but Im based in Germany.
Initially I decided I'd try and run everything on a Windows 2008 VPS: .net, SQLServer. Then I added php and MySQL, and the server is now reaching 80% memory usage(2GB).
The costs of upgrading would appear to be higher than getting some 3rd party hosting for the MySQL and sheds some of the strain from the VPS. This raises 2 questions:
1) Is it better to have the DB Server located near the server, for improved transaction times? Or is it better to have the DB hosted nearer to Europe for delivery to the end user?
2) The DB server is likely to be some mass hosting solution inorder to keep costs to a minimum. Would this likely be an improvement or degradation compared to running on a Win Server with 80% memory use?
Obviously I have my own somewhat unsubstantiated ideas, but would love to get some insight from those with more practical knowledge than myself.
P.s. Ive currently no seriously intensive applications/sites running on the server at this time.