Multiple SQL Server instances each with one Availability Group on one Cluster of two nodes in a DAG configuration
0
votes
1
answer
330
views
I'd appreciate some advice please. I am about to get to work on implementing a SQL 2019 Distributed Availability Group configuration with following architecture:
- Two sites - one primary & one DR
- Each site has a WSFC configuration with two nodes.
- DAG configuration asynchronous between the two clusters.
- Each local AG is synchronous availability mode and holds the AG databases for one component of the application.
- The application in question has about 3 or 4 components, each with its own set of back-end
databases
- The databases for each application component are hosted in one SQL instance
- so the 3/4 SQL instances are all hosted on the pair of nodes on each cluster.
- each AG has it's own listener, hence one listener in each instance, all on the same local cluster.
- all the secondaries are non-readable
This is my first experience with multiple SQL instances on a cluster, each configured with AG and DAG between the two clusters.
Could you advise me please if there are any specific issues I need to pay particular attention to in such a configuration?
Thank you.
Asked by PTL_SQL
(427 rep)
Apr 5, 2024, 06:01 PM
Last activity: Apr 6, 2024, 08:24 PM
Last activity: Apr 6, 2024, 08:24 PM