Hello Claudio,

Thanks for the reply. That indeed did the trick! Which leaves me wondering what all of those other configuration variables actually do, but I'll read the docs one more time, hopefully it will come to me!

Thanks!

BR,
George

On Fri, 2 Nov 2018 at 22:52, Claudio Nanni <claudio.nanni@mariadb.com> wrote:
George,
On Fri, Nov 2, 2018 at 7:01 PM George Diamantopoulos <georgediam@gmail.com> wrote:
Hello all,

I've setup a galera cluster with 3 nodes, and I believe that wsrep_node_incoming_address
is not honoured when set in the configuration. More specifically, the setting persists in mariadb:
+-----------------------------+---------------+
| Variable_name               | Value         |
+-----------------------------+---------------+
| bind_address                | 172.30.20.1   |
| wsrep_node_address          | 172.30.20.129 |
| wsrep_node_incoming_address | 172.30.20.129 |
| wsrep_sst_receive_address   | 172.30.20.129 |
+-----------------------------+---------------+
But the process listens on all interfaces instead:
root@gal0-cn1:~# netstat -plunt | grep mysql
tcp        0      0 172.30.20.1:3306        0.0.0.0:*               LISTEN      17229/mysqld        
tcp        0      0 0.0.0.0:4567            0.0.0.0:*               LISTEN      17229/mysqld

Is this expected behaviour? Shouldn't mysqld only listen on 172.30.20.129:4567, as configured? Thanks!

The option you are looking for is:


So in your case it would be:

wsrep_provider_options="gmcast.listen_addr=tcp://173.30.20.129;<other options>"

Please note you can also specify a custom port as:

wsrep_provider_options="gmcast.listen_addr=tcp://173.30.20.129:9999;<other options>"

That will require that the other nodes specify this custom port for in the cluster address for this node, e.g.:

wsrep_cluster_address="gcomm://173.30.20.129:9999,<other nodes here>"

One consequence of this is that you can setup multiple nodes on the same host (for testing purposes).


Best Regards
Claudio