When to use MySQL replication or DRBD for HA on Xen VM?

Posted by user62513 on Server Fault See other posts from Server Fault or by user62513
Published on 2011-01-06T22:44:41Z Indexed on 2011/01/06 22:55 UTC
Read the original article Hit count: 185

I'm setting up a database which needs to be needs to provide High Availabilty.

My primary concern is high performance and robustness (I don't want something that will fail fast and badly). The database is accessed by the application at an average of 300 qps. It's will run on Xen VMs and it has some InnoDB tables as well as MyISAM tables. The VMs are connected via ethernet 100Mbit/s ethernet cables.

Which of the two - MySQL replication or DRBD - would you recommend in such a situation?

Or should I use DRBD to make the master database Highly Available and use MySQL replication on the slaves?

I'm a developer so these things are all not so easy for me to make a sound judgement.

© Server Fault or respective owner

Related posts about high-availability

Related posts about mysql-replication