Unsolved
This post is more than 5 years old
5 Posts
0
1014
sql 2012 AO with Vplex Metro
Hi All ,
Just implemented in my environment a VPLEX METRO with XIO
When planning to move my SQL ha 2012 cluster i encountered some questions on how to do it properly.
When thinking of cluster under VPLEX with Vsphere 6 above it seems natural to drop the cluster issue and move to one server.
If i use cluster 2012 with sql 2012 "always one" with 2 nodes im gone "write/replicate" my self to death (;
The synchronous log shipping will replicate the db1 to db2 by log shipping "always on" and the VPLEX gone replicate them both to site B synchronously .
What is the best practice to this issue?
Is it wize to keep "always on" with metro cluster with vsphere 6?
Regards ,
Elad
ankur.patel
286 Posts
0
January 13th, 2016 07:00
It depends![](https://prod-care-community-cdn.sprinklr.com/community/687062f5-603c-4f5f-ab9d-31aa7cacb376/Resql2012AOwithVplexMetro-6dbd70dc-87d5-49bf-aea7-511be3feb191-909435394)
This is personal preference as your choice on technologies depends on what you are trying to achieve.
Just relying on VMware HA wont save you from a sql server issue. Always on will
VPLEX metro will allow for vmotion of the vm if you plan on doing mobility throughout the year. Always on will not
Another thought Ive seen customers bring up is using vplex metro for HA and use always on to a 3rd site to a further datacenter.
elad_mako
5 Posts
0
January 14th, 2016 08:00
well the right thing to do is just take the LUNS outside the vplex.
excellently like i did in this issue.
there no need to sync both sql cluster and VPLEX metro together synchronously.
so just took luns from each side(storage) and attached it to the one of the always on cluster.
when there will be a split brain ni the Metro Cluster the always on will acting the same as a VPLEX .
Regards
Elad