configure shared storage for VM for SQL Server Cluster
hello all ,
currently we have a requirement for SQL server virtual machine and this reacquired a share storage to be configured for the SQL Cluster , can you please let me know how to configure the shared storage for this two SQL Virtual machine ,
appreciate your help team
You can use a 3rd party VM for your share I suppose
thanks for the reply .
there is now way to configure the Storage as RAW ?
You can't share a block device to multiple VMs without a "cluster" aware filesystem. Not related to raw or whatever.
thanks for your update , but can i assign the same LUN for to VM and make it read only for the first VM and Read Write for second VM ?
That's possible. A bit weird but yeah, it will work if you only need to read data.
It also works in XCP-ng directly, you can mount the same VDI to another VM, but in RO.
@mjaber Did you try with an approach of having a VM and expose the raw disk over iSCSI and use it for your SQL cluster VMs?
It's possible that Dom0 can do it for you without need of an extra VM.
share I suppose
Oh I am also seeking another way to make SQL server failover cluster, I am also wondering is possible to passthure HBA card to windows for both Host's like :
or any alternate without iscsi directly attached to the vm.
Synology could be something to get you shared storage on a budget. Or there are other virtual SAN techs like Starwind... OR likely the best of the best will be XO SAN when that is ready for xcp-ng.
BUT if you just want SQL always on availability groups, that doesn't need shared storage. But I think it's best with a XCP-ng HA group so you'd want shared storage for that full solution.