Saturday, July 23, 2016

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
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
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
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
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
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
IST port(4568) is closed
Maintains connection to Galera replication port(4567) of Donor