Speed Mysql With XEN?
Posted by: Alberto Moreno
Date: July 09, 2010 12:53AM

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!!!

Options: ReplyQuote


Subject
Written By
Posted
Speed Mysql With XEN?
July 09, 2010 12:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.