Ask Your Question

Revision history [back]

Running a sql cluster in active/active for Openstack behind a LB wont work very well. You will get lock errors for most operations.

Configure HA proxy to do active/backup for you sql cluster and the problems will go away.

Openstack needs some work done around DB transactions locking for you to be able to write to multiple DB nodes at the same time.

Haproxy galera config:

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 backup weight 1 server cwtrdb003 10.1.0.16:3306 backup weight 1

Once you make that change you will be able to spin up any number of instances you want.

Running a sql cluster in active/active for Openstack behind a LB wont work very well. You will get lock errors for most operations.

Configure HA proxy to do active/backup for you sql cluster and the problems will go away.

Openstack needs some work done around DB transactions locking for you to be able to write to multiple DB nodes at the same time.

Haproxy galera config:

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 backup weight 1
        server  cwtrdb003 10.1.0.16:3306 backup weight 1

1

Once you make that change you will be able to spin up any number of instances you want.