Hello,
I has 3 XtraDB Percona Server Cluster Master-Master.
I just installed HAProxy ([url]Percona XtraDB Cluster) when I make a sysbench I have the following error:
# sysbench --test=oltp --db-driver=mysql --mysql-engine-trx=yes --mysql-table-engine=innodb --mysql-host=127.0.0.1 --mysql-port=3307 --mysql-user=sbtest --mysql-password=sbpass --oltp-table-size=10000 --num-threads=8 run
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 8
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 10000
Threads started!
ALERT: failed to execute mysql_stmt_execute(): Err1317 Query execution was interrupted
FATAL: database error, exiting...
Done.
HAProxy config:
frontend pxc-front
bind *:3307
mode tcp
default_backend pxc-back
backend pxc-back
mode tcp
balance leastconn
option httpchk
server sql01 10.0.11.1:3306 check port 9200 inter 12000 rise 3 fall 3
server sql02 10.0.11.2:3306 check port 9200 inter 12000 rise 3 fall 3
server sql03 10.0.11.3:3306 check port 9200 inter 12000 rise 3 fall 3
HAProxy doesn’t with Percona XtraDB Cluster master-master ?
Thank you for your help