question

JunaidAhmed83 avatar image
0 Votes"
JunaidAhmed83 asked JunaidAhmed83 commented

SQL Always On Active Active Cross premises

Hi fellows,

Can an on-premises SQL AlwaysOn Cluster (2 Node) be extended to Azure (2 additional nodes as Azure VMs) in an active-active model?
On-premises SQL cluster has three availability groups.

Objective is to convert applications to active-active model. where as application layer can easily be configured for active-active scenario. However the databases need to be automatically available on DR, in case if the primary site SQL goes down (planned or unplanned) there should not be any manual intervention required.

Guidelines from anyone who has implemented this before would be very helpful.

Regards.

sql-server-generalazure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DavidBrowne-msft avatar image
0 Votes"
DavidBrowne-msft answered JunaidAhmed83 commented

If by "active-active" you mean having running SQL Instances running secondary replicas of the database, then yes.

You'll need to carefully plan your cluster heartbeat settings, and your quorum model (see eg Cloud Quorum).

Because while it's technically possible to have automatic failover in this scenario, it's difficult. For most applications it's better to have a single async secondary in Azure and the primary and a synchronous secondary on-prem.

The difficulties are:

1) Only synchronous secondaries support automatic failover, and having a synchronous secondary in a remote datacenter can have a serious impact on performance.

And if you want automatic failover, you can't have a quorum voting majority in your datacenter; instead the quorum needs to be in the cloud, eg using Cloud Witness, which necessarily means:

2) In case of a temporary network issue between your Datacenter and Azure the nodes in your datacenter will go offline and the database will fail over.

And you'll need to carefully adjust the cluster timeout values which are always a tradeoff between failover time and false outages.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks DavidBrowne,

This answers my question precisely.

0 Votes 0 ·
MiaMiao-MSFT avatar image
0 Votes"
MiaMiao-MSFT answered

Hi @JunaidAhmed83,

Can an on-premises SQL AlwaysOn Cluster (2 Node) be extended to Azure (2 additional nodes as Azure VMs) in an active-active model?

Yes.
Guidelines as this : Rehost an on-premises application with Azure VMs and SQL Server Always On availability groups



BR,
Mia


If the answer is helpful, please click "Accept Answer" and upvote it.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MiaMiao-MSFT avatar image
0 Votes"
MiaMiao-MSFT answered JunaidAhmed83 commented

Hi @JunaidAhmed83,

Is the reply helpful?

BR,
Mia


If the answer is helpful, please click "Accept Answer" and upvote it.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the help MiaMiao. Although my scenario is a bit different. I do not need to migrate the application. I need to extend it to a secondary site.

0 Votes 0 ·