MySQL proxy error
Posted by:
andrewa
Date: May 24, 2011 04:00PM
Hi!
I have installed MySQL proxy 08.1 on Win7/64bit machine where I have a warehouse client software, which connects to MySQL 5.0 and 5.1 DB under Fedora servers for testing.
First error I managed to solve - the path interpretation seems to be incorrect. When I start mysql-proxy I get no error message, but trying to connect from the warehouse application on Win host 192.168.1.4 to MySQL server on linux host 192.168.1.254, I get failed message:
C:\proxy\bin>mysql-proxy --admin-address=192.168.1.4:4041 --admin-username=name --admin-password=pw --admin-lua-script=/lib/mysql-proxy/lua/admin.lua --proxy-address=192.168.1.4:3306 --proxy-backend-addresses=192.168.1.254:3306 --proxy-lua-script=\lib\mysql-proxy\lua\proxy\failover.lua
2011-05-24 23:37:06: (critical) network-mysqld-lua.c:234: lua_load_file(\lib\mysql-proxy\lua\proxy\failover.lua) failed: .\lua-scope.c:241: stat(\lib\mysql-proxy\lua \proxy\failover1.lua) failed: No error (0)
By moving admin.lua and failover.lua to the base folder I got another error message:
C:\proxy\bin>mysql-proxy --admin-address=192.168.1.4:4041 --admin-username=name --admin-password=pw --admin-lua-script=admin.lua --proxy-address=192.168.1.4:3306 --proxy-backend-addresses=192.168.1.254:3306 --proxy-lua-script=failover1.lua
2011-05-24 23:38:36: ((error)) network-mysqld-packet.c.534: COM_(0x11) should be (ERR|OK), got fe
No word in Google about it, any idea?
My plans are to install MySQL proxy on all Win stations with warehouse client, then start master-master replication between 2 linux servers and achieve HA database access by the automatic switching of the clients by a failover lua script.
I have found a "simple failover" script failover.lua and its update to match the recent proxy changes.
I have no Lua socket installed on the Win host. Is my proxy installation incomplete? Are all neccessary files available in the zip file in the Download section of NySQL? Is proxy limited to 32 bit OS only?
Thanks to all responding.
Andrei
Subject
Views
Written By
Posted
MySQL proxy error
5870
May 24, 2011 04:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.