To complete the following end-to-end scenario, you need three SQL Server nodes to be deployed with the Pacemaker in a multi-AZ cluster in AWS and APEX Block Storage. The following steps describe how these servers are configured:
- Set up and configure the Ubuntu instance.
- Install PowerFlex SDC components in all Ubuntu compute Instances.
- Configure the host’s file (/etc/hosts) or DNS.
- Install and configure SQL Server.
- Volumes need to be created and mapped to both source and target SDC hosts.
- Used logical volume management (LVM) for simplicity of use and flexibility in hiding backend volume changes.
- SQL Server database should be using the APEX Block Storage volumes.
- Install and configure the Pacemaker on each cluster node.
- Install and configure the SQL HA package.
- Create Pacemaker resources.