I continued to explorer my skills and knowledge on MS SQL Server 2016 on AlwaysOn.
I have been tested and setup three (3) nodes clustering that running on VMWare environment on MS Window Server 2012 R2:
- Node 1 – CRMSQLQ1N2 has installed, setup and configure MS SQL Server 2016.
- Node 2 – CRMSQLQ1N3 has installed, setup and configure MS SQL Server 2016
- Node 3 – CRMSQLQ1N4 has installed, setup and configure MS SQL Server 2016
On this example, on node 1 CRMSQLQ1N2 I will create several user databases.Then, turned on the SQL Server AlwaysOn features.
After completed setup, and configure SQL 2016 AlwaysOn. The CRMSQLQ1N2 node1 should replicate those user databases into Node 2 and 3.