High Availability Solution for VM on local Storage

vmware-esxvmware-vsphere

Hi I have the following setup for using vSphere with HA:

enter image description here

My problem with this is the finding some kind of reasonable HA for the database server. The IOP requirements of the database server are very high, as such the database files are spread across three local SSD raid 10 arrays. The storage network is 10gbE and while it wouldn't meet the performance requirements long term I would like to have a way to have an automatic fail over to shared storage in the event that the Host fails.

Does anyone have any suggestions on how I could do this ? Perhaps pick up to the last image backup on shared storage ?

Thanks

*on vmware essentials plus.

Best Answer

The vSphere Storage Appliance can "share" local storage between different vmware hosts, but I don't think its included in essentials plus. There is vSphere Replication, which is a vmware appliance that could replicate the database VM and its local storage to another host's local storage. Its also included in essentials plus. However, its not going to be automated like vSphere HA (at least I don't think so) and you're not going to get better than a 15min RPO. If that's acceptable, its probably the best choice.

The better solution would be to re-examine the database's IO requirements and look into a SAN that can support its and the rest of your cluster's needs. Most SAN manufacturers offer SSD options. Or, if that's not a possiblity, then maybe moving the DB to dedicated hardware and leveraging the application's HA offerings (Oracle RAC/dataguard, mysql master-master, etc) to meet your needs.