Requesting information about recommended settings for a Clustered MSSQL DB used to power CA Process Automation version 4.3.100 (and above).
Specifically, how should the cluster be configured with respect to failover/failback for its nodes? (Active/Active? Active/Standby? Other?)
I have tried looking at both CA online documentation and Communities, but was unable to find any details.
(Background Info: We have been experiencing PAM failures whenever DB failover/failback occurs within our MSSQL cluster. PAM does not recover even when DB failover/back is complete. We have to completely stop all PAM services on all nodes before even touching the DB nodes in the cluster or we risk complete failure of the entire system.)
We have no documentation on this, clustering your database.
Our only requirement is that we can access the database at a Single JDBC URL. For failover to work, the database connections will also have to be moved between databases, we open connections that remain open while the orchestrator works, if those are suddenly broken, Process Automation will not attempt to reestablish new connections.
In our next release 4.3 sp3 we are making some improvements to this and we will support Microsoft's AlwaysOn functionality.