Confluence Data Center Database Failover

[Rob Roach]

Working on the final stages of our migration to Confluence Data Center.

We're using Windows Server 2016 as the application servers, and a MSSQL 2016 cluster as the database.

One thing we've noted during testing is... when the db cluster fails over to another node, the application servers obviously lose database connectivity.  However, the Windows Confluence service keeps running, and they never recover without the service being restarted.

Is there a way to manage some kind of keep alive/poll to see if the database connectivity has resolved and the nodes can function as expected?

Thanks!

[Diego]

Hello there!

So Rob, as of today the use of Clustered databases is not listed as supported for Confluence. As long as the failover is transparent to Confluence, this situation should not happen.

Further, you can check this suggestions that tackles exactly this:

CONFSERVER-20277 | Officially Support Clustered Database for Confluence

In this request, we have this connection string a possible workaround to this:

jdbc:jtds:sqlserver://<server>:<port>/<database>;instance=<instance>

Let us know if this helps you out Rob!