Proxmox with heavy mysql database

[akihito]

I'm planning to migrate my services to proxmox and which type of virtualization should i use ? KVM or OpenVZ for a heavy mysql database server?
replication will be setup for mysql on another proxmox node with the same container allocation.


Proxmox Nodes
1) quad core E3-1230 v2, 16GB Ram, 4x500GB Sata Raid 10
2) quad core E3-1230 v2, 16GB Ram, 4x500GB Sata Raid 10

mysql server container allocation
4 cores, 8GB ram, 500GB disk

 

[tom]

test both, do optimizations and benchmark and give feedback here.

 

[gkovacs]

We did benchmark MySQL running in KVM and OpenVZ a while ago (on Proxmox 1.x). I don't have the numbers anymore, but under OpenVZ it was significantly faster, especially with a write-heavy workload. We assumed the single-threaded disk IO in KVM was the culprit.

I'm interested as well in some benchmarks on the current PVE, kernel and KVM. Akihito, please keep us posted if you can!