P
P
Puma Thailand2012-11-26 11:53:35
MySQL
Puma Thailand, 2012-11-26 11:53:35

Is mysql-proxy working fine with rw-splitting.lua for anyone?

Testing it with sysbench
Tried mysql-proxy 0.8.1 and 0.8.2 with mysql-server 5.1 and 5.5
Everything fails on this test
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 the 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.
I run
/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 and mysql logs are empty.
Without --proxy-lua-script=/root/rw-splitting.lua everything works fine.
default mysql config
[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

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question