How to create a test AlwaysOn Availability Group?

0

Very simply, I just need to locate instructions for creating a SQL Server AlwaysOn Availability Group in AWS. It is purely for testing purposes. I've been told by many people that it can be done, but I cannot locate any reference for doing so.

I am supporting a simple SQL Server v2019 synchronous commit, automatic failover 2-node AG (Availability Group), and I need to test some changes to it, but I do not want to test on that AG. I want to create a test AG in my AWS account. Can this be done?

RLLG
asked 4 months ago1255 views
2 Answers
0
Accepted Answer

You can deploy fully functional 2 node AlwaysOn Availability Group for SQL Server in AWS using the automated Launch Wizard. The wizard simplifies deployment while allowing customisation of key parameters.

Steps:

  1. Login to AWS Console and open the AWS Launch Wizard from the search bar
  2. Select Choose Application and Select SQL Server
  3. Configure the following:
  • VPC and Subnet settings where the EC2 instances will be launched. Ideally select a VPC with at least 2 subnets in different Availability Zones.
  • EC2 instance type and size for the 2 nodes. Select instances with enough CPU, memory and storage for SQL Server.
  • SQL Server version, edition and license type.
  • Windows Server AMI and admin credentials.
  • Availability Group name, listener name and port.
  • Database name and recovery model.
  • Review the template configuration and launch the stack. This will deploy 2 EC2 instances with SQL Server installed, joined to a domain, clustered and with an Availability Group created.
  1. Once deployed, connect to the primary replica and validate the Availability Group is configured properly. 5. Check the replication and failover between the nodes.
  2. Test failover between nodes and ensure high availability for the SQL Server instance.

More details:

AWS Launch Wizard

Deploy SQL Server using AWS Launch Wizard

profile pictureAWS
answered 4 months ago
profile picture
EXPERT
reviewed a month ago
  • Very helpful. Thank you!

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions