I'm about to commit the implementation of node list feature, so before I do it, here's "request for comments".
This is how it will look like:
mysql> SHOW STATUS LIKE 'wsrep_incoming_addresses';
+--------------------------+-------------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------------+
| wsrep_incoming_addresses | 192.168.0.1:3305, 192.168.0.1:3304, unspecified |
+--------------------------+-------------------------------------------------+
It displays the listening addresses of all nodes in the component. Note that component may be non-primary (network partition) and so an address in the list does not mean that it will serve clients. You also need to check wsrep_cluster_status.
Node incoming address is determined in this order of preference:
1. wsrep_node_incoming_address explicitly set.
2. wsrep_node_address IP part + mysqld_port value.
3. IP of the first ethernet interface as returned by ifconfig + mysqld_port value
4. 'unspecified'
Please comment if you'd like something changed here.
Hi Jay,
I'm about to commit the implementation of node list feature, so before I do it, here's "request for comments".
This is how it will look like: incoming_ addresses' ; ------- ------- ------+ ------- ------- ------- ------- ------- ------- ------- + ------- ------- ------+ ------- ------- ------- ------- ------- ------- ------- + addresses | 192.168.0.1:3305, 192.168.0.1:3304, unspecified | ------- ------- ------+ ------- ------- ------- ------- ------- ------- ------- +
mysql> SHOW STATUS LIKE 'wsrep_
+------
| Variable_name | Value |
+------
| wsrep_incoming_
+------
It displays the listening addresses of all nodes in the component. Note that component may be non-primary (network partition) and so an address in the list does not mean that it will serve clients. You also need to check wsrep_cluster_ status.
Node incoming address is determined in this order of preference: incoming_ address explicitly set.
1. wsrep_node_
2. wsrep_node_address IP part + mysqld_port value.
3. IP of the first ethernet interface as returned by ifconfig + mysqld_port value
4. 'unspecified'
Please comment if you'd like something changed here.