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

which DB

Sambi Kolagotla Dec 17, 2014

since we are having all sorts of DB issues for any small upgrade, we would like to migrate our DB from SQL server, we have choice of MySQL and Oracle from RDMS, and choice of Mongo and Cassandra for NoSQL choices, which one is most suited for confluence size of our volume.

our current DB size is about 300 GB without attachments and our attachments on local storage are about 700 GB

1 answer

0 votes
Nic Brough [Adaptavist] Community Leader Dec 17, 2014

Forget Mongo and Cassandra, they're not supported.

MySQL and Oracle are supported, and the best answer I can give here is you should select the one that is best supported inside your organisation.

However, there's a big red flag here.  A 300Gb database for Confluence is very very large - that suggests large numbers of users, millions of pages, and you've been using it for many years.  At this sort of scale, you probably should be looking at Data Centre installations.

Sambi Kolagotla Dec 17, 2014

we are looking into datacenter version as well, however before we take that big step further, we wanted a good DB that can deal our volume, MySQL and Oracle are equally supported in our enterprise.

 

 

 

Nic Brough [Adaptavist] Community Leader Dec 17, 2014

I'm afraid I'd toss a coin then. MySQL is obviously cheaper, but you'll be able to get support direct from Oracle if you have any issues with it. Oracle may also have functions that are better for supporting a large enterprise, but frankly, I'd talk to your DBAs about it. One of our clients is moving from MySQL to Oracle because of some of the features they could take advantage of in their setup, but a lot of it went over my head, as I'm not a DBA. Personally, I'd go with MySQL, but that is purely because I know it better than Oracle.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

1,536 views 8 19
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