Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Given a choice between the current database-level HA options for MySQL, like Master-Master, Cluster, or Galera, and vSphere HA for the machine running the MySQL master, which would you use or combine and why?

share|improve this question
    
Given that VMware HA will, at best, reboot the MySQL Master on another box, and then have to wait for InnoDB recovery, what other replication and HA techniques should be used on top of VMware? I'm looking for a set of solutions that "play nicely together" –  Terence Johnson Jan 25 '12 at 14:40
add comment

1 Answer

vSphere HA will not give you 100% uptime. If a host fails, all of the VMs that were running on that host will be restarted on another host, provided that there are enough resources (CPU & memory). If you want a higher uptime using vSphere, then you will want to look into Fault Tolerance. It essentially runs the VM on 2 hosts concurrently and therefore uses twice the CPU and memory as HA. However, if you are using Mysql master-master, cluster, etc. then you are probably using the same amount of resources as FT.

If you want to use Mysql master-master or cluster in a vSphere environment, then you can configure VMWare DRS rules to keep the guest VMs on separate hosts. This would be beneficial in case one of the hosts fails.

share|improve this answer
2  
another issue is that ft limits the amount and type of hardware that you can present to the guest. –  tony roth Jan 6 '12 at 16:15
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.