Atlassian says the embedded DB is only for evaluation purposes and isn't sutible for production.
Why not? I have found zero docs on why I should move to an external DB. What problems will I run into running the embedded HSQL DB? What about it makes it not production ready?
What if I have a client that has a production bamboo installation but they are still using the embedded DB. What do I tell them, move to an external DB because.... why?
When using the default HSQLDB database, you run the risk of irrecoverable data loss mainly during system crashes because HSQLDB is not transaction safe. You can also suffer from performance issuse as the database increases in size. An external databases will most likely provide superior speed and scalability.
If you client finds those issues acceptable then there is no reason to switch. The following information is from Atlassian's website:
Production sites should use an external database. See our guide to database configuration. When using the default HSQLDB database, you run the risk of irrecoverable data loss because HSQLDB is not transaction safe.
HSQLDB is suitable for evaluation purposes, but the risk can only be eliminated by switching databases. This is essential when you move from an evaulation to a production site. External databases may also provide superior speed and scalability.
G’day Community! As we gear up to introduce Bamboo Data Center to the world, we wanted to make sure that we shared a bit more about Bamboo, the product. Our team has put together an overview video ...
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