when preparing the xtraDB Cluster the documentation says that i need to open the following ports:
– 3306
– 4444
– 4567
– 4568
So if i understand it correct, these ports just need to be open for all nodes to each node? So on a 3 node cluster node 1 needs to have these ports open for node 2 and 3, node 2 for node 1 and 3 and node 3 for node 1 and 2 - correct?
What about the loadbalancer? Does i need to open these ports on and for the loadbalancer? As i thought its just port 3306 which need to be open on and for the loadbalancer?
I shared a link to your another question of yours about ProxySQL. For the ports, ofcourse 3306 is the one where MySQL will communicate. But for ProxySQL we also need to know that by default, ProxySQL uses two ports: 6033, on which it listens for traffic and 6032, which works as a gateway for managing ProxySQL.
What about the loadbalancer? Does i need to open these ports on and for the loadbalancer? As i thought its just port 3306 which need to be open on and for the loadbalancer?
The load balancer would need only the MySQL client port to be opened( 3306, or 6032 and 6033 for proxysql)
The other ports (444,4567 and 4568) are used between the cluster nodes for internal communications