This is a question for Atlassian.
What are you guys using as a DB HA solution for your DataCenter product line?
We have a Jira DataCenter instance for few years now with PostgreSQL installed and as DB HA, we setup the Transaction Log Shipping method. But we are looking for a more robust solution.
So I would like to know what are you guys using at Atlassian.
We use a multi-AZ deployment of PostgreSQL in Amazon RDS for our production sites like jira.atlassian.com. Under the hood, Amazon uses their own proprietary stack to capture and replicate the read/write requests the database engine is making. The details are quite interesting if you have spare time to read through them.
The CloudFormation templates we provide in our Quick Starts for AWS include the setup we're using.
You might be interested in having a look: