I've gotten this to work with Confluence 5.1.3.
When configuring the database:
I just got this set up, but everything appears to be functioning properly at this point.
I'm in full agreement that MariaDB should be looked into more as a viable replacement for MySQL. It should be interesting seeing what happens as distributions switch over to it.
I just tried updating from a 5.1.5 install to 5.2.3. The DB is currently a MariaDB 5.5.23 install and was working fine with mysql-connector-java-5.1.11.jar driver.
When trying to run with mariadb-java-client-1.1.2.jar and the above settings I couldn't get a successful db update.
If anyone has further information about more recent confluence updates and if you've gotten mariadb to update then that would be great.
@Matt what ordering did everything happen for you? Did you start with an installation with the mysql connector and then switched to the maria connector, or was it something else?
If you want to follow this issue further, take a look at https://jira.atlassian.com/browse/CONF-29060 which is the issue tracking formal testing/support for it. They are also looking at it for JIRA.
It worked for me as well on JIRA v7.1.6.
I didn't find any mention of the hibernate dialect in the JIRA conf files, though.
I also applied de default install for MySQL, part of the Mysql configuration for Jira:
sudo vi /etc/my.cnf.d/server.cnf
I this still supposed to work with Confluence 6.6.x?
I'm getting 500 when installing on MariaDB...
Where do you change the Hibernate MySQL dialect settings before/during install? I think it's supposed to be in confluence.cfg.xml in the end, but that is not good during install.
Actually, I've got it working. My main problem was completely unrelated to MariaDB, but 'binlog_format = row' was missing.
In combination with the latest mysql-connector (5.1.45) I didn't have any problems (no hibernate modification, no mariadb-client) with a fresh Confluence 6.6.1 install on CentOS 7.4 using MariaDB 5.5.56. All DB checks show up as green.
I know it's unsupported, but so is most of open-source. But Jira and Confluence are paid products. If Atlassian cannot adapt to such trivial changes I'll ditch them before the next renewal.
Postgresql is top of the recommendation list for databases for Atlassian systems, it's the most widely used, it's the one Atlassian develop against, and it is open source.
MariaDB is not a "trivial" change, it's a fork, ostensibly to retain an open source version of MySQL, but it's diverged enough to make it difficult to support (not that MySQL is any better)
Red Hat announced today at the Red Hat Summit that MariaDB will be replacing MySQL in Red Hat Enterprise Linux 7, due out late 2013. http://www.bytebot.net/blog/archives/2013/06/12/mariadb-replaces-mysql-in-rhel7
I have to say, you guys need to fix this and now. It just doesn't work with MariaDB 5.5 at all (saying nothing of v10) and Confluence 5.4... ALL major distributions either HAVE or ARE GOING TO IN THE NEXT RELEASE abandon the Oracle crippled MySQL. If you want your product to remain viable in the fast changing landscape, get on it, it has been almost a year that this was reported.
I have checked the link discussion above and it points back here, you won't get any of my or my company's money right now and if it is not resolved in short order, we will move on to other products - and we would rather pay you. Up to you.
Nothing against mariadb, however Cox' comments about MySQL are not correct at all.
MySQL is not crippled, just look at these performance numbers:
and watch this video from linux.conf.au:
Some distros have added mariadb to their repos, that don't mean they have abandon MySQL.
I would like to add my opinion and point of view here, so as MariaDB is not a supported database, I did not see any customer using this database (even it is a db server developed by some of the original authors of MySQL). Maybe in the future this DB server can be supported, but actually just the databases listed in our supported platforms are recommended for Confluence 5.x, please see below:
But anyway let's hear from the community if somebody already tried this DB (even it is not supported), maybe another person can also comment here, let's see.
I hope this helps.
Well, as we see more and more Linux distributions dropping MySQL from being packaged with the OS and using MariaDB instead, I think it at least deserves an answer.
The more interesting question I'd like to know is if Atlassian will support MariaDB at some point in the near future with its products. I think MySQL is going to start to be used less, and use of MariaDB is going to increase since it is now going to be packaged with Fedora and Slackware...while not super-popular distros, they do have a solid following. Fedora is just a gateway to Red Hat proper and CentOS.
To me it would be nice to see support for both. I've already migrated several environments from MySQL backend to MariaDB without a single issue, and our Jira and Conflunce environments are the only ones still riding on top of MySQL.
Overall, the less I have to be dependent on anything coming out of Oracle, the happier I am. I realize that Java is a necessary evil.
I managed the installation with Confluence 5.4.4 based on
When configuring the database:
select MySQL External Database, then I put mysql-connector-java-5.1.29-bin.jar in directory /opt/atlassian/confluence/confluence/WEB-INF/lib
restart Confluence, then choose
I made several settings and tests after Confluence has been installed. Everything seems to be stable; no errors in logfiles found so far.
But MariaDB is very slow - at least on my Synology. Any ideas?
I tried Mariadb 10.0 on windows 7 64bit
JIRA 6.2.1 (64-bit).
Mariadb did seem to work (other than I had to use msql jdbc driver, as JIRA was looking at com.mysql.jdbc package while mariadb has org.mariadb.jdbc (jar tvf <connection jar> with plain old Jira.
However, I could not make jira-agile work. I think other plugins were working, at least the default ones that JIRA has, but jira-agile just would not run. I could see it was a valid license, I un-installed it, re-installed it, re-indexed, bounced the JIRA admin service, re-ran the granting of permissions in the mariadb for my jirauser account. I could not make it work reliably. I think I got it to spawn a jira-agile project, but not sure. I almost always see JIRA Agile is currently unavailable. This might be because an upgrade task has failed to run or has not not yet completed.
log file snippet has
2015-01-23 11:51:43,828 lexorank-executor-thread-0 ERROR ServiceRunner LEXO_RANK_SCHEDULER_JOB [net.java.ao.sql] Exception executing SQL update <CREATE TABLE AO_60DB71_VERSION (
ID BIGINT AUTO_INCREMENT NOT NULL,
VERSION_ID BIGINT NOT NULL,
java.sql.SQLSyntaxErrorException: Table 'ao_60db71_version' already exists
. I am moving to my server to use postgres right now...
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
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!
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