When to use MySQL replication or DRBD for HA on Xen VM?
- by user62513
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.