Percona database with mariadb driver

[Daniel Merino]

Hi everybody,

we have recently been hit by the issue fixed in https://sakaiproject.atlassian.net/browse/SAK-40430 . When the SiteStats Event Aggregator job aggregates events, the date & time field is read in UTC format from SAKAI_EVENT table and stored as CEST in SST_DETAILED_EVENTS table, so the events of User Activity tab in T&Q are currently two hours "in the past".

After SAK-40430 this should be fixed just configuring this property:

sakaiEven...@org.sakaiproject.sitestats.api.StatsAggregateJob=UTC

However, we have found that this property has no effect if we use the Mysql driver (mysql-connector-java-5.1.49.jar). The code that creates a Calendar instance with a TimeZone object with the right offset doesn't change anything and just returns the same Date & Time.

When we switch to MariaDB driver in sakai.properties the code using the property works, the offset is added to the date & time and the issue is fixed.

We have always used the mysql driver and we are a bit scared of switching it in production. We are using Sakai 20.3 and our database is Percona 5.7.34-37. Is anybody out there using mariadb driver in production with this database? Does it work fine or does it need any special setting?

Thanks in advance.
Best regards.

-- 
Daniel Merino Echeverría
daniel...@unavarra.es
Gestor de E-learning - Centro Superior de Innovación Educativa.
Tfno: 948-168489 - Universidad Pública de Navarra.

[Miguel Pellicer]

Testing is the answer Dani but I believe the MariaDB driver has not diverged enough and it just works fine, it's a way better option than 5.1.49 in my opinion, and it's also bundled with the Sakai binaries, easier to maintain.

I think some institutions use it but I can't confirm this, it's in the default installation for a reason.

I'd like to know more about this Dani, let me know your experience with the driver and percona!

Miguel

--
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 view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/sakai-dev/5d34b624-6965-86b1-4912-9a3f75174de2%40unavarra.es.

-- 
-----------------------------------------------
Miguel Pellicer
CTO at EDF

Website: https://www.edf.global
LinkedIn: https://www.linkedin.com/in/mpellicer-edf
Office Phone: +34 - 96 381 35 75
Request a meeting here: https://calendly.com/mpellicer
-----------------------------------------------

[Austin]

Is anyone using the MariaDB connector/j with MySQL Enterprise 5.7?  If so, which version of the MariaDB driver?

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/sakai-dev/a9667560-c336-21e9-c42f-71db419d6e36%40entornosdeformacion.com.