MySQL Proxy is a simple program that sits between the client and MySQL server that can monitor, analyze or transform their communication. It is used mainly for load balancing, failover and query analysis.
Useful Links
Questions tagged [mysql-proxy]
71 questions
0
votes
2 answers
calling c functions from lua script
I found some references on this but I was not able to make them work. I have a Debian box with mysql and mysql-proxy. I am intercepting the SQL queries with the LUA script.
function read_query(packet)
if packet:byte() ~= proxy.COM_QUERY…
jordi
- 1,157
- 1
- 13
- 37
0
votes
1 answer
Proxying connection to MySQL without MySQL Proxy
MySQL Proxy sounds like the best option to proxy a connection to MySQL server in order to modify queries online except that it only supports scripts in Lua, AFAIK.
Is it possible to script MySQL Proxy behavior in languages other than Lua? Ideally,…
bazzilic
- 826
- 2
- 8
- 22
0
votes
1 answer
mysql-proxy proxy.queries:append call failing with .server_capabilities error
I'm trying to use mysql-proxy to substitute auth credentials like this:
proxy.queries:append(1,
proto.to_response_packet({
username = "connect",
response = password.scramble(s.scramble_buffer,…
u2702
- 596
- 5
- 7
0
votes
2 answers
How to log SQL errors AND warnings with a Lua script on mysql-proxy
For debug purposes, I want to log SQL errors and warnings messages returned by MySQL, and corresponding queries, at server-level.
I've found two useful Lua scripts…
berty
- 2,178
- 11
- 19
0
votes
1 answer
Performance Issues with MySQL Proxy
One of or customers has a MySQl back end as part of their solution.
They have configured it to have a common master database and a specific slave database per client (they have 10+ slaves). They are using MySQL proxy for this.
They are facing some…
user2060819
- 21
- 3
0
votes
2 answers
MySQL proxy better way to detect select query
I am using lua script
https://github.com/clofresh/mysql-proxy-cache to cache the select query.
But there is a problem with the way it is detecting select statement.
It is using following code
return query:sub(1,6):lower() == 'select'
This…
Vivek Goel
- 22,942
- 29
- 114
- 186
0
votes
1 answer
MySQL proxy HA with no need to reconnect after node failure
I use MySQL with Galera wsrep to get synchronous replication, that part it's up and running
I need to setup a kind of proxy to handle client connections. Since any node in cluster can fail, clients will not connect nodes directly, but only via…
Matthias
- 459
- 1
- 5
- 15
0
votes
1 answer
mysql-proxy 0.8.3 load balance can not work
I have three Mysql Nodes listed below:
Master Address: 192.168.1.77:3306
Slave1 Address: 192.168.1.76:3306
Slave2 Address: 192.168.1.69:3306
and after i installed mysql-proxy of version 0.8.3 on 192.168.1.67, and create my configuration…
ywenbo
- 3,051
- 6
- 31
- 46
0
votes
1 answer
Mysql: How to configure mysql proxy for an existing master-slave setup
I want to configure mysql proxy on my test environment to observe the below.
1. Behavior of the proxy
2. How load, CPU usage varies on my test server for read/write distribution.
I googled and able to install proxy on my ubuntu linux.
But I didnt…
Uday
- 1,480
- 4
- 27
- 44
-1
votes
1 answer
pause a single session but keep processing other
I want to the mysql-proxy lua script to handle interleaving accesses to a website (e.g. two different browser windows/users) but being able to pause/delay one of the two without influencing the other.Handling sessions interleavingly is possible in…
Sim
- 4,199
- 4
- 39
- 77
-1
votes
1 answer
Error: bad argument #1 to 'insert' (table expected, got nil)
I am trying to connect to a mysql server using LuaSql via a mysql proxy. I try to execute a simple program (db.lua):
require("luasql.mysql")
local _sqlEnv = assert(luasql.mysql())
local _con = nil
function read_auth(auth)
local host, port =…
robin
- 19
- 1
- 10