Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Port 3307 is missing from services

Description

Hi, 

HAproxy is configured to listen on port 3307 and forward that to the reader nodes on PXC, but port 3307 is missing from the services on k8s:

[centos@ip-172-30-1-190 ~]$ kubectl describe service cdba-test-haproxy Name: cdba-test-haproxy Namespace: default Labels: app.kubernetes.io/component=haproxy app.kubernetes.io/instance=cdba-test app.kubernetes.io/managed-by=percona-xtradb-cluster-operator app.kubernetes.io/name=percona-xtradb-cluster app.kubernetes.io/part-of=percona-xtradb-cluster Annotations: percona.com/last-config-hash: Selector: app.kubernetes.io/component=haproxy,app.kubernetes.io/instance=cdba-test,app.kubernetes.io/name=percona-xtradb-cluster Type: LoadBalancer IP Family Policy: SingleStack IP Families: IPv4 IP: 10.100.27.38 IPs: 10.100.27.38 LoadBalancer Ingress: XXXXXXXXXXXXXXXX.us-east-2.elb.amazonaws.com Port: mysql 3306/TCP TargetPort: 3306/TCP NodePort: mysql 31500/TCP Endpoints: 192.168.19.193:3306,192.168.51.148:3306,192.168.81.225:3306 Port: proxy-protocol 3309/TCP TargetPort: 3309/TCP NodePort: proxy-protocol 32019/TCP Endpoints: 192.168.19.193:3309,192.168.51.148:3309,192.168.81.225:3309 Port: mysql-admin 33062/TCP TargetPort: 33062/TCP NodePort: mysql-admin 30476/TCP Endpoints: 192.168.19.193:33062,192.168.51.148:33062,192.168.81.225:33062 Port: mysqlx 33060/TCP TargetPort: 33060/TCP NodePort: mysqlx 31668/TCP Endpoints: 192.168.19.193:33060,192.168.51.148:33060,192.168.81.225:33060 Session Affinity: None External Traffic Policy: Cluster Events: <none>

Reproducing the issue:

**Creating a PXC cluster with PMM.

Recommended Solution:

**Also create a service on port 3307 which points to the HAproxy loadbalancers.

Environment

None

Smart Checklist

Activity

Aaditya Dubey June 27, 2023 at 9:57 AM

Hi ,

As discussed over slack, closing the issue.

Aaditya Dubey January 19, 2023 at 9:53 AM

Hi ,

Please let us know if issue still persists?

Tibor Korocz (Percona) May 30, 2022 at 11:06 AM

by changing the serviceType I do not see any differences on port 3307... what am I doing wrong here? 

Aaditya Dubey May 25, 2022 at 10:06 AM

Hi  ,

Thank you for the report.
please check suggested solution and let us know if it fixes the issue.

Slava Sarzhan May 17, 2022 at 2:24 PM

you can change the  service type using https://github.com/percona/percona-xtradb-cluster-operator/blob/main/deploy/cr.yaml#L234 option.

Done

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created March 30, 2022 at 1:50 PM
Updated June 27, 2023 at 9:58 AM
Resolved June 27, 2023 at 9:57 AM

Flag notifications