- Use RDS for SQL Server and create the same instance in two different regions. Use Database Migration Service to keep each database in sync.
- Use a VPN or VPC peering to establish a connection between the VPCs in each region. Install SQL Server Enterprise Edition on EC2 instances in each region and configure an Always On availability group.
- Use RDS for SQL Server 2016 or 2017 Enterprise Edition. Enable Multi-AZ support and select the Mirroring/Always On option. Select another region for the mirroring option.
- You can not set up an active-active architecture for SQL Server that spans geographic regions.
How do you architect a solution for an SQL Server database to be replicated across AWS regions in an active-active architecture?
ByNeha S
Feb 10, 2022