I am hoping craft supports MariaDB. Also, since version 10, InnoDB transaction engine in MariaDB has been replaced with XtraDB. Will this work with Craft?
Asked
Active
Viewed 2,205 times
1 Answers
9
Update: Craft 3 officially supports MariaDB 5.5+ now. https://docs.craftcms.com/v3/requirements.html
Not officially, no. MariaDB is supposed to a "drop-in" replacement for MySQL, but there are clearly areas where it is not 1:1 compatible with MySQL: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/
We've seen some installations using MariaDB where a query would actually return incorrect results and the same MySQL query on the same database returns that data correctly.
Brad Bell
- 67,440
- 6
- 73
- 143
-
Thats unfortunate for me. I was planning to setup a local dev environment on my synology NAS box. It comes with all the requirements - Apache web server, php, phpadmin and until recently msql. It has replaced mysql in a recent software update with MariaDB. I wonder if the problems you mention above are resolved in version 10 of MariaDB ( They seem to have been existent on version 5 - way back). – user2022284 Oct 21 '14 at 18:45
-
Entirely possible. We saw a slew of MariaDB related support tickets maybe 8-12 months ago, but really haven't seen one in awhile. – Brad Bell Oct 21 '14 at 18:47
-
I wonder where I can poll the craft community to see if anyone has successfully used it with MariaDB 10 without any hiccups. – user2022284 Oct 21 '14 at 19:02
-
Either on Twitter with the #craftcms hashtag or the G+ group buildwithcraft.com/gplus should do it. – Brad Bell Oct 21 '14 at 19:03
-
Any update on official support on the latest versions @BradBell? Or plans for it? – Russ Back Apr 03 '16 at 20:13
-
@RussBack no word on official support, but we haven't seen any issues with people running it in quite some time. – Brad Bell Apr 03 '16 at 20:58
-
From my experience, craft runs much slower with big amount of data (40k categories in my case) on MariaDB, had to switch to MySQL 5.7. – Mark H. Mar 26 '18 at 09:54