Confluence MSSQL Server Cluster Support

[Ethan Young]

Hi,

I'm looking into migrating our Confluence server from 5.8.14 to latest and from the embedded database to a MSSQL High Availability group. I can't find any information on if this is supported at all. Can someone give me confirmation that Confluence does/does not support failover/High Availability/MSSQL Cluster?

Thanks,

Ethan

[Danyal Iqbal]

Confluence supports failover/High Availability/MSSQL Cluster.

Just out of curiosity: What's your Use case?

[Ethan Young]

I can't seem to find any documentation pertaining to this, can you link me a source? That'd help a lot!

We're using Confluence as a help site for our application and it's used quite frequently. Any downtime would be bad, so we're planning on moving it from the embedded DB to our SQL Server cluster in case of any breakages.

[Nic Brough -Adaptavist-]

You absolutely should not be using the embedded database, it is known to fail without warning and catastrophically when it goes.  You could lose your entire system at any second.

Confluence does not care if your database is clustered, it just needs something that appears to be a single reliable datasource in one place that it can use exclusively.

(I am assuming you are not trying to cluster Confluence.  You can't.  Unless you have data-centre)

[Ethan Young]

Yeah, we've heard bad things about it, hence the switching over to MSSQL. So that answers my question!

"Confluence does not care if your database is clustered, it just needs something that appears to be a single reliable datasource in one place that it can use exclusively."

So Confluence itself doesn't know if the database is clustered, it just sees that there's a datasource? That's pretty convenient. 

Yeah, I'm not trying to cluster Confluence itself.

Would you happen to have any official documentation that says this? You know how managers like official documentation. 

Thanks a lot, Nic. :)