Tuesday, October 9, 2012

Multiple mysql engines on the same server

Someone asked me for a howto on setting up multiple mysql engines on the same linux server. There are many articles on the topic, but none provides an ready-to-use set of files which one can simply grab and go.

Thus I created multiple_mysql.tar.gz file that includes all files to run four mysql engines. The configuration assumes per-database directories /opt/db-330[4567] with bin_log, mysql  and relay_log directories. The mysql directory must have mysql database with associated tables (should be copied from an existing database).

Note that the files were created on Ubuntu Lucid 10.04 and will likely not work on other distro. Also, the password in debian-330?.cnf files will be different for each DB and must be updated before use.
Use the following command to set the password:
GRANT ALL ON mysql.* to "debian-sys-maint"@"localhost" IDENTIFIED BY "dxaskDkdkSkdSDLd";

The bashrc file contains useful CLI shortcuts to common mysql commands. You are encouraged to add these to your own .bashrc file.

2 comments:

shlominoach said...

Hi,

One's easiest way of installing multiple MySQL servers is by using the mysqlsandbox utility - it is a mature and very popular tool.

Otherwise please see <a href="http://code.openark.org/blog/mysql/manually-installing-multiple-mysql-instances-on-linux-howto>my post</a> on this.

Arie Skliarouk said...

mysqlsandbox looks good and probably fits better for serious mysql hosters. My files are more of an one-off quick band-aid for me.

Thanks for the pointer to mysqlsandbox though! I hope to use it one day.