Navigation

    XCP-ng

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    configure shared storage for VM for SQL Server Cluster

    Xen Orchestra
    5
    9
    189
    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
      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
      • olivierlambert
        olivierlambert XCP-ng Team last edited by

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

        M 1 Reply Last reply Reply Quote 0
        • M
          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
          • olivierlambert
            olivierlambert XCP-ng Team 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
              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
              • olivierlambert
                olivierlambert XCP-ng Team 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.

                1 Reply Last reply Reply Quote 0
                • R
                  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
                    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
                      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
                      • First post
                        Last post
                      XCP-ng Pro Support

                      XCP-ng Pro Support