We are doing a full migration/new installation from a very old version of software. The current installations use the evaluation copies of the databases, but this is not ideal and in some cases, no longer supported. We are looking at using either PostgreSQL or MySQL on a Windows platform. Is it possible to have only one database engine/instance handle the all 4 of the applications (Jira, Confluence, Bitbucket, and Bamboo), or do you need 4 different database instances, or some mix? We are finalizing the sizings of our VMs for installation, and I need to understand the database situation to finalize the sizing.
The evaluation databases (hsql or h2, depending on version) are not supported and never have been. Moving to Postgres or MySQL is a very very good plan.
I know you didn't ask, but I'd recommend Postgres over MySQL, mainly because Atlassian code for it first and run most of their stuff on it (so it accidentally gets more tested). That is only a recommendation when you don't have a preference though. The real life recommendation is "use the one your organisation has the best support for". If 90% of your servers are on MySQL, you'll have more MySQL-knowledgable people, so use that.
You can indeed run them all off the same database. You don't have to, the applications really don't care where their databases are, as long as they have full access and no-one else writing to them.
As an example, this is a Postgres I've got running on a Raspberry Pi behind several applications:
I'm Alison Huselid, Head of Product for Data Center at Atlassian. As we shared in our last post, we’ve been working on a solution for those of you who work for charitable non-profit organizations tha...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events