Uploaded image for project: 'RHEL'
  1. RHEL
  2. RHEL-19204

Add the mssql_ha_prep_for_pacemaker variable to configure SQL Server for Pacemaker

    • ansible-collection-microsoft-sql-2.2.0-1.el8
    • rhel-sst-system-roles
    • None
    • QE ack, Dev ack
    • False
    • Hide

      None

      Show
      None
    • None
    • None
    • Enhancement
    • Hide
      .New `mssql_ha_prep_for_pacemaker` variable

      Previously, the `microsoft.sql.server` RHEL System Role did not have a variable to control whether to configure SQL Server for Pacemaker. This update adds the `mssql_ha_prep_for_pacemaker`. Set the variable to `false` if you do not want to configure your system for Pacemaker and you want to use another HA solution.
      Show
      .New `mssql_ha_prep_for_pacemaker` variable Previously, the `microsoft.sql.server` RHEL System Role did not have a variable to control whether to configure SQL Server for Pacemaker. This update adds the `mssql_ha_prep_for_pacemaker`. Set the variable to `false` if you do not want to configure your system for Pacemaker and you want to use another HA solution.
    • Done
    • None

      Goal

      • As a user, I want to be able to select whether to configure SQL Server for HA with Pacemaker, or just prepare SQL Server for HA but not configure Pacemaker so that I can use a custom solution.{}

      Acceptance Criteria

      A list of verification conditions, successful functional tests, or expected outcomes in order to declare this story/task successfully completed.

      • Verify that you can run the role with {{mssql_ha_prep_for_pacemaker: true and mssql_manage_ha_cluster: true }}to configure AG and join nodes and prepare for Pacemaker and run Pacemaker cluster as usual.
      • Verify that you can run the role with {{mssql_ha_prep_for_pacemaker: false }}to configure with AG and join nodes but not prepare for Pacemaker

              spetros@redhat.com Sergei Petrosian
              spetros@redhat.com Sergei Petrosian
              Sergei Petrosian Sergei Petrosian
              Daniel Yeisley Daniel Yeisley
              Lucie Varakova Lucie Varakova (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: