How can I subscribe to the mysql-proxy mailing ?

Hi,
please join the mysql-proxy-discuss team, and you will get into the mailing list.
https://edge.launchpad.net/~mysql-proxy-discuss

Giuseppe

hi Kay,

I have ben using mysql-proxy 0.6.1 alpha version for load balancing and testing mysql replication the only issue is that in case of a failure in any of the master nodes the mysql proxy fails with the familiar ERROR: 2013.

I have read through the bug and it seems that updating to a better revision of mysql proxy is the only choice.

Since you are active develper of this project could you kindly provide some links for downloading the latest release of mysql-proxy in which the failover bug has been resolved

I needed it very urgently

also,

i cannot seem to get the SVN download from this site as it doesnot configure soccessfully on my os i. CentOS

Thanks in advance

Veneet

Hi Veneet,
We do not have binaries right now for the 0.7.0 proxy, but you can download the source from here

https://code.launchpad.net/~mysql-proxy-developers/mysql-proxy/trunk

and compile it yourself.

The SVN repository is out of date and should not be used any more.

Hi

fmpwizard wrote:
> Question #58950 on MySQL Proxy changed:
> https://answers.edge.launchpad.net/mysql-proxy/+question/58950
>
> fmpwizard proposed the following answer:
> Hi Veneet,
> We do not have binaries right now for the 0.7.0 proxy, but you can download the source from here
>
> https://code.launchpad.net/~mysql-proxy-developers/mysql-proxy/trunk
>
> and compile it yourself.
>
> The SVN repository is out of date and should not be used any more.
>
>

Thanks for the prompt reply

Ihave downloaded the latest source and when i try to compile it get a
lot of errros

I am using CentOS and the issue is when i make the source get a lot of
errors like

