sql-serveramazon-rdsmulti-master-replication

Can we create a SQL Server RDS in AWS Active/Active?


I have question about AWS RDS. what we have to do to create a SQL Server RDS Active/Active or Multi-Master Cluster on AWS? Is there any easy way in AWS RDS? Thanks.


Solution

  • assuming your requirement absolutely must have the ability to commit transactions to multiple database server instances, what you need is Always On Availability Groups (AGs). To set this up in Amazon RDS SQL Server, here's the relevant bit of the documentation. That should be enough to get you started!