In this article, we will use the latter because it is a fully managed shared file storage service and provides less management overhead compared to the former, where you would have to make sure that the server is always available, updated, and maintained properly.Įnsure that the security group attached to the FSx share allows incoming traffic from the EC2 instances (on which the AG will be set up) via port 445.
#AMAZON EC2 SUPPORT SQL SERVER VERSIONS WINDOWS#
Create an SMB share using Amazon FSx for Windows File Server.Create an SMB share on a server reachable by the EC2 instance on which the Always On availability group will operate.There are a couple of ways to create a file share witness in AWS:
It is not mandatory to use it, but it is the best practice. For each EC2 instance NIC, change the DNS settings to append primary and connection-specific DNS suffixes.Ī file share witness is simply an SMB share that acts as a tiebreaker where the failover cluster can be used to vote in the cluster quorum.For each EC2 instance elastic interface, ensure one secondary IP has been added that will be used for the cluster and extra IPs equal to the number of listeners you are planning to provision.Ensure that the EC2 instances are domain-joined.Ensure that the security groups assigned to the EC2 instances allow traffic between each other and any third party that the instances might need to communicate with (e.g., file share witness) via the right ports.The SQL Server version should be 2014 or later.The EC2 instance guest OS should be Windows Server 2012 R2 or later.Deploy the EC2 instances to two different subnets in the same VPC but in different availability zones.
0 kommentar(er)
