Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Stash internal v.s external database question.


I was wondering how stable is Stashes internal database?

I know the documentation says to use an external database for prodcuciton servers, but what does this really mean? Does this mean the internal database is not good for lots of users or keeping track of lots of repositories? Or is it slower or could crash the system?

What is the purpose of the database with respect to Stash. What type of data is saved in it?

Does it make a lot of sense to stand up an external database for less than 25 users?

Just want to know how much trouble we should go through to install an external database for our Stash instance.

Thank you.


3 answers

1 accepted

2 votes
Answer accepted

Do not use the internal database for any of the Atlassian products in a production environment.

The first time you have to try to recover a system because someone didn't want to bother with the external database, you will find out why they say to. Yes, it makes sense to stand-up an external database for 25 users. It gives you a lot of flexibility in architecture, tuning and tweaking.

The internal database is not great. It gets corrupted easily and as for "what is stored there..." users, repositories, permissions, code, etc., etc., etc.

Go through the trouble, which isn't that much. You can get a vanilla, internally facing version of stash up and running in about 10-15 minutes if you have hardware/vm's you can use. MySQL, Postgres are both free.

From what I've read in external database is used for meta-data only NOT for storing the code itself.

In my case the .GIT repositories are still stored locally on the Stash server.

I was under the impression it was, but you still need a backup in place for the server itself.

That is correct, the Git repositories are stored on disk. That means you need to backup both the database and filesystem to include everything (and is what the Stash backup client does).

The internal database is not very stable at all and thus not recommended for production systems. In the most extreme case the internal database (HSQLDB) is subject to data loss should your sever encounter power loss and HSQLDB is not transaction safe. Setting up an external database is highly recommended.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Bitbucket

New improvements to user management in Bitbucket Cloud 👥

Hey Community! We’re willing to wager that quite a few of you not only use Bitbucket, but administer it too. Our team is excited to share that we’ll be releasing improvements throughout this month of...

4,397 views 12 15
Read article

Community Events

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

Events near you