Add a new node into existing SQL Server Always On Availability Groups

Add a new node into existing SQL Server Always On Availability Groups

This article gives an overview of adding a new node into existing SQL Server Always On Availability Groups. In the previous articles (see TOC at the bottom), we configured a two-node SQL Server Always On Availability Group.

Introduction

In the previous articles (see TOC at the bottom), we configured a two-node SQL Server Always On Availability Group. We performed the following steps at a high level.

  • Build three Virtual Servers with Windows Server 2016
  • SQLNode1 and SQLNode2 acts as failover cluster nodes
  • VDITest3 works as a domain controller and active directory
  • Configured Domain Controller for [MyDemoSQL] domain, Active Directory in Windows Server 2016
  • Join SQLNode1 and SQLNode2 into [MyDemoSQL] domain
  • Failover Cluster, Quorum and Storage configurations
  • SQL Server 2019 installation
  • Synchronous mode Always On configurations for SQLNode1 and SQLNode2

Suppose you get a requirement to add a new node in the existing cluster and always on configuration.

In this article, we will learn the steps to add a new node in the existing AG configuration.

  • Note:_ In this article, we will go over the required steps at a high-level. The previous article in this series already covers the things in detail._

Steps to add a new node into existing SQL Server Always On Availability Groups

Server build

Build a new virtual machine in the Oracle VirtualBox. Its configurations should be similar to existing cluster nodes SQLNode1 and SQLNode2. You can follow this article, A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016 for reference purposes.

Take an RDP session for the newly created VM and log in using the Administrator account.

Take RDP to the SQLNode

Assign static IP address

Open the network properties for Ipv4 and assign a static IP, DNS server IP as per your earlier configurations.

  • In our case, DNS server IP address is 10.0.2.15
  • I assign IP address 10.0.2.44 for the new VM.

You can refer to the article, Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups for static IP assignments.

Assign static IP address

Turn off the Windows firewall

You should turn off firewalls in your new virtual machine. If you use the firewall, you should open the ports for communication with the domain controller and failover cluster nodes.

Turn off the Windows firewall

alwayson availability groups installation setup and configuration sql

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Add or remove a node from SQL Server Always On Availability Groups using T-SQL scripts

This article gives an overview of SQL Server Always On Availability Group features. We configured the SQL Server Always On Availability Group from the beginning of building virtual machines.

Configure Managed Service Accounts for SQL Server Always On Availability Groups

This article gives an overview of Configuring Managed Service Accounts for SQL Server Always On Availability Groups.

Install SQL Server 2019 on Windows Server 2016 with SQL Server

In this article, we will discuss configuring SQL Server Always On Availability Groups and perform failover validations. You should go through the following articles and build the infrastructure before proceeding with this article.

An overview of distributed SQL Server Always On Availability Groups

SQL Server 2016 provides a new feature Distributed Availability Group for disaster recovery purposes. It is a particular type of availability group that helps access the multiple failover clusters. In this article’s series, we configured a traditional Always On group. It has the following requirements.