How to create two node failover cluster in Linux?
A SQL Server two-node shared disk failover cluster instance provides server-level redundancy for high availability. In this tutorial, you learn how to create a two-node failover cluster instance of SQL Server on Linux.
Do you need two machines for SQL server failover cluster?
For conceptual information, see SQL Server Failover Cluster Instance (FCI) on Linux. To complete the following end-to-end scenario, you need two machines to deploy the two nodes cluster and another server for storage. Below steps outline how these servers will be configured. The first step is to configure the operating system on the cluster nodes.
How to configure high availability cluster in RHEL?
To configure high availability for RHEL, enable the high availability subscription and then configure Pacemaker. Each node in the cluster must have an appropriate subscription for RHEL and the High Availability Add on. Review the requirements at How to install High Availability cluster packages in Red Hat Enterprise Linux.
What does cluster-recheck-interval mean in RHEL?
cluster-recheck-interval indicates the polling interval at which the cluster checks for changes in the resource parameters, constraints or other cluster options. If a replica goes down, the cluster tries to restart the replica at an interval that is bound by the failure-timeout value and the cluster-recheck-interval value.
What happens when SQL server fails on Linux?
One of the servers has the active connection to the storage resources and the SQL Server. When Pacemaker detects a failure the clustering components manage moving the resources to the other node. At this point, SQL Server’s integration with Pacemaker on Linux is not as coupled as with WSFC on Windows.
How to configure storage in SQL Server Cluster?
Configure storage, present the storage to the cluster nodes, and then move the database files to the new storage. The following articles explain the steps for each storage type: On both cluster nodes, create a file to store the SQL Server username and password for the Pacemaker login.