Trying out MySQL5 without clobbering your MySQL4 installation

MySQL5 has come out with a bunch of new features. If you want to try out the features of MySQL5 without clobbering your MySQL4, here is the way you can do it.

Compiling and installing MySQL5

You will need to compile your own version of mysql for this to work - this way you would be able to add or remove your own features. Get the source code Now, compile it by specifying your own prefix and unix-socket-path. That will allow you to run MySQL5 without worrying about it (MySQL5) interfering with your current MySQL 4 install. I usually install any experimental software by compiling it with --prefix=/home/stormcrow/fakeroot/usr/local . The fakeroot directory is a mirror of all the directories in the / directory. You can do something like that for yourself by using the following script

for file in `find / -type d -maxdepth 2` ;
   do echo mkdir /home/stormcrow/fakeroot$file ;
done > /tmp/ 

This will give you a shell script (/tmp/ ) that you can review and then run (source /tmp/ to mirror the directories in / to your ~/fakeroot

Now back to compiling MySQL5. I compiled it this way
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/home/stormcrow/fakeroot/usr/local --enable-assembler --enable-local-infile --with-pic --with-unix-socket-path=/home/stormcrow/fakeroot/tmp/mysql5.sock --with-zlib --with-debug --with-comment --with-openssl --with-innodb --with-berkeley-db --with-example-storage-engine --with-archive-storage-engine --with-csv-storage-engine --with-federated-storage-engine --with-partition

Before you proceed further, it will be a good idea to review what the options mean that you are compiling MySQL5 with.

  1. --prefix=/home/stormcrow/fakeroot/usr/local/ - ensures that the mysql binary and libraries will reside in /home/stormcrow/fakeroot/usr/local/ .
  2. --with-unix-socket-path=/home/stormcrow/fakeroot/tmp/mysql5.sock - ensures that the socket that MySQL creates does not interfere with our current MySQL4
  3. The rest of the options are for controlling what storage engines get compiled in. I have added the --with-debug option so that I can hunt any problems I come across

After you are done compiling, do a make and make install and you will have MySQL5 installed under /home/stormcrow/fakeroot/usr/local/bin/. Remember, you do not need to be root to do any of these steps. Next, check under the support-files in the MySQL source directory - you will find a bunch of my.cnf files. Copy the one that suits your needs to =/home/stormcrow/fakeroot/etc/my.cnf. Under the [mysqld] section change the port to 3307 (again to keep it seperate from the mysql4. You will also need to run /home/stormcrow/fakeroot/usr/local/bin/mysql_install_db to init the initial set of user tables. At this point you have your MySQL5 installed and ready to run.

Starting MySQL5

Create a file in your /usr/bin/mysqld5_start with the following lines

/home/stormcrow/fakeroot/usr/local/bin/mysqld_safe --defaults-file=/home/stormcrow/fakeroot/etc/my.cnf
Do a chmod +x /usr/bin/mysqld5_start on this. The reason for creating this file is to have an easy way to start the mysql5 daemon.

Create another file /usr/bin/mysql5

/home/stormcrow/fakeroot/usr/local/bin/mysql  $*
and do a chmod +x /usr/bin/mysql5. The reason for this is to have an easy way to start mysql5 client.

Now is a good time to see if things are working properly. Try this out

stormcrow|local$ mysqld5_safe 
stormcrow|local$ Starting mysqld daemon with databases from /home/stormcrow/fakeroot/usr/local/var

stormcrow|local$ mysql5
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.3-alpha-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
| version()             |
| 5.1.3-alpha-debug-log |
1 row in set (0.17 sec)

Cool! Things are working now. If you want some dummy data to play around with, check out the world database

If you find any problems in this document, please contact me with suggestions (use the contact form)

Additional information