Sample Header Ad - 728x90

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