Re: R/W splitting. All requests only to write server.

[Danila Lelaev]

Hello,

I set up mysql-proxy 0.7.1 with rw-splitting.
rw-slitting.lua correspond to diff from https://code.launchpad.net/~diego-fmpwizard/mysql-proxy/bug-43424/+merge/4259

All is working, but I loss ~0,5% of the requests.
For example, I send 10000 requests to mysql-proxy, and recive ~9945:

#!/bin/bash

for ((n=1; n <= 10000; n++)) ; do
echo 'use dbname; select * from table_name;' | mysql -u dbadev -p -h host_frontend --password='secret' &
done ;

Mysql-proxy log shows the following error:
2009-07-01 16:47:41: (critical) ioctl(50, FIONREAD, ...) failed: Connection reset by peer

All backends have max_connections=1000.

How to get it's possible the lost requests?
Thanks to everybody.