Linkedin

  • Home >
  • Configure read-only routing in an Always On availability group in SQL Server on AWS

Configure read-only routing in an Always On availability group in SQL Server on AWS

Project Overview

Project Detail

Database mirroring has one-to-one mapping. You can’t read the secondary database directly, so you must create snapshots. The Always On availability group feature was introduced in Microsoft SQL Server 2012. In later versions, major functionalities have been introduced, including read-only routing. In Always On availability groups, you can read the data directly from the secondary replica by changing the replica mode to read-only.

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/configure-read-only-routing-in-an-always-on-availability-group-in-sql-server-on-aws.html?did=pg_card&trk=pg_card

To know more about this project connect with us

Configure read-only routing in an Always On availability group in SQL Server on AWS