In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server.
Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create Pacemaker cluster resources
Let’s go over these steps one by one. For the demo, I create a three-node cluster using Pacemaker. Below are the node and virtual IP details for your reference.
UBSQL01 – 172.31.6.224 UBSQL02 – 172.31.14.121 UBSQL03 – 172.31.3.50 Virtual IP – 172.31.6.225