All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Local VS Remote MySQL Installation
Hi Guys,
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)
Any help would be greatly appreciated! Thanks
Comments
If the connection between both servers is excellent (i.e. same data center) then go remote for better performance. Unless you have an extremely busy website with constant MySQL access then whatever performance increase you'll gain will be negated but the possible network hiccups and 2 possible points of failure.
Agree
Well, if security is a big concern, remote isn't the best way to go if you don't have MySQL+ssl.
And yes, the problems are about latency mainly. I found Las Vegas to be my best location for a shared MySQL with servers around USA :P
Within the same datacenter (even different providers in the same DC), it's fine. I did it for a while with BuyVM. However, like @KuJoe said, you're introducing a second point of failure for your setup - you have to worry about both your web server and your MySQL VPSes going down. This might not be too much of a concern though if you're using WordPress, since I presume you'll be caching everything. So, the only problem you should have if your MySQL server goes down is you won't be able to receive comments or post new entries.
That's why you buy access to Shared SQL.
Francisco
It's still a second point of failure :P
Ya I guess I'm gonna make that mysql on a separate machine. I don't want to burden my tiny server because it seems like RAM & CPU bottleneck will just giving me more latency than network.
@Francisco
Is it normal if first ping packet always often more than 200~400ms?
I tried it on local ip.
that's what we've always seen on OpenVZ.
It's just an accounting error by ping as far as i know.
I've seen the same at home as well but maybe shaw is just being retarded?
Oh I thought that was caused by your firewall..