replace mysql with mariaDB in jira

For licence reasons, we have to change our mySQL Database to MariaDB.

The database was installed succesfully but JIRA does not start with the connector of MariaDB I have downloaded here : https://downloads.mariadb.org/client-java/1.1.8/

It still requires the official mySQL connector.

Do you know what dbconfig.xml should I use ?

Any experience of JIRA with Maria DB ?

3 answers

1 accepted

1 vote

For support reasons, I'd suggest that you do not do this.  Atlassian only support MySQL, PostGreSQL, Oracle and MS-SQL-server.  If you use another database, they will try to help you, but if they suspect the database, you're on your own and will need to migrate back to a supported one to get any further help.  (I suspect Maria support will arrive eventually, but it's not going to be soon)

That said, you can make other databases work fine with JIRA.  I've run it on some pretty unusual ones, and the trick is basically to make the Tomcat datasource work correctly.  I've not tried it with Maria, but the ones I did make it work with were simply a case of following the instructions for connecting up a Tomcat and checking for quirks.

So, what error messages are you getting when you try MariaDB?

Thanks. The tool "config.bat" says :

Driver for the database MySQL not found. Ensure it is installed in the 'lib' directory.
If you are upgrading a standalone distribution of JIRA, this may be due to the fact that JIRA no longer ships with MySQL drivers.
Please visit https://docs.atlassian.com/jira/docs-062/Connecting+JIRA+to+MySQL for more information.

What type of database should I use ?

What is the dataconfig.xml should I write ?

Oh, you won't get it to work with the wizards, they only handle the supported databases. You could select MySQL for now, run with that and then swap over to Maria later (before putting any data into it). The MariaDB driver needs to go into the Tomcat lib directory rather that JIRAs though.

I just want to stress the point that Nic made earlier. You won't be able to get support on your instance if you are using MariaDB. We only allow MS SQL, MySQL, Oracle, and PostGres.

Actually, the version of jira we currently use is not supported anymore (too old). So I know that I won't be able to open a ticket in the jira of the support team anyway. If any big problem we will think about restoring data in a supported database.

In fact I changed the package to org.mariadb.jdbc.Driver in the dbconfig.xml.

Thanks

There is a ticket open in Atlassian that indicates that MariaDB is not supported for JIRA. See https://jira.atlassian.com/browse/JRA-32347

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,313 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot