I have been trying to expose MySQL InnoDB Cluster setup on OCI OKE to Internet. This cluster was installed using MySQL Operator and the pods are listening on to port 6446 and 6447. I have ClusterIP to connect to pods by exec'ing into the pod. However, I have failed to find any best way to expose this cluster to internet using OCI Loadbalancer. As I am pretty new to OCI, trying to get some understanding on how to get this to work.
Cluster was installed using this repo
you can install the ingress controller and expose it with a TCP port opening with the controller or you can change the service type to LB instead clusterIP which will expose the service directly however you might have to take care about the type of LB coz MySQL will be using TCP maybe so HTTP LB may not work.
Doc for ref : https://kubernetes.github.io/ingress-nginx/user-guide/exposing-tcp-udp-services/
With doc, you will get the idea to expose the TCP or UDP service with Nginx ingress controller which is more or like port opening and exposing service.