maria-discuss team mailing list archive

[George Diamantopoulos <georgediam@xxxxxxxxx>]

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@xxxxxxxxxxx>
wrote:

> George,
> On Fri, Nov 2, 2018 at 7:01 PM George Diamantopoulos <georgediam@xxxxxxxxx>
> 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:
>
> https://mariadb.com/kb/en/library/wsrep_provider_options/#gmcastlisten_addr
>
> 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
>