Notes on Galera SST/IST network port order
SST:
pre-SST:
Donor:
MySQL(3306) and Galera replication port(4567) are open.
Joiner: no ports are open
Note: clustercheck port(9200) using xinetd could be running on both joiner and donor
MySQL is started on Joiner:
Joiner:
Galera replication port(4567) and SST port(4444) are open
Connects to Galera replication port(4567) of Donor
Donor:
MySQL(3306) and Galera replication port(4567) are open
Connects to Galera replication port(4567) of Joiner
Connects to SST port(4444) of Joiner
When SST completes:
Donor:
MySQL(3306) and Galera replication port(4567) are open
Maintains connection to Galera replication port(4567) of Joiner
Connection to SST port(4444) of joiner is closed
Joiner:
MySQL(3306) and Galera replication port(4567) are open
pre-SST:
Donor:
MySQL(3306) and Galera replication port(4567) are open.
Joiner: no ports are open
Note: clustercheck port(9200) using xinetd could be running on both joiner and donor
MySQL is started on Joiner:
Joiner:
Galera replication port(4567) and SST port(4444) are open
Connects to Galera replication port(4567) of Donor
Donor:
MySQL(3306) and Galera replication port(4567) are open
Connects to Galera replication port(4567) of Joiner
Connects to SST port(4444) of Joiner
When SST completes:
Donor:
MySQL(3306) and Galera replication port(4567) are open
Maintains connection to Galera replication port(4567) of Joiner
Connection to SST port(4444) of joiner is closed
Joiner:
MySQL(3306) and Galera replication port(4567) are open
SST port(4444) is closed
Maintains connection to Galera replication port(4567) of Donor
IST:
pre-SST:
Donor:
MySQL(3306) and Galera replication port(4567) are open.
Joiner: no ports are open
Note: clustercheck port(9200) using xinetd could be running on both joiner and donor
MySQL is started on Joiner:
Joiner:
Galera replication port(4567) and SST port(4444) are open
IST:
pre-SST:
Donor:
MySQL(3306) and Galera replication port(4567) are open.
Joiner: no ports are open
Note: clustercheck port(9200) using xinetd could be running on both joiner and donor
MySQL is started on Joiner:
Joiner:
Galera replication port(4567) and SST port(4444) are open
Connects to Galera replication port(4567) of Donor
Donor:
MySQL(3306) and Galera replication port(4567) are open
Connects to Galera replication port(4567) of Joiner
Connects to SST port(4444) of Joiner
SST completes:
Donor:
MySQL(3306) and Galera replication port(4567) are open
Maintains connection to Galera replication port(4567) of Joiner
Connection to SST port(4444) of joiner is closed
Joiner:
Galera replication port(4567) are open
MySQL(3306) and Galera replication port(4567) are open
Connects to Galera replication port(4567) of Joiner
Connects to SST port(4444) of Joiner
SST completes:
Donor:
MySQL(3306) and Galera replication port(4567) are open
Maintains connection to Galera replication port(4567) of Joiner
Connection to SST port(4444) of joiner is closed
Joiner:
Galera replication port(4567) are open
SST port(4444) is closed
Maintains connection to Galera replication port(4567) of Donor
IST started:
Joiner:
Galera replication port(4567), MySQL(3306) port, and IST port(4568) are open
IST started:
Joiner:
Galera replication port(4567), MySQL(3306) port, and IST port(4568) are open
Maintains connection to Galera replication port(4567) of Donor
Note: MySQL(3306) port opens a little bit after IST port is open and donor connects to it
Donor:
MySQL(3306) and Galera replication port(4567) are open
MySQL(3306) and Galera replication port(4567) are open
Maintains connection to Galera replication port(4567) of Joiner
Connects to IST port(4568) of Joiner
When IST completes:
Donor:
MySQL(3306) and Galera replication port(4567) are open
Maintains connection to Galera replication port(4567) of Joiner
Connection to IST port(4568) of joiner is closed
Joiner:
MySQL(3306) and Galera replication port(4567) are open
Donor:
MySQL(3306) and Galera replication port(4567) are open
Maintains connection to Galera replication port(4567) of Joiner
Connection to IST port(4568) of joiner is closed
Joiner:
MySQL(3306) and Galera replication port(4567) are open
IST port(4568) is closed
Maintains connection to Galera replication port(4567) of Donor
Comments