SQL Server Failover Cluster Installation -1

Mehmet Salih Deveci March 15, 2019 2 Comments

Hi ,

In this article, I will briefly introduce and explain the Failover Cluster technology in SQL Server. Failover Cluster technology of SQL Server is also an important technology providing high availability. So it is widely used in enterprise applications to give maximum service in productions systems.

windows failover clustering

Failover Cluster technology is the perfect technology to maintain the high availability service of the applications in the institutions that aim to provide the maximum level of service (Telecommunication, Banking, Government Offices, Holdings).

This technology can be defined as the ability of a single Database to be able to serve on more than one server. Thus, it provides High Availability, Maximum Service, which is one of the indispensable rules in the database world.

I would also like to mention that many people may see the Failover Cluster technology as a solution for Disaster Recovery, but it is not. Failover Cluster technology is not Disaster Recovery solution, it is a technology that provides only High Availability.

 

 

We can list the solutions offered by the SQL Server database for High Availability as follows.

  1. Failover Clustering
  2. Database Mirroring
  3. Data Replication
  4. Database Snapshot

In the Failover Cluster architecture, one of the 2 or more servers connected to each other through Windows Cluster is active and the other is passive. If the active server is unable to provide service in any case, the Failover status occurs and the Passive Node is enabled by Windows Cluster.

In order to install SQL Server Failover Cluster, both servers must be on Windows Cluster. On the SQL Server side, the service that provides the Failover Cluster architecture is Microsoft Cluster Service (MSCS). Both servers have different disks, but there is a shared disk in which the Database and Cluster related files are kept. This disk is known as Quorum Disk. We can symbolize the Quorum Disk, which symbolizes the common disk space and is common to both nodes, as shown in the image below.

High_Availability_1

 

When application is accessing the database, the application continuously accesses the database with the Cluster IP entered without knowing which of the active passive nodes is. Cluster IP requests the currently active node which is the node that is sent to the node. When the active Node is down, the application is connected to the Passive Node in 1 second depending on the system and it is not affected. In this case, the passive node is active and admin can already do failover manually at any time.

 

 

Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.

https://ittutorial.org/sql-server-tutorials-microsoft-database-for-beginners/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

2 comments

  1. Brian Bourn
    May 21, 2019 at 6:38 am

    We’re a group of volunteers and opening a new scheme in our community. Your website offered us with valuable information to work on. You have done an impressive job and our entire community will be grateful to you.|

    Reply
  2. Numbers Efurd
    May 21, 2019 at 6:38 am

    Hey I am so thrilled I found your webpage, I really found you by accident, while I was browsing on Yahoo for something else, Anyways I am here now and would just like to say kudos for a incredible post and a all round exciting blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the superb work.|

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Powered by IT Tutorial | Designed by SysDBASoft IT
IT Tutorial © Copyright 2024, All Rights Reserved