Speed Mysql With XEN?

[Alberto Moreno]

Hi.

I wondering, soon I will need to setup MySQL 5.1.x for a ERP project we have. We are going to buy a new server to build virtual machines with Xen on Centos 5.5 and run MySQL on.

I have been running MySQL for a while but not one with the characteristics of a ERP.

I was reading some docs about mysql and exist a topic that took my attention.

Replica.

It say that we can have a Master + N Slaves and we can use the Master for writing to the DB(Insert, Update, Delete, etc) and use the Slave for Select querys, is say that this will make my DB faster.

If this is correct, I was wondering, is a good practice to make this with VM on the same Host?

vm1 ---> Master
vm2 ---> Slave

Or is better to be on different physical machines?

What other topic do u recommend me to read and have Ideas about how to speed up my DB, we have been working hard in normalization, now is time to see the server side.

Thanks!!!