VMware Cloud Community
VinVM09
Contributor
Contributor

SQL server mirroring with VMware HA

We would like to achieve High availability solution for SQL server in VMware and at the same time we are looking to use VMware HA. We thought of using Failover clustering for SQL server but then if we use failover clustering (MSCS) then clustered machines are not supported by VMware HA. The other option to achieve HA is SQL mirroring. It would be great if some one could tell us whether it is possible to implement SQL mirroring and at the same time making use of VMware HA.

Reply
0 Kudos
4 Replies
cody_bunch
Hot Shot
Hot Shot

Using Fail over SQL clustering or MSCS, only negates VMware HA for the two(or more) MSCS VMs. When you think about how MSCS acts in a fail over situation, you would essentially be duplicating efforts if you had VMware HA power on the failed node/VM on the remaining host. You can do mirroring, but still understand, that in a failover VMware HA will restart the other VM on a remaining host, thus duplicating what you've achieved with mirroring.

The best option, I figure, is to enable MSCS for the 2-4 SQL VMs, and use VMware HA for the rest (web heads and the like). Be sure to setup a DRS rule to keep the SQL nodes apart, just in case Smiley Happy

-Cody Bunch

vExpert, VCP VI3

-Cody Bunch http://professionalvmware.com
Reply
0 Kudos
Troy_Clavell
Immortal
Immortal

well said Cody!

Reply
0 Kudos
cody_bunch
Hot Shot
Hot Shot

Wrote this up in a bit more detail and posted to share to a wider audience: http://ping.fm/nngX5

-Cody Bunch

vExpert, VCP VI3

-Cody Bunch http://professionalvmware.com
Reply
0 Kudos
AlbertWT
Virtuoso
Virtuoso

Cody, the link that you posted is redirecting me into: http://www.webcopycat.com/?aff=tina so I'm not sure if it is accessible for now.

However I have similar question as the Original poster but this time I draw it instead of putting it in a word to make it easier to understand, see the following:

SQL-MirrorHA.jpg

Because yes as you said deploying MSCS on top of the VMware HA is too much hassle and complicated, that is why I have decided not to go ahead with it after reading this post.

Let me know how your thought about it.

Thanks.

/* Please feel free to provide any comments or input you may have. */
Reply
0 Kudos