Can MySQL seamlessly be replaced with MariaDB or are there things to change in this case?

php mysql jdbc mariadb
Ivan picture Ivan · Nov 5, 2010 · Viewed 38.8k times · Source

If I replace a MySQL 5.1 server with a MariaDB Server (Maria & XtraDB storages) instead of MySQL (MyISAM & InnoDB), will most of MySQL client software (incl. applications made with PHP 5.2 and Java SE 1.6) ...

  1. just remain working without any changes (with minor regressions maybe)?
  2. Or will I have to replace/reconfigure client drivers (like use another JDBC driver class and connection string)?
  3. Or will I have even to change application code?

Answer

Qwerty picture Qwerty · Nov 5, 2010

http://kb.askmonty.org/v/mariadb-versus-mysql

All MySQL connectors (PHP, Perl, Python, Java, MyODBC, Ruby, MySQL C connector etc) works unchanged with MariaDB.

Related questions

How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
PDOException “could not find driver”

I have just installed Debian Lenny with Apache, MySQL, and PHP and I am receiving a PDOException could not find driver. This is the specific line of code it is referring to: $dbh = new PDO('mysql:host=' . DB_HOST . …

Read More