Has anyone run CiviCRM on MariaDB instead of mySQL
Running CiviCRM on MariaDB could provide significant speed improvements.
CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.Sign up to join this community
We have mariadb on our newest server, it's a completely transparent replacement. I haven't noticed any major speed change, either better or worse, so I'd take your hope of major speed gain with a pinch of salt.
We switched to it mostly because they seem to do a better job at pushing new features than oracle... and because it looks like 100% the same, as viewed from civi
I have used Maria db 10 and noticed improved stability and lower resources utilization on 3 instances.... esp memory footprint. While it is a drop in replacement be sure to review the details about each version compatailty. Also btw Cpanel is moving from mysql to mariadb as its preferred platform.
We have a relatively major client in the UK (300k+ contact records / 100 users) who has swapped in Percona as we were reaching some DB connection timeouts with Mysql. It may just be related to having a better default db config with Percona then Mysql but the issues seem to have resolved. The IT manager at the client also thinks we've seen some minor performance improvements. We've been running for about a month now without any issues.