Compatibility between atom (2.6.0) and MariaDB

136 views
Skip to first unread message

Seb Muller

unread,
Sep 2, 2020, 11:16:20 AM9/2/20
to AtoM Users
Hello,

I would like to know if an update of last atom version (2.6.0) is scheduled in the future to have a compatibility with MariaDB ?

Thanks for information

Dan Gillean

unread,
Sep 3, 2020, 10:09:32 AM9/3/20
to ICA-AtoM Users
Hi Seb, 

That is going to depend on the MariaDB community, not on work to be done in AtoM. 

In the 2.6 release, we moved to MySQL 8.0 because it brings with it new features (such as support for Common Table Expressions) that have allowed us to significantly optimize slow-running operations - particularly those that previously relied on a Nested set model to deal with hierarchical relations.

MariaDB is a community-maintained fork of MySQL, and so far they have not released a version that is fully compatible with MySQL8. See for example: 
I do believe that the latest version of MariaDB supports CTE, but there are other features, such as the authentication plugins and the collation formats, that differ enough to prevent full compatibility with AtoM at present.   

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056
@accesstomemory
he / him


--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/6d1bd5f8-d5e1-486a-9fa1-be5232206fe3n%40googlegroups.com.

Seb Muller

unread,
Sep 6, 2020, 3:32:19 PM9/6/20
to AtoM Users
Hello Dan, thank you very much for your response and this informations.

Cordially
Seb Muller

Grant Forrest

unread,
Dec 14, 2020, 8:30:05 AM12/14/20
to AtoM Users
Can I add that at this time, AtoM 2.6 is incompatible with MariaDB. The collation  utf8mb4_0900_ai_ci is missing from MariaDB 10.x and no mention of it being added in forthcoming releases. 

sunny...@gmail.com

unread,
Feb 4, 2021, 10:27:21 AM2/4/21
to AtoM Users
Hi all, 

We recently tested AtoM 2.6.1 installation with MariaDB and successfully deployed it to our production environment(https://discoverarchives.library.utoronto.ca/).
I'd like to share the steps our talented network services administrator, Chris Crebolder suggested. 

1. Update MariaDB to 10.5 (Our version is 10.5.8).
2. Patch the mysql8 default charset with something more universal in AtoM 2.6.1. (See the attached patch)
3. Run the upgrade task following the AtoM's instructions
    php -d memory_limit=-1 symfony tools:upgrade-sql

4. Run other necessary tasks 

We haven't identified any critical issues with this installation so far but we will share if anything comes up.
Hope this will be helpful.

Take care,
Sunny Lee
Digital Initiatives Application Programmer Analyst | University of Toronto Libraries | Information Technology Services
She/her
use-utf8-charset-and-collation.patch

Dan Gillean

unread,
Feb 5, 2021, 9:52:47 AM2/5/21
to ICA-AtoM Users
Hi Sunny, 

Thanks so much for sharing this! Please keep us updated over time if you do run into issues that you think result from this change. 

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056
@accesstomemory
he / him

Reply all
Reply to author
Forward
0 new messages