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
-
-
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.
-
@olivierlambert said in configure shared storage for VM for SQL Server Cluster:
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.
regards
-
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.
-
@olivierlambert is there a way to mount the same disk in two VMs in RW mode? I have a lab that uses pacemaker inside the VM's and pacemaker handles the mounting/access of the volumes.
I have a working setup on oVirt using the "Shareable" option of a Virtual Disk. So I can attach to multiple VM's simultaneously. Is there anything similar on XCP-ng? Even if I have to hack through the command like to attach?
Thank you.