Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

creating multiple instances

Hi Guys, Having weird problem I suspect is related to HAproxy. My set up:

2 Haproxy doing the load balancing 2 controllers 3 mariaDB servers clustered.

Everything is working properly except when I try to create multiple instances at once. If I create 1, 2 , or 3 instances at one time everything works perfect, but creating 5 or more keeps throwing DB lock errors.

My HaProxy Config:

global
        chroot  /var/lib/haproxy
        user haproxy
        group haproxy
        daemon
        log 10.1.0.4 local0
        stats socket /var/lib/haproxy/stats
        pidfile /var/run/haproxy.pid
        maxconn 5000
        tune.bufsize 32000

defaults
        log     global
        mode    http
        option  httplog
        option  dontlognull
        option  redispatch
        contimeout 5000
        clitimeout 50000
        srvtimeout 50000
        errorfile 400 /etc/haproxy/errors/400.http
        errorfile 403 /etc/haproxy/errors/403.http
        errorfile 408 /etc/haproxy/errors/408.http
        errorfile 500 /etc/haproxy/errors/500.http
        errorfile 502 /etc/haproxy/errors/502.http
        errorfile 503 /etc/haproxy/errors/503.http
        errorfile 504 /etc/haproxy/errors/504.http

listen galera   10.1.0.2:3306
        balance source
        mode    tcp
        option  tcpka
        option  mysql-check user haproxy
        server  cwtrdb001 10.1.0.7:3306 check weight 1
        server  cwtrdb002 10.1.0.8:3306 check weight 1
        server  cwtrdb003 10.1.0.16:3306 check weight 1

creating multiple instances

Hi Guys, Having weird problem I suspect is related to HAproxy.

My set up:

2 Haproxy servers doing the load balancing balancing.
2 controllers controllers.
3 mariaDB servers clustered.

Everything is working properly except when I try to create multiple instances at once. If I create 1, 2 , or 3 instances at one time everything works perfect, but creating 5 or more keeps throwing DB lock errors.

My HaProxy Config:

global
        chroot  /var/lib/haproxy
        user haproxy
        group haproxy
        daemon
        log 10.1.0.4 local0
        stats socket /var/lib/haproxy/stats
        pidfile /var/run/haproxy.pid
        maxconn 5000
        tune.bufsize 32000

defaults
        log     global
        mode    http
        option  httplog
        option  dontlognull
        option  redispatch
        contimeout 5000
        clitimeout 50000
        srvtimeout 50000
        errorfile 400 /etc/haproxy/errors/400.http
        errorfile 403 /etc/haproxy/errors/403.http
        errorfile 408 /etc/haproxy/errors/408.http
        errorfile 500 /etc/haproxy/errors/500.http
        errorfile 502 /etc/haproxy/errors/502.http
        errorfile 503 /etc/haproxy/errors/503.http
        errorfile 504 /etc/haproxy/errors/504.http

listen galera   10.1.0.2:3306
        balance source
        mode    tcp
        option  tcpka
        option  mysql-check user haproxy
        server  cwtrdb001 10.1.0.7:3306 check weight 1
        server  cwtrdb002 10.1.0.8:3306 check weight 1
        server  cwtrdb003 10.1.0.16:3306 check weight 1

creating multiple instances

Hi Guys, Having weird problem I suspect is related to HAproxy.

My set up:

up:
Running IceHouse and Ubuntu 14.04
2 Haproxy servers doing the load balancing.
2 controllers.
3 mariaDB servers clustered.

Everything is working properly except when I try to create multiple instances at once. If I create 1, 2 , or 3 instances at one time everything works perfect, but creating 5 or more keeps throwing DB lock errors.

My HaProxy Config:

global
        chroot  /var/lib/haproxy
        user haproxy
        group haproxy
        daemon
        log 10.1.0.4 local0
        stats socket /var/lib/haproxy/stats
        pidfile /var/run/haproxy.pid
        maxconn 5000
        tune.bufsize 32000

defaults
        log     global
        mode    http
        option  httplog
        option  dontlognull
        option  redispatch
        contimeout 5000
        clitimeout 50000
        srvtimeout 50000
        errorfile 400 /etc/haproxy/errors/400.http
        errorfile 403 /etc/haproxy/errors/403.http
        errorfile 408 /etc/haproxy/errors/408.http
        errorfile 500 /etc/haproxy/errors/500.http
        errorfile 502 /etc/haproxy/errors/502.http
        errorfile 503 /etc/haproxy/errors/503.http
        errorfile 504 /etc/haproxy/errors/504.http

listen galera   10.1.0.2:3306
        balance source
        mode    tcp
        option  tcpka
        option  mysql-check user haproxy
        server  cwtrdb001 10.1.0.7:3306 check weight 1
        server  cwtrdb002 10.1.0.8:3306 check weight 1
        server  cwtrdb003 10.1.0.16:3306 check weight 1