У кого нибудь работает нормально mysql-proxy с rw-splitting.lua?

Question

[Пума Тайланд]

Тестирую его с помощью sysbench

Пробовал mysql-proxy 0.8.1 и 0.8.2 с mysql-server 5.1 и 5.5


Все валится на таком тесте


sysbench --num-threads=2 --max-requests=500 --oltp-table-size=10000 --mysql-db=vpnpeople --mysql-user=web-app --mysql-password=xiemai1IEighix5cEeh4Acae --mysql-host=ip_mysqlproxy --mysql-port=3307 --db-driver=mysql --test=oltp run

sysbench 0.4.12: multi-threaded system evaluation benchmark


Running the test with following options:

Number of threads: 2


Doing OLTP test.

Running mixed OLTP test

Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)

Using «BEGIN» for starting transactions

Using auto_inc on the id column

Maximum number of requests for OLTP test is limited to 500

Threads started!

ALERT: failed to execute mysql_stmt_execute(): Err1243 Unknown prepared statement handler (9) given to mysqld_stmt_execute

FATAL: database error, exiting…

ALERT: failed to execute mysql_stmt_execute(): Err1210 Incorrect arguments to mysqld_stmt_execute

FATAL: database error, exiting…

Done.


Запускаю вот так

/usr/bin/mysql-proxy --proxy-lua-script=/root/rw-splitting.lua --proxy-address=0.0.0.0:3307 --proxy-backend-addresses=ip_mysqlserver1:3306 --proxy-read-only-backend-addres

ses=ipmysqlserver2:3306 --log-file=/var/log/mysql-proxy.log --log-level=debug --daemon


В логах mysql-proxy и mysql пусто.


Без --proxy-lua-script=/root/rw-splitting.lua работает все нормально.


Конфиг mysql дефолтный

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0


[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid