You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/linux/sql-server-linux-availability-group-cluster-sles.md
+6-6Lines changed: 6 additions & 6 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -87,7 +87,7 @@ The first step is to configure the operating system on the cluster nodes. For th
87
87
88
88
## Configure an Always On Availability Group
89
89
90
-
On Linux servers configure the availability group and then configure the cluster resources. To configure the availability group, see [Configure Always On Availability Group for SQL Server on Linux](sql-server-linux-availability-group-configure-ha.md)
90
+
On Linux servers, configure the availability group and then configure the cluster resources. To configure the availability group, see [Configure Always On Availability Group for SQL Server on Linux](sql-server-linux-availability-group-configure-ha.md)
91
91
92
92
## Install and configure Pacemaker on each cluster node
93
93
@@ -146,7 +146,7 @@ If you have a cluster running with one or more nodes, add more cluster nodes wit
146
146
147
147
If you have configured the existing cluster nodes with the `YaST` cluster module, make sure the following prerequisites are fulfilled before you run `ha-cluster-join`:
148
148
- The root user on the existing nodes has SSH keys in place for passwordless login.
149
-
-`Csync2` is configured on the existing nodes. For details, refer to Configuring Csync2 with YaST.
149
+
-`Csync2` is configured on the existing nodes. For more information,see Configuring Csync2 with YaST.
150
150
151
151
1. Log in as root to the physical or virtual machine supposed to join the cluster.
152
152
2. Start the bootstrap script by executing:
@@ -161,7 +161,7 @@ If you have configured the existing cluster nodes with the `YaST` cluster module
161
161
162
162
4. If you have not already configured a passwordless SSH access between both machines, you will also be prompted for the root password of the existing node.
163
163
164
-
After logging in to the specified node, the script will copy the Corosync configuration, configure SSH and `Csync2`, and will bring the current machine online as new cluster node. Apart from that, it will start the service needed for Hawk. If you have configured shared storage with `OCFS2`, it will also automatically create the mountpoint directory for the `OCFS2` file system.
164
+
After logging in to the specified node, the script copies the Corosync configuration, configures SSH and `Csync2`, and brings the current machine online as new cluster node. Apart from that, it starts the service needed for Hawk. If you have configured shared storage with `OCFS2`, it also automatically creates the mountpoint directory for the `OCFS2` file system.
165
165
166
166
5. Repeat the previous steps for all machines you want to add to the cluster.
167
167
@@ -182,11 +182,11 @@ If you have configured the existing cluster nodes with the `YaST` cluster module
182
182
>[!NOTE]
183
183
>`admin_addr` is the virtual IP cluster resource which is configured during initial one-node cluster setup.
184
184
185
-
After adding all nodes, check if you need to adjust the no-quorum-policy in the global cluster options. This is especially important for two-node clusters. For more information, refer to Section 4.1.2, Option no-quorum-policy.
185
+
After adding all nodes, check if you need to adjust the no-quorum-policy in the global cluster options. This is especially important for two-node clusters. For more information,see Section 4.1.2, Option no-quorum-policy.
186
186
187
187
## Set cluster property start-failure-is-fatal to false
188
188
189
-
`Start-failure-is-fatal` indicates whether a failure to start a resource on a node prevents further start attempts on that node. When set to `false`, the cluster will decide whether to try starting on the same node again based on the resource's current failure count and migration threshold. So, after failover occurs, Pacemaker will retry starting the availability group resource on the former primary once the SQL instance is available. Pacemaker will take care of demoting the replica to secondary and it will automatically rejoin the availability group. Also, if `start-failure-is-fatal` is set to `false`, the cluster will fall back to the configured failcount limits configured with migration-threshold so you need to make sure default for migration threshold is updated accordingly.
189
+
`Start-failure-is-fatal` indicates whether a failure to start a resource on a node prevents further start attempts on that node. When set to `false`, the cluster decides whether to try starting on the same node again based on the resource's current failure count and migration threshold. So, after failover occurs, Pacemaker retries starting the availability group resource on the former primary once the SQL instance is available. Pacemaker takes care of demoting the replica to secondary and it automatically rejoins the availability group. Also, if `start-failure-is-fatal` is set to `false`, the cluster falls back to the configured failcount limits configured with migration-threshold so you need to make sure default for migration threshold is updated accordingly.
190
190
191
191
To update the property value to false run:
192
192
```bash
@@ -263,7 +263,7 @@ primitive admin_addr \
263
263
```
264
264
265
265
### Add colocation constraint
266
-
Almost every decision in a Pacemaker cluster, like choosing where a resource should run, is done by comparing scores. Scores are calculated per resource, and the cluster resource manager chooses the node with the highest score for a particular resource. (If a node has a negative score for a resource, the resource cannot run on that node.) We can manipulate the decisions of the cluster with constraints. Constraints have a score. If a constraint has a score lower than INFINITY, it is only a recommendation. A score of INFINITY means it is a must. We want to ensure that primary of the availability group and the virtual ip resource are run on the same host, so we will define a colocation constraint with a score of INFINITY.
266
+
Almost every decision in a Pacemaker cluster, like choosing where a resource should run, is done by comparing scores. Scores are calculated per resource, and the cluster resource manager chooses the node with the highest score for a particular resource. (If a node has a negative score for a resource, the resource cannot run on that node.) We can manipulate the decisions of the cluster with constraints. Constraints have a score. If a constraint has a score lower than INFINITY, it is only a recommendation. A score of INFINITY means it is a must. We want to ensure that primary of the availability group and the virtual ip resource are run on the same host, so we define a colocation constraint with a score of INFINITY.
267
267
268
268
To set colocation constraint for the virtual IP to run on same node as the master, run the following command on one node:
Copy file name to clipboardExpand all lines: docs/linux/sql-server-linux-ha-basics.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -108,7 +108,7 @@ Similar to Windows, Linux distributions have a built-in firewall. If your compan
108
108
| Variable | TCP/UDP | NFS – port for `MOUNTD_PORT` (found in `/etc/sysconfig/nfs` on RHEL) |
109
109
| Variable | TCP/UDP | NFS – port for `STATD_PORT` (found in `/etc/sysconfig/nfs` on RHEL) |
110
110
111
-
For additional ports that may be used by Samba, refer to[Samba Port Usage](https://wiki.samba.org/index.php/Samba_Port_Usage).
111
+
For additional ports that may be used by Samba,see[Samba Port Usage](https://wiki.samba.org/index.php/Samba_Port_Usage).
112
112
113
113
Conversely, the name of the service under Linux can also be added as an exception instead of the port; for example, `high-availability` for Pacemaker. Refer to your distribution for the names if this is the direction you wish to pursue. For example, on RHEL the command to add in Pacemaker is
Copy file name to clipboardExpand all lines: docs/linux/sql-server-linux-shared-disk-cluster-sles-configure.md
+2-2Lines changed: 2 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -101,7 +101,7 @@ Another storage option is to use SMB file share:
101
101
102
102
### Configure an NFS server
103
103
104
-
To configure an NFS server, refer to the following steps in the SUSE documentation: [Configuring NFS Server](https://www.suse.com/documentation/sles-12/singlehtml/book_sle_admin/book_sle_admin.html#sec.nfs.configuring-nfs-server).
104
+
To configure an NFS server,see the following steps in the SUSE documentation: [Configuring NFS Server](https://www.suse.com/documentation/sles-12/singlehtml/book_sle_admin/book_sle_admin.html#sec.nfs.configuring-nfs-server).
105
105
106
106
### Configure all cluster nodes to connect to the NFS shared storage
107
107
@@ -247,7 +247,7 @@ Full list of resources:
247
247
248
248
## Managing cluster resources
249
249
250
-
To manage your cluster resources, refer to the following SUSE topic:
250
+
To manage your cluster resources,see the following SUSE topic:
0 commit comments