Bug 2066338 - Complete MVP requirements for the system role for HA Configuration of MS SQL Server
Summary: Complete MVP requirements for the system role for HA Configuration of MS SQL ...
Alias: None
Product: Red Hat Enterprise Linux 8
Classification: Red Hat
Component: ansible-collection-microsoft-sql
Version: 8.7
Hardware: Unspecified
OS: Unspecified
Target Milestone: rc
: ---
Assignee: Sergei Petrosian
QA Contact: Daniel Yeisley
Alexandra Nikandrova
Depends On:
Blocks: 2129869
TreeView+ depends on / blocked
Reported: 2022-03-21 14:42 UTC by Sergei Petrosian
Modified: 2022-11-08 10:47 UTC (History)
3 users (show)

Fixed In Version: ansible-collection-microsoft-sql-1.2.4-1.el8
Doc Type: Enhancement
Doc Text:
.Enhanced Microsoft SQL Server RHEL System Role The following new variables are now available for the `microsoft.sql.server` RHEL System Role: * Variables with the `mssql_ha_` prefix to control configuring a high availability cluster. * The `mssql_tls_remote_src` variable to search for `mssql_tls_cert` and `mssql_tls_private_key` values on managed nodes. If you keep the default `false` setting, the role searches for these files on the control node. * The `mssql_manage_firewall` variable to manage firewall ports automatically. If this variable is set to `false`, you must enable firewall ports manually. * The `mssql_pre_input_sql_file` and `mssql_post_input_sql_file` variables to control whether you want to run the SQL scripts before the role execution or after it. These new variables replace the former `mssql_input_sql_file` variable, which did not allow you to influence the time of SQL script execution.
Clone Of: 2066337
: 2129869 (view as bug list)
Last Closed: 2022-11-08 09:47:20 UTC
Type: Bug
Target Upstream Version:

Attachments (Terms of Use)

System ID Private Priority Status Summary Last Updated
Github linux-system-roles mssql pull 62 0 None open Draft: Add support for configuring HA cluster 2022-05-24 13:16:48 UTC
Red Hat Issue Tracker RHELPLAN-116295 0 None None None 2022-03-21 15:08:16 UTC
Red Hat Product Errata RHBA-2022:7597 0 None None None 2022-11-08 09:47:35 UTC

Description Sergei Petrosian 2022-03-21 14:42:59 UTC
+++ This bug was initially created as a clone of Bug #2066337 +++

Description of problem:
The microsoft.sql.server roles must support HA clustering with primary, synchronous, and witness replicas.
The following functionality must be added to the role:
* Distribute Microsoft cluster crypto keys for SQL Server cluster nodes using T-SQL commands and copying (per Amy Farley) 	  	
* Add support to ha_cluster and SQL server roles to support SQL Server Enterprise * Edition and Standard Edition clustering utilizing pacemaker, with 1 primary and up to 2 synchronous (or 1 replica and 1 witness) replicas.   	  	
* On SQL Server Enterprise Edition, support for adding/removing nodes utilizing ha_cluster and SQL server System Roles 	  	
* On SQL Server Enterprise Edition, the ability to start and stop the cluster by utilizing the System Roles 	  	
* Delivery as part of RHEL RPM's as well as Automation Hub  	  	
* Example playbooks provided in role README files for common SQL Server clustering use cases 	  	
* System Roles functionality is idempotent 	  	
* System Roles should support all versions of RHEL where SQL Server on RHEL is supported 	  	
* On RHEL 8.3 or later, automatically use on_fail="demote" with pcs setup and set WRITE_LEASE_VALIDITY=20 in CREATE_AVAILABILITY_GROUP

Comment 17 errata-xmlrpc 2022-11-08 09:47:20 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (ansible-collection-microsoft-sql bug fix and enhancement update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.


Note You need to log in before you can comment on or make changes to this bug.