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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login