Skip to content

Commit a1e74ff

Browse files
committed
Acrolinx improvements for style
1 parent f8d2f2b commit a1e74ff

3 files changed

Lines changed: 9 additions & 9 deletions

File tree

docs/linux/sql-server-linux-availability-group-cluster-sles.md

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -87,7 +87,7 @@ The first step is to configure the operating system on the cluster nodes. For th
8787

8888
## Configure an Always On Availability Group
8989

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)
9191

9292
## Install and configure Pacemaker on each cluster node
9393

@@ -146,7 +146,7 @@ If you have a cluster running with one or more nodes, add more cluster nodes wit
146146

147147
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`:
148148
- 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.
150150

151151
1. Log in as root to the physical or virtual machine supposed to join the cluster.
152152
2. Start the bootstrap script by executing:
@@ -161,7 +161,7 @@ If you have configured the existing cluster nodes with the `YaST` cluster module
161161

162162
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.
163163

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.
165165

166166
5. Repeat the previous steps for all machines you want to add to the cluster.
167167

@@ -182,11 +182,11 @@ If you have configured the existing cluster nodes with the `YaST` cluster module
182182
>[!NOTE]
183183
>`admin_addr` is the virtual IP cluster resource which is configured during initial one-node cluster setup.
184184
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.
186186

187187
## Set cluster property start-failure-is-fatal to false
188188

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.
190190

191191
To update the property value to false run:
192192
```bash
@@ -263,7 +263,7 @@ primitive admin_addr \
263263
```
264264

265265
### 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.
267267

268268
To set colocation constraint for the virtual IP to run on same node as the master, run the following command on one node:
269269

docs/linux/sql-server-linux-ha-basics.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -108,7 +108,7 @@ Similar to Windows, Linux distributions have a built-in firewall. If your compan
108108
| Variable | TCP/UDP | NFS – port for `MOUNTD_PORT` (found in `/etc/sysconfig/nfs` on RHEL) |
109109
| Variable | TCP/UDP | NFS – port for `STATD_PORT` (found in `/etc/sysconfig/nfs` on RHEL) |
110110

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).
112112

113113
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
114114

docs/linux/sql-server-linux-shared-disk-cluster-sles-configure.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -101,7 +101,7 @@ Another storage option is to use SMB file share:
101101
102102
### Configure an NFS server
103103
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).
105105
106106
### Configure all cluster nodes to connect to the NFS shared storage
107107
@@ -247,7 +247,7 @@ Full list of resources:
247247

248248
## Managing cluster resources
249249

250-
To manage your cluster resources, refer to the following SUSE topic:
250+
To manage your cluster resources,see the following SUSE topic:
251251
[Managing Cluster Resources](https://www.suse.com/documentation/sle-ha-12/singlehtml/book_sleha/book_sleha.html#sec.ha.config.crm )
252252

253253
### Manual failover

0 commit comments

Comments
 (0)