Hoping to upgrade from MariaDB 10.1 to 10.3. Is MariaDB 10.3 fully supported?

Also I am using a WHM VPS. Has anyone successfully just upgraded from MariaDB 10.1 to 10.3 from with WHM?

MariaDB 10.3 has some changes related to MySQL Strict Mode.

Comments

webservant316 created an issue. See original summary.

bobburns’s picture

bobburns CreditAttribution: bobburns commented

You need to contact WHM/cPanel for support.

I dumped WHM/cPanel and got onto a true free open VPS I fully control as much as one can with a VPS - and the cPanel license of $15.00 went away, and so too did email spam problems and cPanel people do not know much about Drupal or multisite and / or Domain Access.

If you change things on your Apache server - their scripts will change it right back unless you do a special exclusion setup procedure - and you will catch hell setting up virtual servers that can use Drupal's feature

I am running Mariadb 10.3 on a true Centos7 system with Webmin and Drupal 7 - but cPanel is its own version of Linux.

Webmin uses yum to keep the server up to date and drush keeps Drupal and core up to date

Apparently they support it and have an upgrade process - see https://documentation.cpanel.net/display/78Docs/MySQL+or+MariaDB+Upgrade

webservant316’s picture

webservant316 CreditAttribution: webservant316 commented

Any responses to these two articles warning about incompatibility between MariaDB 10.2+ and PHP 7.1+ ?

https://www.drupal.org/project/hostmaster/issues/3040331#comment-13022764

https://jira.mariadb.org/browse/MDEV-14555

webservant316’s picture

webservant316 CreditAttribution: webservant316 commented

I heard from a few people that drupal core is running fine with MariaDB 10.3 and I am testing my own config now. Not related to core but noting that there is at least one module that is incompatible. Check the issue here, https://www.drupal.org/project/site_audit/issues/3049498.

webservant316’s picture

webservant316 CreditAttribution: webservant316 commented

Tested MariaDB 10.3 on four Drupal 7 sites with PHP71 all day and the only problem observed was site_audit, #4 above.

memtkmcc’s picture

memtkmcc CreditAttribution: memtkmcc at Omega8.cc commented

The PHP/MariaDB compatibility issue you linked is only related to legacy extensions based on mysql/maria libraries. Switching to PHP native mysqlnd solves the problem. BOA HEAD already provides PHP 7.3 and MariaDB 10.3 based environment and it works for Drupal 8 and 7 without issues so far.

webservant316’s picture

webservant316 CreditAttribution: webservant316 commented

Yes, agreed. I am running PHP7.1 and MariaDB10.3 no problem. The only incompatibility I found was with the contrib site_audit module.

wturrell’s picture

wturrell CreditAttribution: wturrell as a volunteer commented

FWIW, I've had some integrity constraint violations problems with Drupal 8 and MariaDB 10.4.6 using homebrew on Mac.

#3066443: MariaDB on macOS - router table integrity constraint violations on cache clear and new site install

Version: 7.65 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.

joseph.olstad’s picture

joseph.olstad
Primary language French
CreditAttribution: joseph.olstad commented

I am having difficulties installing aegir on MariaDB 10.3 that runs on Drupal core 7.77

I recently upgraded to MariaDB 10.3 so that my server can run Drupal 9 sites also.

Drupal 9 is working on the same server although I haven't tried a fresh install yet since I upgraded to MariaDB 10.3, only upgrades.

Drupal 7 is working on the same server but I haven't tried a fresh install other than aegir.

max_allowed_packet is set to 64M

any other settings I should look at?

helmo’s picture

helmo CreditAttribution: helmo as a volunteer and at Initfour websolutions commented

Could you describe the difficulties?

The Aegir CI test on Debian 10 is also using MariaDB 10.3, see https://gitlab.com/aegir/provision/-/jobs/911397752

joseph.olstad’s picture

joseph.olstad
Primary language French
CreditAttribution: joseph.olstad commented

failure to install happened during the install.php

I did not use drush to install

error logs were not enabled (watchdog) so no errors in watchdog

if refresh, the site comes up without any content types.

sorry I forgot to grab error.log from the apache

chowdah’s picture

chowdah CreditAttribution: chowdah commented

FWIW, I upgraded a Drupal 7.84 running PHP 7.4 from MySQL 5.7 to MariaDB 10.3. Drupal site is pretty advanced, using multiple modules, and so far I see no issues.

joseph.olstad’s picture

joseph.olstad
Primary language French
CreditAttribution: joseph.olstad commented

recent updates to the db api in recent Drupal 7 releases most certainly improve compatibility both ways. McDruid and others have done a lot of great work on 7.x core in the past 12 months.