Hi, I'm trying to use HAProxy as round robin load balancer for 2 MySQL
servers. I'm using mysqlslap for benchmarking.
At the moment I figured that load balanced connection is slowest in times. I need explanation from HAProxy experts why ?
There is my config:
cat /etc/haproxy/haproxy.cfg
global
maxconn 2000
pidfile /var/run/haproxy.pid
user _haproxy
group _haproxy
defaults
retries 3
maxconn 2000
contimeout 5000
clitimeout 50000
srvtimeout 50000
listen MySQL 192.168.100.254:3306
mode tcp
balance roundrobin
option persist
server mysql1 192.168.100.131:3306
server mysql2 192.168.100.132:3306
*There is my test results:*
HA Proxy Load balancer QUERY1
mysqlslap -u root --password=password -a -h 192.168.100.254 Benchmark
Average number of seconds to run all queries: 0.125 seconds
Minimum number of seconds to run all queries: 0.125 seconds
Maximum number of seconds to run all queries: 0.125 seconds
Number of clients running queries: 1
Average number of queries per client: 0
HA Proxy Load balancer QUERY2
mysqlslap -u root --password=password -a -h 192.168.100.254 Benchmark
Average number of seconds to run all queries: 0.125 seconds
Minimum number of seconds to run all queries: 0.125 seconds
Maximum number of seconds to run all queries: 0.125 seconds
Number of clients running queries: 1
Average number of queries per client: 0
MySQL SERVER1
mysqlslap -u root --password=password -a -h 192.168.100.131 Benchmark
Average number of seconds to run all queries: 0.015 seconds
Minimum number of seconds to run all queries: 0.015 seconds
Maximum number of seconds to run all queries: 0.015 seconds
Number of clients running queries: 1
Average number of queries per client: 0
MySQL SERVER2
mysqlslap -u root --password=password -a -h 192.168.100.132
Benchmark
Average number of seconds to run all queries: 0.015 seconds
Minimum number of seconds to run all queries: 0.015 seconds
Maximum number of seconds to run all queries: 0.015 seconds
Number of clients running queries: 1
Average number of queries per client: 0
--- Thanks! Evgeniy SudyrReceived on 2009/08/07 16:54
This archive was generated by hypermail 2.2.0 : 2009/08/07 17:00 CEST