*Making install in cmake*
make[1]: Entering directory `/usr/local/src/mysql-proxy/cmake'
make[2]: Entering directory `/usr/local/src/mysql-proxy/cmake'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/local/src/mysql-proxy/cmake'
make[1]: Leaving directory `/usr/local/src/mysql-proxy/cmake'
Making install in src
make[1]: Entering directory `/usr/local/src/mysql-proxy/src'
make install-am
make[2]: Entering directory `/usr/local/src/mysql-proxy/src'
/bin/sh ../libtool --tag=CC --mode=link gcc -g -O2 -o mysql-binlog-dump
mysql_binlog_dump-mysql-binlog-dump.o -L/usr/local/lib -Wl,-rpath
/usr/local/lib -lglib-2.0 -Wl,--export-dynamic -L/usr/local/lib
-lgmodule-2.0 -lglib-2.0 libmysql-chassis.la -pthread -L/usr/local/lib
-lgthread-2.0 -lrt -lglib-2.0 libmysql-proxy.la
gcc -g -O2 -o .libs/mysql-binlog-dump
mysql_binlog_dump-mysql-binlog-dump.o -Wl,-rpath /usr/local/lib
-Wl,--export-dynamic -pthread -L/usr/local/lib
./.libs/libmysql-chassis.so /usr/local/lib/libgthread-2.0.so -lpthread
-lrt ./.libs/libmysql-proxy.so
/usr/local/src/mysql-proxy/src/.libs/libmysql-chassis.so -lm -levent
/usr/local/lib/libgmodule-2.0.so -ldl /usr/local/lib/libglib-2.0.so
-Wl,--rpath -Wl,/usr/local/lib/mysql-proxy -Wl,--rpath -Wl,/usr/local/lib
./.libs/libmysql-proxy.so: undefined reference to `lua_getmetatable'
./.libs/libmysql-proxy.so: undefined reference to `luaL_typerror'
./.libs/libmysql-chassis.so: undefined reference to `lua_getfield'
./.libs/libmysql-chassis.so: undefined reference to `lua_isstring'
./.libs/libmysql-proxy.so: undefined reference to `lua_setmetatable'
./.libs/libmysql-chassis.so: undefined reference to `lua_pushstring'
./.libs/libmysql-chassis.so: undefined reference to `lua_atpanic'
./.libs/libmysql-chassis.so: undefined reference to `lua_getstack'
./.libs/libmysql-chassis.so: undefined reference to `lua_tonumber'
./.libs/libmysql-chassis.so: undefined reference to `lua_createtable'
./.libs/libmysql-chassis.so: undefined reference to `luaL_openlibs'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushnumber'
./.libs/libmysql-chassis.so: undefined reference to `lua_getinfo'
./.libs/libmysql-chassis.so: undefined reference to `lua_isnumber'
./.libs/libmysql-chassis.so: undefined reference to `lua_pushinteger'
./.libs/libmysql-proxy.so: undefined reference to `lua_settable'
./.libs/libmysql-proxy.so: undefined reference to `lua_xmove'
./.libs/libmysql-proxy.so: undefined reference to `lua_rawgeti'
./.libs/libmysql-chassis.so: undefined reference to `lua_newstate'
./.libs/libmysql-proxy.so: undefined reference to `luaL_checklstring'
./.libs/libmysql-proxy.so: undefined reference to `lua_touserdata'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushlightuserdata'
./.libs/libmysql-chassis.so: undefined reference to `lua_pcall'
./.libs/libmysql-proxy.so: undefined reference to `lua_getfenv'
./.libs/libmysql-proxy.so: undefined reference to `luaL_unref'
./.libs/libmysql-chassis.so: undefined reference to `lua_settop'
./.libs/libmysql-chassis.so: undefined reference to `lua_toboolean'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushvalue'
./.libs/libmysql-proxy.so: undefined reference to `lua_rawseti'
./.libs/libmysql-proxy.so: undefined reference to `lua_newuserdata'
./.libs/libmysql-chassis.so: undefined reference to `lua_load'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushboolean'
./.libs/libmysql-chassis.so: undefined reference to `lua_type'
./.libs/libmysql-proxy.so: undefined reference to `lua_tointeger'
./.libs/libmysql-chassis.so: undefined reference to `lua_setfield'
./.libs/libmysql-proxy.so: undefined reference to `luaL_register'
./.libs/libmysql-chassis.so: undefined reference to `lua_gettop'
./.libs/libmysql-chassis.so: undefined reference to `lua_next'
./.libs/libmysql-proxy.so: undefined reference to `luaL_argerror'
./.libs/libmysql-chassis.so: undefined reference to `lua_close'
./.libs/libmysql-chassis.so: undefined reference to `lua_tolstring'
./.libs/libmysql-chassis.so: undefined reference to `lua_remove'
./.libs/libmysql-proxy.so: undefined reference to `lua_setfenv'
./.libs/libmysql-proxy.so: undefined reference to `lua_gettable'
./.libs/libmysql-chassis.so: undefined reference to `lua_typename'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushcclosure'
./.libs/libmysql-proxy.so: undefined reference to `luaL_checktype'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushlstring'
./.libs/libmysql-proxy.so: undefined reference to `luaL_error'
./.libs/libmysql-proxy.so: undefined reference to `luaL_checkinteger'
./.libs/libmysql-chassis.so: undefined reference to `lua_pushnil'
./.libs/libmysql-proxy.so: undefined reference to `luaL_ref'
./.libs/libmysql-proxy.so: undefined reference to `lua_newthread'
collect2: ld returned 1 exit status
make[2]: *** [mysql-binlog-dump] Error 1
make[2]: Leaving directory `/usr/local/src/mysql-proxy/src'
make[1]: *** [install] Error 2
make[1]: Leaving directory `/usr/local/src/mysql-proxy/src'
make: *** [install-recursive] Error 1

can you kindly suggest for reasons for the same ...

Thanks

*Veneet Raina*
Software Engineer
TechnologyBlueprint pvt Ltd.
Gurgaon-122016** **
Email: <email address hidden> <mailto:<email address hidden>>

/" We are what we repeatedly do,Excellence,then,is not an act,but a
Habit " -Aristotle/ **

Hi Veneet,
I think you should install Lua 5.1 first, and then follow these steps:
http://forge.mysql.com/wiki/MySQL_Proxy_Compiling#Compiling_in_RedHat_Enterprise_5

