Kids, don’t do this at home!
Actually it was not quite a simple task for me to move one of my semi-dedicated hosting to a VPS hosting in two weeks. But to reduce my web hosting cost, I had to go VPS and it also allow me to learn more. Plus I am working as a application system administrator, how can I fail in setting up my own server right?
The main hurdle was that my server keeps going down initially and that was very painful as I am restarting my server from my Nokia E72 or my iPad 2 or via my Laptop at different times. Everytime it goes down I had problem connecting to my server or it is way too slow. Lucky I manage to get some sypmtoms and the default Apache and MySQL setting is actually not suitable at all for server of this size.
Fine tuning the httpd.conf and my.cnf for more than twenty times and finally it has been stable. Although there are times it is using swap memory but I am reluctant to go any more lower. The normal memory usage is only around 225 MB which I think is great.