New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE

DMA - SQL Cluster patching with roll back in the same flow

Idea ID 2834585

DMA - SQL Cluster patching with roll back in the same flow

Scenario

The customer asks for a new development of the SQL Cluster DMA workflow that should roll back the patch on the whole cluster if at least on one node of the cluster the patch fails.
The ootb WF patches all the nodes of the cluster and just terminates in error if one patching subflow fails.
The need is to roll back the patched nodes in the same wf and terminate the mail flow leaving the whole cluster at the same patch level (all nodes patched or all nodes not patched).

Workaround

run the roll back for SQL standalone

Unacceptable

1. if the patching fails on some nodes of the cluster the wf leaves the cluster in an inconsistent state (it's not patched the whole cluster)
2. using the workaround the customer has to run a single flow for each node since it is not supported the rolling modality for roll back (as for cluster SQL patching)

Required

the flow should leave the cluster in a consistent state:
all nodes patched
or
all nodes NOT patched (rolling back the ones terminated in error)

2 Comments
Micro Focus Contributor
Micro Focus Contributor

Good idea in order to get all the environments consistent and improve automation activities with a lower human interaction

Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.