mysql-proxy on ubuntu 7.04 feisty
Writing by corra on Monday, 20 of August , 2007 at 11:21 am
If you have an Ubuntu 7.04 Feisty Linux Distribution and you are planning to install mysql-proxy in order to test the new proxy functionalities, maybe you will have some problem. I use Ubuntu 7.04 on my laptop, with all packets installed and configured correctly using Synaptic Packet Manager and, in fact, I had problems! If you won’t have problems … well … I’m unlucky!
First of all, there is not a packetized mysql-proxy for Ubuntu, so the only way to install it is to build it from the source you can get from MySQL website.
mysql-proxy needs the LUA scripting language in order to work correctly. LUA is the milestone, the tool to write configuration scripts to instructs mysql-proxy what to do receiving packets to and from the MySQL server. LUA is the key to achieve great tasks from mysql-proxy.
mysql-proxy needs LUA version>=5.1, so, before proceding to build the software be sure to have installed on your system the packets below (use Synaptic Packet Manager to install them):
lua5.1
liblua5.1-0
liblua5.1-0-dev
liblua5.1-sql-mysql-dev
OK, now proceed as usual with the first steps
$ gunzip mysql-proxy-0.5.1.tar.gz $ tar xvf mysql-proxy-0.5.1.tar $ cd mysql-proxy-0.5.1
before configuring (./configure) you have to create a symbolic link in order for the configure script to find the correct libraries
$ ln -s /usr/lib/liblua5.1.so.0.0.0 /usr/lib/liblua.so
OK, now you can proceed to configure giving some environment variable the value below:
$ ./configure LUA_CFLAGS=”-I/usr/include/lua5.1/” LUA_LIBS=”-L/usr/lib/ -llua”
The last steps are very simple:
$ make $ make install
At this point (I hope) you have mysql-proxy installed on you Ubuntu Feisty.
Enjoy your proxy!
PS Remember the SUDO !!!
Category: MySQLen
Comment by Mats Kindahl
Made Monday, 20 of August , 2007 at 12:53 pm
Suggest you have a look at http://mysqlmusings.blogspot.com/2007/07/musings-on-mysql-proxy.html to see a slightly more streamlined version of how to bbuild the MySQL Proxy. Among other things, it avoid
the first problem I also had where I had to set the
flags manually.
Pingback by Log Buffer #59: a Carnival of the Vanities for DBAs « I’m just a simple DBA on a complex production system
Made Friday, 24 of August , 2007 at 6:02 pm
[...] Cahoon ends in his Summer of Code blog with a release of his MySQL proxy. Corra is already using MySQL Proxy on Ubuntu. Morgan Tocker and Brian “Krow” Aker try to decide how big transactions should be, and [...]
