WebHosting BlogcPanel Hosting, Website Hosting, Hosting Tutorial, Hosting Tools

Running Multiple MySQL versions

bob on August 29th, 2008

If you would like to run multiple versions of MYSQL on same server without making any changes to the existing system you should follow the below steps
First download the source the tar file from mysql.com.

$> tar xfz mysql.tar.gz
$> cd mysql.XX

• Important **
  “/etc/my.cnf ” is the default file that is used by a mysql server. When the new version is tested it will load the default configuration’s in /etc/my.cnf.

To resolve this you can replace every instance of ” cnf ” inside the source folder to ” conf ” by using this following command.

find ./ -type f | xargs perl -pi -w -e 's/cnf/conf/g;'

1) The default user generally is “mysql”. Add another user and group for example mysqlt for the new version of MySQL.

2) A typical ./configure command…

   ./configure --prefix=/usr/local/mysql --enable-local-infile
   --with-tcp-port=4444 --with-mysqld-user=mysqlt
   --with-base_dir=/usr/local/mysql --with-log=/usr/local/mysql/mysqld.log
   --with-pid_file=/usr/local/mysql/mysqld.pid
    -with-unix-socket-path=/tmp/mysqlt.sock --localstatedir=/var/lib/mysqlt

The new values you will use for your new MySQL server are:

    Port number : 4444 

    mysql user : mysqlt 

    base_dir :  /usr/local/mysql 

    data directory : /var/lib/mysqlt 

    log file : /usr/local/mysql/mysqld.log

3) Compile and Install

make && make install

4) Create your new MySQL config file.

 cp support-files/my-medium.conf /etc/my.conf

  cd /usr/local/mysql 

  bin/mysql_install_db --user=mysqlt
 ( this will install all the needed databases )
  bin/mysqld_safe --user=mysqlt &

TO SET A PASSWORD FOR THE MySQL root USER

  /usr/local/mysql/bin/mysqladmin -u root -h hostname password 'new-password'

  /usr/local/mysql/bin/mysqladmin -u root password 'new-password'

5) To start the service

cd /usr/local/mysql 

./share/mysql/mysql.server start

6) To test

#telnet localhost 4444

and you should see this
Trying 127.0.0.1... 

Connected to localhost. 

Escape character is '^]'. 

+ 4.0.26-logIE^*THL

You’ve done,  now you can copy mysql.server >> rc.d to start it when the server is rebooted.
Warning: Never use two servers that update data in the same databases.

Read More Comments (3) mysql server