XCP-ng
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    configure shared storage for VM for SQL Server Cluster

    Scheduled Pinned Locked Moved Xen Orchestra
    10 Posts 6 Posters 2.3k Views 2 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M Offline
      mjaber
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • olivierlambertO Offline
        olivierlambert Vates 🪐 Co-Founder CEO
        last edited by

        You can use a 3rd party VM for your share I suppose

        M 1 Reply Last reply Reply Quote 0
        • M Offline
          mjaber @olivierlambert
          last edited by

          @olivierlambert

          thanks for the reply .

          there is now way to configure the Storage as RAW ?

          1 Reply Last reply Reply Quote 0
          • olivierlambertO Offline
            olivierlambert Vates 🪐 Co-Founder CEO
            last edited by

            You can't share a block device to multiple VMs without a "cluster" aware filesystem. Not related to raw or whatever.

            M 1 Reply Last reply Reply Quote 0
            • M Offline
              mjaber @olivierlambert
              last edited by

              @olivierlambert

              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 ?

              1 Reply Last reply Reply Quote 0
              • olivierlambertO Offline
                olivierlambert Vates 🪐 Co-Founder CEO
                last edited by

                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.

                F 1 Reply Last reply Reply Quote 0
                • R Offline
                  r1 XCP-ng Team
                  last edited by

                  @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.

                  1 Reply Last reply Reply Quote 0
                  • A Offline
                    ahozdemir
                    last edited by

                    @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 :
                    fbe9dbb0-e444-49de-a4e9-790a254267a7-image.png

                    or any alternate without iscsi directly attached to the vm.

                    regards

                    1 Reply Last reply Reply Quote 0
                    • R Offline
                      Rocky
                      last edited by

                      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.

                      1 Reply Last reply Reply Quote 0
                      • F Offline
                        ferrao @olivierlambert
                        last edited by

                        @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.

                        1 Reply Last reply Reply Quote 0
                        • First post
                          Last post