Answers.Body: <p>Don't overthink it, and don't go out on a limb without a worthwhile reason.  So long as MariaDB is truly a drop-in replacement for MySQL, you're fine with that.  If somehow MariaDB ceases to be compatible, you'll be able to do an export/import to MySQL, assuming you haven't upgraded your server irreversibly <em>and</em> deleted all of your backups from before then.</p>
  
  <p>As a rule of thumb, if you stick with the versions that come with the most recent couple of Ubuntu LTS releases, you'll have enough company that CiviCRM wouldn't dare leave you in the dust.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-04T08:27:23.763Z
Answers.Text: it took us about 30 min to switch from mysql to mariadb, take one, if you are not happy on how it goes at any point in the future, export, install a replacement you prefer and import.
Answers.UserDisplayName: Xavier
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-05T16:45:36.230Z
Answers.Text: I am running MariaDB on my local civicrm development environment for a year. And I haven't come across any issues.
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-05T10:37:51.927Z
Answers.Text: @Jaap Jansma-CiviCooP Well, I have. The default port config of MariaDB is the same (3306) as that of your MySQL installation. Most people running databases are doing so for its commercial benefit, not its wonderous internals. The last thing they need is breaking the functionality of their MySQL installation. But of course that is exactly what MariaDB's sales managers want - in the vain hope that we will migrate to their blue-knickered version of MySQL . . . The fools, the fools.
Answers.UserDisplayName: Trunk
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-04T01:14:34.283Z
Answers.LastActivityDate: 2015-11-04T01:14:34.283Z
Answers.UserDisplayName: Andie Hunt
Body: <p>After some reading, it appears that MariaDB could be a better challenger to MySQL and it runs, apparently, without any problems with CiviCRM (cf <a href="https://civicrm.stackexchange.com/questions/7224/civicrm-on-mariadb-instead-of-mysql">CiviCRM on MariaDB instead of mySQL</a>).</p>
  
  <p>But what about future compatibility? On the <a href="https://mariadb.com/products/product-faqs?qt-faqs=2#qt-faqs" rel="nofollow noreferrer">MariaDB FAQ</a> they say</p>
  
  <blockquote>
    <p>MariaDB 10 takes a different approach. While retaining close feature compatibility with MySQL, there are enough differences and enhancements so that it makes sense to start a new numbering scheme...</p>
  </blockquote>
  
  <p>It's possible that in a near future, there will be too many differences between MariaDB and MySQL, and the compatibility will fall in the background. It is only a supposition.</p>
  
  <p>But, will CiviCRM continue to develop only for MySQL, or could it be developed for both? Or (better for a 10-year user) for PostgreSQL? PostgreSQL, as a community driven project, is ethically closer to the Civi community than Oracle, I would think. (It's not a troll ;-)</p>
  
  <p>Alongside that, some time ago, I had seen some posts about Doctrine and Civi. Has that integration gone forward?</p>
  
  <p>In short: what DBMS would you advise for a new project with 200 000 contacts?</p>
  
Tags: <database>
Title: MySql vs MariaDB
ThreadText: # MySql vs MariaDB
  
  (Asked by: username_0 on 2015-11-03)
  
  After some reading, it appears that MariaDB could be a better challenger to MySQL and it runs, apparently, without any problems with CiviCRM (cf [CiviCRM on MariaDB instead of mySQL](https://civicrm.stackexchange.com/questions/7224/civicrm-on-mariadb-instead-of-mysql)).
  
  But what about future compatibility? On the [MariaDB FAQ](https://mariadb.com/products/product-faqs?qt-faqs=2#qt-faqs) they say
  
  > MariaDB 10 takes a different approach. While retaining close feature compatibility with MySQL, there are enough differences and enhancements so that it makes sense to start a new numbering scheme...
  
  It's possible that in a near future, there will be too many differences between MariaDB and MySQL, and the compatibility will fall in the background. It is only a supposition.
  
  But, will CiviCRM continue to develop only for MySQL, or could it be developed for both? Or (better for a 10-year user) for PostgreSQL? PostgreSQL, as a community driven project, is ethically closer to the Civi community than Oracle, I would think. (It's not a troll ;-)
  
  Alongside that, some time ago, I had seen some posts about Doctrine and Civi. Has that integration gone forward?
  
  In short: what DBMS would you advise for a new project with 200 000 contacts?
  
  **Tags:** database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-11-04. Score: 5
  
  Don't overthink it, and don't go out on a limb without a worthwhile reason. So long as MariaDB is truly a drop-in replacement for MySQL, you're fine with that. If somehow MariaDB ceases to be compatible, you'll be able to do an export/import to MySQL, assuming you haven't upgraded your server irreversibly *and* deleted all of your backups from before then.
  
  As a rule of thumb, if you stick with the versions that come with the most recent couple of Ubuntu LTS releases, you'll have enough company that CiviCRM wouldn't dare leave you in the dust.
  
  > **Comments:**
  > **username_2**: it took us about 30 min to switch from mysql to mariadb, take one, if you are not happy on how it goes at any point in the future, export, install a replacement you prefer and import.  
  > **username_3**: I am running MariaDB on my local civicrm development environment for a year. And I haven't come across any issues.  
  > **username_4**: @username_3 Jansma-username_3 Well, I have. The default port config of MariaDB is the same (3306) as that of your MySQL installation. Most people running databases are doing so for its commercial benefit, not its wonderous internals. The last thing they need is breaking the functionality of their MySQL installation. But of course that is exactly what MariaDB's sales managers want - in the vain hope that we will migrate to their blue-knickered version of MySQL . . . The fools, the fools.  
  
  ---
  
  