DevOps Articles

Configure SQL Server Standard Edition for High Availability on AWS

It’s not always clear how to build a high availability (HA) infrastructure for the Microsoft SQL Server Standard Edition on https://aws.amazon.com/?utm_content=inline-mention. Amazon RDS is a fully managed service; you only need to tell AWS that you want a multicenter instance of SQL Server.

This quickly becomes an important question when deciding whether to run SQL Server Standard Edition on Amazon RDS or Amazon EC2.

The downside of relying on the Basic AG functionality to ensure HA on Amazon RDS is that SQL Server Standard Edition permits the replication of only one SQL Server database between the active and secondary infrastructures.

You could replicate multiple SQL Server databases in a single AG if you were to configure your Amazon RDS infrastructure using the “Always On” AG functionality built into the SQL Server Enterprise Edition, but that would require you to move from SQL Server Standard Edition to the more expensive Enterprise Edition of SQL Server.