Windows server and database clusters required some prerequisites that is the reason in my previous two articles I told you how to get redundant network and shared storage for the windows server and database fail-over cluster. A windows server cluster is required for the hardware redundancy and database cluster provide us database redundancy in case of the failure of one node second node will take over and perform the operations continuously. In windows server failover cluster two or more servers communicating with each other through a series of the heartbeat on the dedicated network. The active server sends the heartbeat signals to another standby server in the specified interval that is usually called a push heartbeat. If the standby server did not receive heartbeat from the active server, it takes over and becomes the active server and performs the operations of the active server. Windows failover cluster communication signals are also sent by standby servers as well if the active server did not respond to the signals in a specific interval of time then also standby server takes over and becomes active server this is called pulled heartbeat. The same is the case when we add the role of the database service using SQL Server or MySQL server in the windows server failover cluster. This role is worked as a database cluster for database fail-over. In this article, I will show you in video and also by screenshots on how to do it with MySQL and SQL Server.
Windows Server Two Node Fail-Over Cluster
Open windows server manager and click Add roles and features
Select role-based or feature-based installation
Select the Node on which you want to install role or feature
From the features select failover clustering and click next
Click installation to finish the wizard
When role installation is complete open failover cluster manager and starts windows server failover cluster validation and the installation wizard.
Start validation through the wizard and verify the validation result
Select tests or run all tests for the cluster nodes
Confirm the validation wizard to start validation click next
Click on a finish to complete validation wizard if you want to start the cluster creation wizard click the checkbox.
Click next to start the cluster configuration wizard
Provide the cluster object name and IP of the same subnet of the nodes
Confirm the cluster configuration installation wizard and check the add eligible storage checkbox and click next to start the Windows Server Failover Cluster wizard.
Open windows server failover cluster manager to check the cluster
SQL Server Two Node Failover Cluster Instance
To install SQL server failover cluster start the SQL server instance and click on the installation
To start the installation click on the new SQL Server failover cluster installation click next after providing license information.
Accept the license terms and condition for SQL server failover cluster
Click next after global role checking is finished
Select SQL server features type for failover cluster
Click the checkbox of the failover cluster features
Checking the selected roles passed the installation check
Write the cluster instance name for the DNS Object
Checking Disk space requirement for failover cluster installation
Select the disk on which you want to install SQL failover cluster it must be shared storage disk among all nodes of the cluster
Configure cluster network information
Cluster services user configuration of the FQDN(fully qualified domain name)
Configure user for database engine access provide the password for the same user as well
Click next to check if any error and report is appaired in the installation process
Click next to check installation rules for the cluster is passed or not
Click next to proceed the wizard for installation and click on install to start installation on node1
When the installation is complete go to windows server failover cluster manager under the roles tab you will find the database SQL failover cluster role
A database failover cluster is installed and online successfully on node1 now we have to add node2 in the database failover cluster. Go to node2 and start SQL server setup from installation tab chose to add the node to SQL Server failover cluster
It will check the setup support rules for the node2
Provide license details for node2 SQL server failover cluster
Accept license terms and conditions for the node2
Rules setup support check for node2 passed with some warning
Cluster node2 addition in the created database cluster
Network Configuration for node2 no need to provide IP just select the IP you provide in node1 installation
Provide account details for node2 cluster authentication
Check status for the node2 addition is passed
Click install to start the installation wizard to complete node2 addition
Installation is completed for the node2 addition is completed now open windows server failover cluster manager click on the roles you will find node2 also under the SQL Server failover cluster
You may be intrested to read more useful articles.