Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MySQL DB vs MARIA DB compatibility for PHP and Wordpress

Posted on 2016-10-13
2
Medium Priority
?
864 Views
Last Modified: 2016-11-03
My question ... Maria DB = MySQL DB?  (In terms of compatibility, aside from the whole Oracle/OpenSource/Original Authors story)
Details ...I just moved a Wordpress site and several PHP Scripts (unrelated to WP) from a web server (Linux/Apache) to a new web server (Linux/Apache).  I just found out that the new server is running Maria DB 5.5.47, whereas the old server was running MySQL DB 5.5.25.
I hit a couple of snags to get the WP site and a couple of the PHP Scripts running, so before I start posting error log results & specifics, I was wondering, in general, if anyone has had experience with Maria DB, if it should be a drop-in replacement for MySQL ... or if there is an incompatibility list of any SQL Statements that may need to be changed, etc.
0
Comment
Question by:bleggee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 total points
ID: 41842979
There is no incompatibility between MariaDB and MySQL in the community editions that you will find on web site hosting.  There are premium versions of both that have additional features.  It is more likely that you are seeing differences in the PHP version?

I maintain a couple of ecommerce sites.  We moved two from hosting with MySQL to hosting that uses MariaDB and never even noticed.  When I download the tables from the site for backups, I upload them into a MySQL server without problems.

According to this page https://en.wikipedia.org/wiki/MariaDB ,  Maria DB 5.5.47 is an older version.  But then so is my MySQL version here.  The web hosting I use has version 10.
3

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question