# Percona XtraDB Cluster - HAProxy - sysbench FAILED!

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-haproxy-sysbench-failed/4731>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 18, 2016, 10:26am UTC](https://forums.percona.com/t/percona-xtradb-cluster-haproxy-sysbench-failed/4731 "2016-02-18T10:26:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nulos](https://avatars.discourse-cdn.com/v4/letter/n/e274bd/32.png) [@nulos](https://forums.percona.com/u/nulos)\
**Post date:** [February 18, 2016, 10:26am UTC](https://forums.percona.com/t/percona-xtradb-cluster-haproxy-sysbench-failed/4731/1 "2016-02-18T10:26:09Z")

</div>

Hello,

I has 3 XtraDB Percona Server Cluster Master-Master.  
I just installed HAProxy ([url][Percona XtraDB Cluster](https://www.percona.com/doc/percona-xtradb-cluster/5.6/howtos/virt_sandbox.html%5B/url%5D)) when I make a sysbench I have the following error:

```auto
# 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.

```

```auto
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