Comment 5 for bug 1003908

Revision history for this message
Alex Yurchenko (ayurchen) wrote :

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:
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.