Comments - MariaDB versus MySQL - Compatibility
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I am in the process of changing things over form MySQL to MariaDB. I am currently running MySQL 5.1.31 and have a new server that I have done a clean RPM install of MariaDB 10.0.11 . Hoping this is not too big a leap to take?
We are running Apache / PHP on separate web-servers and I would like to know if I need to change anything on them in order for them to connect properly from Apache / PHP to the MariaDB server? Not sure if I need to update or install anything on the web-servers, such as newer libmysqlclient.so.x or? If so, what RPM should I install on the web-heads and will this cause an issue with them continuing to connect to the MySQL DB server?
What I have done on the new DB server is imported a dump file of our production DB from MySQL into the new test server runningMariaDB which appears to have went good. I have already discovered that some queries that work in the MySQL DB come up empty in MariaDB. So the next question is, where can I find a list of differences/changes/deprecated items between MySQL 5.1.31 and MariaDB 10.0.11 . Or am I going to need to look at the differences noted on this page between MySQL 5.x and MariaDB 5.x and work my way towards MySQL 5.6 and MariaDB 10.0?
Thanks!!!