Is anyone running MariaDB?

[Mickey Johnson]

Hi all,

I am curious if anyone is currently running Sakai with MariaDB, and if they have had any issues or have any wisdom to share. I know the Sakai release notes say "should work with Sakai but it is not officially supported" but beyond that info is hard to come by.

Thanks in advance.

--

Mickey Johnson
Web Application Developer

Information & Technology Services
Pacific Lutheran University
Tacoma, WA 98447

253.535.7588

[Matthew Jones]

I ran it locally for awhile in dev, but each release of the JDBC driver caused various issues so I stopped and switched back to MySQL. I really can't recommend using it. 

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+...@apereo.org.
To post to this group, send email to saka...@apereo.org.
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

[Earle Nietzel]

Hi Mickey,

I don't think there is any issue with MariaDB itself but (as Matt pointed out) there are issues with its JDBC connector/j especially around timezone's.

I think this article eludes to some of the these issues:
https://dba.stackexchange.com/questions/44611/to-what-extent-is-mariadb-java-client-a-perfect-replacement-for-mysql-jdbc-conn

and

https://jira.mariadb.org/browse/CONJ-433

However with all that said there are newer versions (i.e. 2.x) of the driver that in large part doesn't have much production experience yet so things could be improved!

[Matthew Jones]

Yeah, it worked better for me a a few years ago, lately there's been just startup issues (with auto.ddl) and issues with time-zones that were unexpected. So much that it just wasn't worth the effort when MySQL has worked perfect for me.

[Hendrik Steller]

Hi,

we've been using maria DB in production since at least last Christmas when we
upgraded the servers to Debian Jessie.
And I've always (for ~4 years) been using it for sakai development simply
because it's the default install of the Linux distro I use and there were no
problems.
But we've always used maria db with the mysql JDBC driver, which might make a
difference.

I wanted to say there were "no issues", but thinking about it, the last time I
tried to make a clean install without a pre-existing database, there were some
oddities with tables not being created.
But IIRC this was because some beans don't trim property values or don't use
proper typing which would make spring do the conversion.[*]

Hendrik

[*]
That was fun to debug:
I think some central Sakai beans use "setAutoDDL(String)" and some others use
"setAutoDDL(Boolean)".
Which means it depends entirely on each bean's implementation of
"setAutoDDL(String)" whether "auto.ddl=true " with an accidental, invisible
whitespace at the end gets treated as true or false.
Hence, some beans were creating tables while others weren't...

[Matthew Jones]

Yeah, I've tried to use the jdbc driver that matches the database. MariaDB with the MySQL JDBC might have been fine. And for quite awhile Maria with Maria JDBC was fine but right up to about 1.5.9, 1.6.0, 2.0.1 and 2.0.2 a few months ago it just was random problems for me. They have had a really rapid number of jdbc releases over the last few months though, but I never had an issue I remember with the MySQL JDBC.

https://jira.sakaiproject.org/browse/KNL-1528

https://jira.sakaiproject.org/browse/KNL-1533

[James Scoble]

We were using MySQL and upgraded it to MariaDB, seems to work the same. Same drivers. As long as all the same SQL commands work, and it responds on the same port, there shouldn't be a problem.

--

You received this message because you are subscribed to the Google Groups "Sakai Development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+unsubscribe@apereo.org.

To post to this group, send email to saka...@apereo.org.
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

Disclaimer - This e-mail is subject to UWC policies and e-mail disclaimer published on our website at: https://www.uwc.ac.za/Pages/emaildisclaimer.aspx