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

Add the mssql_ha_prep_for_pacemaker variable to configure SQL Server for Pacemaker

    • ansible-collection-microsoft-sql-2.2.0-1.el9
    • sst_system_roles
    • QE ack, Dev ack
    • False
    • Hide

      None

      Show
      None
    • Feature
    • 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

      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
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: