health monitor port and need support backup member create

[Kevin Fox]

We tried to migrate some of our mysql cluster load balancing into lbaas, but ran into a problem. The mysql cluster health checks are exposed as a http service on an alternate port.

Our config looks something like:

listen galera_rcceil_cluster
  mode tcp
  bind 172.20.0.1:3306
  balance source
  option httpchk
  option tcpka
  maxconn 8192
  fullconn 8192
  server controller1 172.20.0.2:3306 check port 9200 inter 2000 rise 2 fall 5
  server controller2 172.20.0.3:3306 backup check port 9200 inter 2000 rise 2 fall 5
  server controller3 172.20.0.4:3306 backup check port 9200 inter 2000 rise 2 fall 5

lbaas doesn't seem to support this, so tcp only checks only work. Since the mysql server can be responsive but not synchronized yet, this can cause members to come into the pool prematurely.

Thanks,
Kevin

[cheng (tangch318)]

Active/backup model is useful in some case.

[cheng (tangch318)]

@Kevin Do you means to only need an active member. and others used as backup members?

[cheng (tangch318)]

I think the http check has satisfied, but active/backup not support this case.
same issue also at https://bugs.launchpad.net/neutron/+bug/1241759

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/423772

[cheng (tangch318)]

The request need support backup and health check port options. I would like to split two independent issue. This issue will address backup options. then i will open another tick for address health monitor port options

[Michael Johnson (johnsom)]

I am going to mark this as a duplicate as both issues raised here are being tracking in other bugs.
The backup RFE is https://bugs.launchpad.net/neutron/+bug/1241759
The alternate monitoring port is: https://bugs.launchpad.net/octavia/+bug/1541579

[OpenStack Infra (hudson-openstack)]

Change abandoned by Michael Johnson (<email address hidden>) on branch: master
Review: https://review.openstack.org/423772
Reason: Abandoning this patch because it has been in merge conflict for over a year without comment. Neutron-lbaas is also now deprecated and not accepting new features.