[MDEV-12825] Documentation for wsrep_node_address is not correct Created: 2017-05-17  Updated: 2018-08-06  Resolved: 2018-08-06

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Michaël de groot Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

Hi!

The documentation for wsrep_node_address is not correct. It claims the IP address of the first interface is used.

The first interface does not have an IP address and we see galera listen on 0.0.0.0.

Please find the ifconfig and netstat output attached.

 # netstat -tulpn | grep LISTEN
 
tcp        0      0 10.67.20.3:3306             0.0.0.0:*                   LISTEN      14176/mysqld
 
tcp        0      0 10.67.20.3:3311             0.0.0.0:*                   LISTEN      14176/mysqld
 
tcp        0      0 0.0.0.0:4567                0.0.0.0:*                   LISTEN      14176/mysqld
 
 
 
 
 # ifconfig -a
 
 
 
bond0     Link encap:Ethernet  HWaddr E8:39:35:EA:64:B0
 
 
 
          UP BROADCAST RUNNING MASTER MULTICAST  MTU:1500  Metric:1
 
 
 
          RX packets:7152230301 errors:0 dropped:11475 overruns:0 frame:0
 
 
 
          TX packets:6482236745 errors:0 dropped:0 overruns:0 carrier:0
 
 
 
          collisions:0 txqueuelen:0
 
 
 
          RX bytes:1654686740548 (1.5 TiB)  TX bytes:2484570861335 (2.2 TiB)
 
 
 
 
 
 
bond0.9   Link encap:Ethernet  HWaddr E8:39:35:EA:64:B0
 
 
 
          inet addr:10.67.24.93  Bcast:10.67.27.255  Mask:255.255.252.0
 
 
 
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
 
 
          RX packets:398869971 errors:0 dropped:0 overruns:0 frame:0
 
 
 
          TX packets:50989811 errors:0 dropped:0 overruns:0 carrier:0
 
 
 
          collisions:0 txqueuelen:0
 
 
 
          RX bytes:97422000426 (90.7 GiB)  TX bytes:983125370470 (915.6 GiB)
 
 
 
 
 
 
bond0.30  Link encap:Ethernet  HWaddr E8:39:35:EA:64:B0
 
 
 
          inet addr:10.67.20.3  Bcast:10.67.23.255  Mask:255.255.252.0
 
 
 
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
 
 
          RX packets:6699403836 errors:0 dropped:0 overruns:0 frame:0
 
 
 
          TX packets:5695167324 errors:0 dropped:0 overruns:0 carrier:0
 
 
 
          collisions:0 txqueuelen:0
 
 
 
          RX bytes:1396284622084 (1.2 TiB)  TX bytes:1400967485737 (1.2 TiB)
 
 
 
 
 
 
eth0      Link encap:Ethernet  HWaddr E8:39:35:EA:64:AE
 
 
 
          inet addr:172.16.8.93  Bcast:172.16.11.255  Mask:255.255.252.0
 
 
 
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
 
 
          RX packets:739569712 errors:0 dropped:0 overruns:0 frame:0
 
 
 
          TX packets:96530013 errors:0 dropped:0 overruns:0 carrier:0
 
 
 
          collisions:0 txqueuelen:1000
 
 
 
          RX bytes:128004486819 (119.2 GiB)  TX bytes:13818816498 (12.8 GiB)
 
 
 
 
 
 
eth1      Link encap:Ethernet  HWaddr E8:39:35:EA:64:B0
 
 
 
          UP BROADCAST RUNNING SLAVE MULTICAST  MTU:1500  Metric:1
 
 
 
          RX packets:1938709243 errors:0 dropped:0 overruns:0 frame:0
 
 
 
          TX packets:2224113209 errors:0 dropped:0 overruns:0 carrier:0
 
 
 
          collisions:0 txqueuelen:1000
 
 
 
          RX bytes:314504876333 (292.9 GiB)  TX bytes:627316625865 (584.2 GiB)
 
 
 
 
 
 
eth2      Link encap:Ethernet  HWaddr E8:39:35:EA:64:B0
 
 
 
          UP BROADCAST RUNNING SLAVE MULTICAST  MTU:1500  Metric:1
 
 
 
          RX packets:1883888274 errors:0 dropped:0 overruns:0 frame:0
 
 
 
          TX packets:2926942118 errors:0 dropped:0 overruns:0 carrier:0
 
 
 
          collisions:0 txqueuelen:1000
 
 
 
          RX bytes:359669233825 (334.9 GiB)  TX bytes:728870452111 (678.8 GiB)
 
 
 
 
 
 
eth3      Link encap:Ethernet  HWaddr E8:39:35:EA:64:B0
 
 
 
          UP BROADCAST RUNNING SLAVE MULTICAST  MTU:1500  Metric:1
 
 
 
          RX packets:3329669923 errors:0 dropped:11475 overruns:0 frame:0
 
 
 
          TX packets:1331213419 errors:0 dropped:0 overruns:0 carrier:0
 
 
 
          collisions:0 txqueuelen:1000
 
 
 
          RX bytes:980520915690 (913.1 GiB)  TX bytes:1128391010474 (1.0 TiB)
 
 
 
 
 
 
lo        Link encap:Local Loopback
 
 
 
          inet addr:127.0.0.1  Mask:255.0.0.0
 
 
 
          inet6 addr: ::1/128 Scope:Host
 
 
 
          UP LOOPBACK RUNNING  MTU:65536  Metric:1
 
 
 
          RX packets:274924017 errors:0 dropped:0 overruns:0 frame:0
 
 
 
          TX packets:274924017 errors:0 dropped:0 overruns:0 carrier:0
 
 
 
          collisions:0 txqueuelen:0
 
 
 
          RX bytes:53491692990 (49.8 GiB)  TX bytes:53491692990 (49.8 GiB)



 Comments   
Comment by Ian Gilfillan [ 2017-05-17 ]

Are you saying that the documentation on the Galera website, http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep-node-address, is incorrect, or that the MariaDB documentation on https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_node_address needs to be expanded to clarify situations where results are unreliable?

Comment by Michaël de groot [ 2017-10-17 ]

Hey Ian,

Both your statements are correct: The documentation on the codership website is not correct (it missing this small piece) and, comparing Codership's documentation our documentation is a bit small.

Thank you,
Michaël

Comment by Ian Gilfillan [ 2018-08-06 ]

Docs expanded and updated.

Generated at Thu Feb 08 08:00:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.