Bug 2066338

Summary:	Complete MVP requirements for the system role for HA Configuration of MS SQL Server
Product:	Red Hat Enterprise Linux 8	Reporter:	Sergei Petrosian <spetrosi>
Component:	ansible-collection-microsoft-sql	Assignee:	Sergei Petrosian <spetrosi>
Status:	CLOSED ERRATA	QA Contact:	Daniel Yeisley <dyeisley>
Severity:	unspecified	Docs Contact:	Alexandra Nikandrova <anikandr>
Priority:	unspecified
Version:	8.7	CC:	dyeisley, gfialova, lmanasko
Target Milestone:	rc	Keywords:	Triaged
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
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.	Story Points:	---
Clone Of:	2066337
Clones:	2129869 (view as bug list)		Environment:
Last Closed:	2022-11-08 09:47:20 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	2129869

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.

https://access.redhat.com/errata/RHBA-2022:7597