Hi Joshua

Joshua Zhu wrote:
> Question #58950 on MySQL Proxy changed:
> https://answers.launchpad.net/mysql-proxy/+question/58950
>
> Joshua Zhu proposed the following answer:
> Hi Veneet,
> I think you should install Lua 5.1 first, and then follow these steps:
> http://forge.mysql.com/wiki/MySQL_Proxy_Compiling#Compiling_in_RedHat_Enterprise_5
>
>

Thanks for the prompt reply.

 it seems that i have lua 5.1.4 installed on my CentOS PC

 But i still get this error and

  i had seen this link you mentioned and followed the same steps.

  i get these errors specifically on the mysql binlog dump files
compilation.

 i tried googling for it but no way out for me rite now.

is there any way of getting the compiled source for CentOS ?

Thanks again

*Veneet Raina*
Software Engineer
TechnologyBlueprint pvt Ltd.
Gurgaon-122016** **
Email: <email address hidden> <mailto:<email address hidden>>

/" We are what we repeatedly do,Excellence,then,is not an act,but a
Habit " -Aristotle/ **

Sorry, I didn't notice those instructions were a little bit out of date.
The key is telling pkg-config where the libraries are. So, let's do it again:

1) Lua:
$ cd lua-5.1.4
$ make linux
# make install
# cp etc/lua.pc /usr/local/lib/pkgconfig/

2) GLib:
$ cd glib-2.18.4
$ ./configure
$ make
# make install

3) The PKG_CONFIG_PATH environment variable:
# export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/lib/pkgconfig

4) Compile and install MySQL Proxy:
$ cd mysql-proxy
$ ./autogen.sh
$ ./configure
$ make
# make install

P.S. I'll write a full tutorial on this issue and update the documentation on forge.mysql.com.

Hi Veneet,
Please see my blog post for more details:
http://blog.zhuzhaoyuan.com/2009/02/how-to-compile-and-install-mysql-proxy-from-bazaar-on-centos-52/

Thanks Kay Roepke, that solved my question.

Hi Joshua,
I got the same error when compiling mysql-proxy0.8.1. Some informations below:

CentOS release 5.3 (Final), mysql-cluster-gpl-7.1.5

installing steps:

yum install readline readline-devel -y
lua-5.1.4: make linux && make install

yum install gettext gettext-devel -y
glib-2.22.2: ./configure --with-pcre && make && make install

export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/lib/pkgconfig
mysql-proxy: LUA_CFLAGS="-I/usr/local/include" LUA_LIBS="-L/usr/local/lib -llua -ldl" LDFLAGS="-lm" LUA_CFLAGS="/usr/local/bin/lua" LUA_LIBS="/usr/local/lib/lua" ./configure --prefix=/usr/local/mysql-proxy --with-lua --with-mysql=/usr/local/mysql/bin/mysql_config && make && make install

