Opened 9 years ago
Closed 7 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: | ||
| 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 by , 9 years ago
comment:2 by , 9 years ago
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 by , 7 years ago
| Resolution: | → invalid |
|---|---|
| Status: | new → closed |
We switched off of Drupal altogether, so this is no longer an issue.
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.