Opened 4 years ago

Closed 2 years ago

#11831 closed task (invalid)

Form an opinion if we should switch from MySQL to MariaDB on vmweb

Reported by: zooey Owned by: haiku-sysadmin
Priority: normal Milestone:
Component: Sys-Admin Version:
Keywords: Cc:
Blocked By: Blocking:
Has a Patch: no Platform: All

Description

Our Drupal site running on vmweb is currently using MySQL. In the meantime, openSUSE has switched to MariaDB as default. While this does not have to be bad news, it opens a risk of MySQL not getting the same attention as MariaDB by SUSE.

I suppose it might be advisable to switch to MariaDB, but the work involved is unclear. Maybe it is just a matter of installing the mariadb packages and everything will go smoothly, but before we try, we should read up on the migration process.

Change History (3)

comment:1 Changed 4 years ago by axeld

In theory, they are both compatible. I'm using MariaDB (10) on a number of systems without issues; the defaults are a bit more sane (which might cause problems when not overridden), and it performs better in a number of queries (not sure this would affect us).

If the data can be kept the same depends on the actual version -- importing an SQL dump should always work, though.

comment:2 Changed 4 years ago by axeld

That was a bit vague: IIRC there are two notable differences in the default configuration: the server character set is UTF-8, and it uses the strict SQL mode.

Some apps (like Typo3) don't like the strict mode. AFAIK, Drupal has no issues with this, but I only have experience with Drupal 7 in this regard.

comment:3 Changed 2 years ago by waddlesplash

Resolution: invalid
Status: newclosed

We switched off of Drupal altogether, so this is no longer an issue.

Note: See TracTickets for help on using tickets.