The following PowerShell scripts will help you setup a SQL Server Availability Group using Alias IP Ranges in GCP. Alias IP lets you assign additional IPs to a instance. To create an Availability Group we need two extra IPs per node (one for the Windows Failover Cluster and another for the Listener).

Below is a description of every script

• parameters-config.ps1 - Specify the parameters that are used by the other scripts.
• create-sql-instance-availability-group.ps1 - Usually this is the only script that needs to be run. It does the following steps:
  1. Creates two SQL Server instances
  2. Adds the two instances to a Windows AD domain
  3. Creates a Windows Server Failover Cluster (WSFC)
  4. Creates a SQL Server Availability Group
• create-availability-group.ps1 - Create the Availability Group. It is called by create-sql-instance-availability-group.ps1.
• create-sql-instance-availability-group-prerequisites.ps1 - (Optional) Set up the pre-requisites needed to create an Availability Group:
  1. Creates a Custom Network in GCP
  2. Creates firewall rules for WinRM and RDP
  3. Creates a Windows AD domain with one domain controller
• create-sql-instance-availability-group-cleanup.ps1 - (Optional) Delete the SQL Server instances, the domain controller and the custom network. WARNING: Use with caution. Used in cases where you are just testing the scripts.
• create-sql-instance-availability-group.Tests.ps1 - (Optional) Use Pester to unit test the scripts.
• validate-availability-group.ps1 - (Optional) Validate that the Availability Group is working.