Local VS Remote MySQL Installation
Could someone explain the advantages and disadvantages of installing a MySQL database on a local machine compared to a remote machine?
I have two VPS, one is KVM128 as a web server (will host 2-3 wordpress blogs using Lighttpd & PHP-FPM) and another is OVZ128 which is idle VPS I'm planning to install mysql server. Which scenario will give me best performance, local mysql on web server, or external mysql on OVZ128?
If I host both web and mysql server on the same machine with 128 RAM of course they are then competing for the same resources. But if I host on separate server I'm afraid there will be network latency, even just 10ms or more on local BVM subnet (for hostname lookup, etc) :D
Any help would be greatly appreciated! Thanks