kvm vs openvz for 24GB-ram mysql server

[rxrxrx]

Hi;

ive been testing proxmox 1.9 for a while, and decided to use it, with a cluster.
first of all i need to mention that; i am not going to use it for vps hosting etc. just for our company services and websites.
(running 50 containers in a server etc. is not the case for me.)

so here is my first task, ill need a mysql server.
i am comfortable with centos, so i will pick centos6.1,64 bit,as guest OS.
i am going to allocate 16-24 or 32GB ram, for that mysql server, lets say 24GB.

The problem is, i cant decide which method to use, KVM or openvz for that machine.

ive read some comparisions, mostly focused on openvz using less resources, thus being able to run more vps containers on a pyhsical host.

Since a little overhead for memory will not hurt, that does not seem like an advantage for me at all.

Any tip/advice 'ld be appraciated.

 

[udo]

Hi,
for a database is io-speed very important. You get (much more) better performance with an openvz-vm! Ok - you have also less flexibility (kvm has easier livemigration with shared-storage).
The performance depends on you IO subsystem, but with fast disks/raidcontroller the bottleneck is the io in kvm.

Udo

 

[rxrxrx]

Hi,
for a database is io-speed very important. You get (much more) better performance with an openvz-vm! Ok - you have also less flexibility (kvm has easier livemigration with shared-storage).
The performance depends on you IO subsystem, but with fast disks/raidcontroller the bottleneck is the io in kvm.

Udo

does it matter, running a different OS as a container, than host ? ie centos on debian kernel ?

about the I/O, that DB will probably wont have huge data for a long time,(RAM upgrade is always an option as the data grows by the way) so i guess with a good mysql tuning, queries will be mostly answered from RAM.

 

[tom]

centos as a container is running great on proxmox ve. i also recommend openvz in this case.