I have a server with multiple different sites hosted on it. Additionally it has mysql-server that housing information for every site. Over the weekend I had slow queries for one of the databases on mysql-server. Naturally it was locking up apache.
I am just wondering, with hardware so cheap, and an abundance of virtualization products out, are the days of having multiple sites on the same server outdated? I can think of only one benefit of hosting multiple sites on the same server, and that is just easiness (not having to start/configure a new instance). I can think of many negatives though. Comprimizing one site gives a user access to many other sites. Also something like the slow query problem locking up apache for EVERY site would no longer happen.
So it clearly seems that hosting many sites on 1 instance is bad practice? Am I right to assert this?