Compile Error:
./.libs/libmysql-proxy.so: undefined reference to `lua_getmetatable'
./.libs/libmysql-proxy.so: undefined reference to `luaL_typerror'
./.libs/libmysql-chassis.so: undefined reference to `lua_getfield'
./.libs/libmysql-chassis.so: undefined reference to `lua_isstring'
./.libs/libmysql-proxy.so: undefined reference to `lua_setmetatable'
./.libs/libmysql-chassis.so: undefined reference to `lua_pushstring'
./.libs/libmysql-chassis.so: undefined reference to `lua_atpanic'
./.libs/libmysql-chassis.so: undefined reference to `lua_getstack'
./.libs/libmysql-chassis.so: undefined reference to `lua_tonumber'
./.libs/libmysql-chassis.so: undefined reference to `luaL_newstate'
./.libs/libmysql-chassis.so: undefined reference to `lua_createtable'
./.libs/libmysql-chassis.so: undefined reference to `luaL_openlibs'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushnumber'
./.libs/libmysql-chassis.so: undefined reference to `lua_getinfo'
./.libs/libmysql-chassis.so: undefined reference to `lua_isnumber'
./.libs/libmysql-chassis.so: undefined reference to `lua_pushinteger'
./.libs/libmysql-proxy.so: undefined reference to `lua_settable'
./.libs/libmysql-proxy.so: undefined reference to `lua_xmove'
./.libs/libmysql-proxy.so: undefined reference to `lua_rawgeti'
./.libs/libmysql-chassis.so: undefined reference to `lua_newstate'
./.libs/libmysql-proxy.so: undefined reference to `luaL_checklstring'
./.libs/libmysql-proxy.so: undefined reference to `lua_touserdata'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushlightuserdata'
./.libs/libmysql-chassis.so: undefined reference to `lua_pcall'
./.libs/libmysql-proxy.so: undefined reference to `lua_getfenv'
./.libs/libmysql-proxy.so: undefined reference to `luaL_unref'
./.libs/libmysql-chassis.so: undefined reference to `lua_settop'
./.libs/libmysql-chassis.so: undefined reference to `lua_toboolean'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushvalue'
./.libs/libmysql-proxy.so: undefined reference to `lua_rawseti'
./.libs/libmysql-proxy.so: undefined reference to `lua_newuserdata'
./.libs/libmysql-chassis.so: undefined reference to `lua_load'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushboolean'
./.libs/libmysql-chassis.so: undefined reference to `lua_type'
./.libs/libmysql-proxy.so: undefined reference to `lua_tointeger'
./.libs/libmysql-chassis.so: undefined reference to `lua_setfield'
./.libs/libmysql-proxy.so: undefined reference to `luaL_register'
./.libs/libmysql-chassis.so: undefined reference to `lua_gettop'
./.libs/libmysql-chassis.so: undefined reference to `lua_next'
./.libs/libmysql-proxy.so: undefined reference to `luaL_argerror'
./.libs/libmysql-chassis.so: undefined reference to `lua_close'
./.libs/libmysql-chassis.so: undefined reference to `lua_tolstring'
./.libs/libmysql-chassis.so: undefined reference to `lua_remove'
./.libs/libmysql-proxy.so: undefined reference to `lua_setfenv'
./.libs/libmysql-proxy.so: undefined reference to `lua_gettable'
./.libs/libmysql-chassis.so: undefined reference to `lua_typename'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushcclosure'
./.libs/libmysql-proxy.so: undefined reference to `luaL_checktype'
./.libs/libmysql-proxy.so: undefined reference to `lua_pushlstring'
./.libs/libmysql-proxy.so: undefined reference to `luaL_error'
./.libs/libmysql-proxy.so: undefined reference to `luaL_checkinteger'
./.libs/libmysql-chassis.so: undefined reference to `lua_pushnil'
./.libs/libmysql-proxy.so: undefined reference to `luaL_ref'
./.libs/libmysql-proxy.so: undefined reference to `lua_newthread'
collect2: ld returned 1 exit status
make[3]: *** [mysql-binlog-dump] error 1
make[3]: Leaving directory `/opt/mysql-proxy-0.8.1/src'
make[2]: *** [all] error 2
make[2]: Leaving directory `/opt/mysql-proxy-0.8.1/src'
make[1]: *** [all-recursive] error 1
make[1]: Leaving directory `/opt/mysql-proxy-0.8.1'
make: *** [all] error 2

any idea!!! thanks!!

Hi all

i slove it. So sorry!!!

./configure LDFLAGS="-lm -ldl" LUA_CFLAGS="/usr/local/bin/lua -I/usr/local/include/" LUA_LIBS="/usr/local/lib/ -llua" --prefix=/usr/local/mysql-proxy --with-lua --with-mysql=/usr/local/mysql/bin/mysql_config && make && make install

um...
# bin/mysql-proxy -V
mysql-proxy 0.8.1
  chassis: mysql-proxy 0.8.1
  glib2: 2.22.2
  libevent: 1.4.13-stable
  LUA: Lua 5.1.4
    package.path: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.lua
    package.cpath: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.so
-- modules
  admin: 0.8.1
  proxy: 0.8.1

thanks!!!