Answers.Body: <p>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. </p>
  
  <p>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</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-28T14:34:12.227Z
Answers.Text: I've had a similar experience, using MariaDB 5.5 for the last year and a half for a lot of sites. I've been waiting on MariaDb10 out of caution. Switching on a live server - your experience will likely depend on your OS flavour. I did hit a few gotchas in terms of the default my.cnf configuration which are different from MySQL and MariaDB.
Answers.UserDisplayName: Alan Dixon
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-23T11:11:58.700Z
Answers.LastActivityDate: 2015-10-23T11:11:58.700Z
Answers.UserDisplayName: Xavier
Answers.Body: <p>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 <a href="https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/" rel="nofollow">compatailty</a>.  Also btw Cpanel is moving from mysql to mariadb as its preferred platform.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-27T21:13:51.560Z
Answers.Text: Thanks, Can I talk with about this?  You can see my contact  info in my profile.  Send me an email.
Answers.UserDisplayName: pkeogan - BackOffice Thinking
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-26T20:34:07.303Z
Answers.LastActivityDate: 2015-10-26T20:34:07.303Z
Answers.UserDisplayName: Sonicthoughts
Answers.Body: <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-27T22:48:16.667Z
Answers.LastActivityDate: 2015-10-27T22:48:16.667Z
Answers.UserDisplayName: Jamie Novick - Compucorp
Body: <p>Has anyone run CiviCRM on MariaDB instead of mySQL</p>
  
  <p><a href="https://mariadb.org/" rel="nofollow">https://mariadb.org/</a></p>
  
  <p>Running CiviCRM on MariaDB could provide significant speed improvements. </p>
  
Tags: <database>
Title: CiviCRM on MariaDB instead of mySQL
ThreadText: # CiviCRM on MariaDB instead of mySQL
  
  (Asked by: username_0 on 2015-10-22)
  
  Has anyone run CiviCRM on MariaDB instead of mySQL
  
  <https://mariadb.org/>
  
  Running CiviCRM on MariaDB could provide significant speed improvements.
  
  **Tags:** database
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2015-10-23. Score: 3
  
  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
  
  > **Comments:**
  > **username_2**: I've had a similar experience, using MariaDB 5.5 for the last year and a half for a lot of sites. I've been waiting on MariaDb10 out of caution. Switching on a live server - your experience will likely depend on your OS flavour. I did hit a few gotchas in terms of the default my.cnf configuration which are different from MySQL and MariaDB.  
  
  ---
  
  ### Answer by username_3 on 2015-10-26. Score: 3
  
  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](https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/). Also btw Cpanel is moving from mysql to mariadb as its preferred platform.
  
  > **Comments:**
  > **username_0**: Thanks, Can I talk with about this?  You can see my contact  info in my profile.  Send me an email.  
  
  ---
  
  ### Answer by username_4 on 2015-10-27. Score: 1
  
  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.
  
  
  ---
  
  