Replacing Zend Server’s MySQL with MariaDB

MariaDB is a drop-in replacement for MySQL.

How to brew and replace Zend Server MySQL installation with MariaDB on OS X:

1. Download MariaDB using Brow

brew install mariadb

2. Move current MySQL directory out of the way

sudo /usr/local/zend/bin/zendctl.sh stop-mysql
sudo mv /usr/local/zend/mysql /usr/local/zend/mysql.old

3. Copy Cellared mariadb to Zend Server mysql. CHANGE PATH TO MARIADB to your current version.

sudo cp -R /usr/local/Cellar/mariadb/5.5.28 /usr/local/zend/mysql

4. Copy data directory from mysql.old to mysql

sudo cp -R /usr/local/zend/mysql.old/data /usr/local/zend/mysql/data

5. Chown data directory and copy the my.cnf out of the data directory and into the mysql directory

sudo chown -R _mysql /usr/local/zend/mysql
sudo mv /usr/local/zend/mysql/data/my.cnf /usr/local/zend/mysql

6. sudo Edit /usr/local/zend/mysql/my.cnf and remove `skip-locking` and/or `skip-external-locking`
7. sudo Edit the /usr/local/zend/mysql/bin/mysql.server with the datadir and basedir

basedir=/usr/local/zend/mysql
datadir=/usr/local/zend/mysql/data

8. Start mariadb

sudo /usr/local/zend/bin/zendctl.sh start-mysql