sql cluster

I'm curious about a topic. I want to run SQL cluster / always on on vxrail. not sure but it needs a Quorum disk / shared disk for SQL cluster / always on. and rdm disk should be in physical mode. Can I build this structure on vxrail.

I know there is an obligation to be a sharing disk in physical mode for the sql always on structure. if i am not mistaken.

Responses(1)

T

TN_bosco

18 Posts

0

April 11th, 2020 07:00

For SQL Always On Availability Group, you don't necessarily require a shared disk. Other SQL HA styles do require it. However, if you want to present a shared disk, it's much easier if you are on vSAN U3 included in VxRail 4.7.300 or higher. It supports shared VMDKs in physical mode supported by WFCS. On earlier versions of vSAN, you have to present it as iSCSI. Be sure and put the shared disks on a separate SCSI controller in the guest with sharing enabled on the controller. Don't marked the disks as multi-writer, that's for non-Windows OS.

If you have an existing cluster with a RDM from your SAN, vSAN 6.7 U3 actually converts it to a VMDK when you migrate.

Official support matrix - https://kb.vmware.com/s/article/2147661

migration if built on VSAN - https://storagehub.vmware.com/t/sql-server-failover-cluster-instance-on-vmware-vsan-tm-native/migration-from-san-to-vsan-for-sql-server-cluster-on-wsfc/

good tips on config, included the multi-writer bit - https://blogs.vmware.com/apps/2019/05/wsfc-on-vsphere.html

Jason

View All

No Events found!