none
Azure SQL Always on accoss different region RRS feed

  • Question

  • Suppose I am going to built a 3 nodes SQL Always-on in azure .

    2 in region East Asia, and another one in South East asia.

    I am just confused how to connect them together in the same cluster ?

    should I use vnet peering to connect them together ?

    as I know is it not possible to have a vnet across 2 regions.

    Any one have build like this before ?

    Sunday, August 18, 2019 8:19 AM

All replies

  • Hi Sakurai_db,

    Are you planning to use SQL Managed Instances (has native implementation with Vnet and supports PaaS features)?

    SQL MI doesn't support peering over different regions, pleas refer this document.

    A similar MSDN question is here.

    Please let me know if you are planning to setup those clusters in a different way(without using SQL MI)

    Thanks.

           

    Friday, August 23, 2019 5:02 AM
    Moderator
  • no... I am going to use Azure VM ….
    Saturday, August 24, 2019 5:21 PM
  • anyone has done it before ?
    Tuesday, August 27, 2019 3:17 PM
  • Hi,

    I reached out to the product teams to get more info on this.

    I will update here once i have the information

    Wednesday, August 28, 2019 11:39 AM
    Moderator
  • thanks. look forward to get your feedback .

    Thursday, August 29, 2019 2:01 AM
  • Hi Sakurai_db,

    As mentioned in the initial response, SQL MI is PaaS offering and as per document provided it has the limitation for cross regions.
    As you are trying SQL cluster on regular VM, with VNET peering you can achieve this.

    If any of the provided suggestion helped your query, do click “Mark as Answer” and "Up-Vote" on the post that helped you, so that other forum members can benefit from it.

    Thanks.
    Thursday, August 29, 2019 8:12 AM
    Moderator
  • any detail steps for this ?
    Tuesday, September 10, 2019 3:05 AM
  • and it should under the same azure subscription ?
    Tuesday, September 10, 2019 3:06 AM
  • Hi Sakurai_db,

    Yes, the VNET peering can span across different subscription and different regions.

    Please check below documents that can help setting up VNET Peering and SQL always on Cluster.


    Please check these documents that guides you on this setup. 

    Thanks.

    Tuesday, September 10, 2019 11:49 AM
    Moderator
  • Hi Sakurai_db,

    Any update on the issue?

    Just checking in if you got a chance to see my previous response.

    If the provided suggestion help solve your query, do click on "Mark as Answer" & "Up-Vote" on the answer on the post that helped you, so that other forum members can benefit from it.

    Thanks.

    Monday, September 23, 2019 7:58 AM
    Moderator
  • Yes, you need to peer the vNets hosted on your primary and secondary regions. All 3 VMs should be part of the same Windows Cluster. I suggest, you go for at least Windows 2016 OS, so that you can use Cloud Witness. You would be looking for the following architecture. (You can put your VMs on the primary region in 'Availability Set' or in two different 'Availability Zones' depending your requirement. Please note that if you go for Availability Zones, you need to use Standard LB for listener) Please let me know if you have any further query.

    • Proposed as answer by Rohan Islam Monday, September 23, 2019 8:55 AM
    Monday, September 23, 2019 8:19 AM