Parsing MySQL Proxy Lua installation Configuration

MySQL Proxy LuaThe installation configuration is described in this article.MySQL ProxyThe installation of the binary version of is relatively simple. You do not need to talk about it. The following describes how to install the source code:

Install pkg-config:

 
 

  
  
tar zxvf pkg-config-0.23.tar.gz  
  
  
cd pkg-config-0.23  
  
  
./configure  
  
  
make  
  
  
make install 
 
 

Make sure that the PKG_CONFIG_PATH environment variable contains the relevant pkg-config configuration file path:

 
 

  
  
export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/lib/pkgconfig 
 
 

Install libevent:

 
 

  
  
tar zxvf libevent-1.4.10-stable.tar.gz  
  
  
cd libevent-1.4.10-stable  
  
  
./configure  
  
  
make  
  
  
make install 
 
 

Install glib:

 
 

  
  
tar zxvf glib-2.20.0.tar.gz  
  
  
cd glib-2.20.0  
  
  
./configure  
  
  
make  
  
  
make install 
 
 

Install lua:

 
 

  
  
tar zxvf lua-5.1.4.tar.gz  
  
  
cd lua-5.1.4 
 
 

If your server is 64-bit, adjust Makefile: vi src/Makefile and add-fPIC to CFLAGS; otherwise, an error occurs:

 
 

  
  
/usr/bin/ld: /usr/local/lib/liblua.a(lapi.o):  
  
  
relocation R_X86_64_32 against `luaO_nilobject_' can not be used when making a shared object;  
  
  
recompile with -fPIC  
  
  
/usr/local/lib/liblua.a: could not read symbols: Bad value 
 
 

Next, you do not need to execute common configure, and make directly:

 
 

  
  
make linux  
  
  
make install 
 
 

Install the pkg-config configuration file so that lua can be found during MySQL Proxy Compilation:

 
 

  
  
cp etc/lua.pc /usr/local/lib/pkgconfig/lua5.1.pc 
 
 

If you do not perform this step, you will get an error message similar to the following when compiling and installing MySQL Proxy later:

 
 

  
  
Package lua5.1 was not found in the pkg-config search path.  
  
  
Perhaps you should add the directory containing `lua5.1.pc'  
  
  
to the PKG_CONFIG_PATH environment variable  
  
  
No package 'lua5.1' found 
 
 

Install mysql:

Here we will introduce the complete installation of mysql. In fact, you only need to install the mysql development kit.

 
 

  
  
tar zxvf mysql-5.1.33.tar.gz  
  
  
cd tar zxvf mysql-5.1.33  
  
  
./configure  
  
  
make  
  
  
make install  
  
  
cp support-files/mysql.server /etc/init.d/mysql  
  
  
chown +x /etc/init.d/mysql  
  
  
cp support-files/my-[small|medium|large|huge|innodb-heavy-4G].cnf /etc/my.cnf 
 
 

If the skip-federated option exists in my. cnf, comment it out. Otherwise, an error similar to the following occurs during database installation:

 
 

  
  
[ERROR] /usr/local/libexec/mysqld: unknown option '--skip-federated'  
  
  
 
  
  
/usr/local/bin/mysql_install_db --user=mysql 
  
  
/usr/local/bin/mysqld_safe --user=mysql & 
 
 

Ensure that the system can find mysql_config, which will be used in MySQL Proxy compilation later:

 
 

  
  
export PATH=$PATH:/usr/local/bin 
 
 

Make sure that the system can find the mysql database file:

Add vi/etc/ld. so. conf to the/usr/local/lib directory.

Run:/sbin/ldconfig/etc/ld. so. conf

Install MySQL Proxy:

 
 

  
  
tar zxvf MySQL Proxy-0.7.0.tar.gz  
  
  
cd MySQL Proxy-0.7.0  
  
  
./configure  
  
  
make  
  
  
make install 
 
 

Follow the official introduction to prepare the startup script/etc/init. d/MySQL Proxy and parameter script/etc/sysconfig/MySQL Proxy, and set:

 
 

  
  
chmod +x /etc/init.d/MySQL Proxy  
  
  
chkconfig --add MySQL Proxy 
 
 

Done. Test:/usr/local/sbin/MySQL Proxy-V. There are many discussions in the official forum. For more information, see.

Note: whether your operating system is 32-bit or 64-bit

I use MySQL Proxy on a 32-bit server, and it feels very unstable. Sometimes errors occur:

 
 

  
  
Lost connection to server during query，MySQL server has gone away 
 
 

At this time, the MySQL Proxy process will often fail and the following error will also be reported:

 
 

  
  
network-mysqld-proxy.c.3318: COM_(0x03), packet 4 should not be (NULL|EOF), got: fffffffe 
 
 

After switching to a 64-bit server, the stability is greatly improved. Therefore, if you want to use MySQL Proxy in the product environment, we strongly recommend that you use 64-bit.

As for the MySQL Proxy version selection, it is best to install MySQL Proxy in each version. It is not necessarily the higher the version, the more stable it is. If MySQL Proxy is used for read/write splitting, the most stable version is 0.6.X and 0.7.X on a 64-bit server.) Of course, this conclusion does not necessarily apply to you. You 'd better test it yourself.

Supplement: the official website seems to be retained only.MySQL ProxyTo download the latest version.

Summary: About AnalysisMySQL Proxy LuaThe content of the installation configuration is complete. I hope this article will help you!