I have a kvm host which started life as a web server.
A vm was created in order to move the web sites off the host. The plan was to keep the mysql server running on the host itself, allowing the web sites to connect to the host.
However, an interesting question has come up.
The host has much more memory than the vm's will have which is shared. In terms of performance, what is the best practice for doing this? Should the mysql server and databases be moved onto the new vm or would it make more sense to keep it on the host?
The web sites, some 20 of them, are all low use. In some ways, it seems to make more sense to just keep them on the host, that the host might perform better than moving them to one of the vms being hosted by it.