Тестирую его с помощью 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
-
Вопрос задан
-
3143 просмотра
