aws-ia / cfn-ps-microsoft-sql-fci-fsx Goto Github PK

Hi -

is there any plan on adding option to support Fsxn implementation?

Summary:

When deploying this solution against an existing managed Active Directory there are several DNS records created in Active Directory to point to the newly created instances. There is are 2 records created for the FCI with identical names which point to the 3rd IP/ENI of each EC2 instance. One of these records points to the node which has the MSSQLSERVER role active, and the other record points to the standby instance. This causes DNS queries to the FCI to fail 50% of the time since the second instance is not running the MSSQLSERVER role in the Failover Cluster.

Details:
The final step of the SSM automation document created by the cloudformation template is called CompleteFCI. This step takes a parameter from the automation document called SqlFSxFCIName which gets passed as -FCIName {{SqlFSxFCIName}}. When the cluster is created against an existing managed AD it creates the following records:

• 2 records: 1 record pointing to the primary private IP of each EC2 instance
• 1 record pointing to the WFC
• 2 records named from {{SqlFSxFCIName}} with identical names, pointing to the 3rd IP of each of the 2 EC2 instances 3rd IP/ENI. The name of this record is the name to connect to the DB in SQL Server Management Studio, as well as the DNS name to connect to SQL Server

In the Windows Failover Cluster Manager, the first instance is assigned the MSSQLSERVER role, while the second instance is not(active/passive). Because of this DNS queries to {{SqlFSxFCIName}} will hit the standby instance 50% of the time.

Section heading:
Documentation issue description:

The footer in the article doesn't display the current year:

"Privacy | Site terms | © {current-year}, Amazon Web Services, Inc. or its affiliates. All rights reserved."

In the following block, the file name should have .template.yaml extension.

https://github.com/aws-ia/cfn-ps-microsoft-sql-fci-fsx/blob/main/templates/mssqlfsx-main.template.yaml#L482-L486