Will MySQL Databases work on MariaDB? Is there anything to consider or watch out for?

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
spessex's picture
Posted by spessex on April 17, 2013 at 1:16pm

Hi everyone

If I were to change across to MariaDB would my existing MySQL databases work without issue or is there anything I need to consider or watch out for?

Thank you

Stephen

Categories:

Comments

its worked fine for me in the

Posted by heavy_engineer on April 17, 2013 at 1:44pm
heavy_engineer's picture

its worked fine for me in the past, even using the different innodb engine worked fine.

Systems architecture and Drupal development - www.initsix.co.uk

Should be fine

Posted by jhodgdon on April 17, 2013 at 6:29pm
jhodgdon's picture

The test bots that run all automated tests for Drupal 7 and 8 during the development cycle, last I heard, are running on Maria DB. Which means that at least Drupal Core should be fine. It's definitely supposed to be a drop-in replacement.

Drupal programmer - http://poplarware.com
Drupal author - http://shop.oreilly.com/product/0636920034612.do
Drupal contributor - https://www.drupal.org/u/jhodgdon

define existing databases

Posted by adrinux on April 18, 2013 at 9:09am
adrinux's picture

I think by existing databases you literally mean the existing files, just uninstall MySQL and install MariaDB – it is supposed to be a drop in replacement, but never tried that personally. When I recently switched is was as a part of rebuilding my whole server, so all I can say is that running mysql dump on mysql and then loading the dumps back in on mariadb worked fine.

drop in replacement works well

Posted by fndtn357 on July 2, 2013 at 3:07pm
fndtn357's picture

I recently did the drop in replacement and have had no issues in this regard.

United Kingdom

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week

See all hot content.