•  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.

By Neha S

Leave a Reply

Your email address will not be published.