I am having some issues creating a route in OpenShift to the haproxy LB. For the time being I would like to be able to use an on-prem app to utilize the percona mysql database created with the openshift operator. I tried to set up the cr.yaml file with the configuration as such…My db pods start up just fine but the haproxy pods fail in crashloopbackoff
configuration: |
global
maxconn 2048
external-check
stats socket /var/run/haproxy.sock mode 600 expose-fd listeners level user
defaults
log global
mode tcp
retries 10
timeout client 28800s
timeout connect 100500
timeout server 28800s
frontend galera-in
bind *:3309 accept-proxy
bind *:3306 accept-proxy
mode tcp
option clitcpka
default_backend galera-nodes
frontend galera-replica-in
bind *:3307
mode tcp
option clitcpka
default_backend galera-replica-nodes
1 Like
My service is fine…It is defined in openshift as a Cluster IP that is accessible within the cluster only. I created a route using the haproxy service in openshift but I can’t seem to connect to it in anyway. I typically try mysql workbench or something like that.
1 Like
Hi Rob
It looks like you’ve faced two separate issues at a time.
As for haproxy crash, please post some log output here. Maybe we would get something from it.
As for external access for on-prep openshift I would suggest to follow official recommendations. They have pretty good coverage of a topic.
https://docs.openshift.com/container-platform/4.8/networking/configuring_ingress_cluster_traffic/overview-traffic.html
1 Like