The Ultimate Guide to High Availability with MariaDB

Comments - Server System Variables

3 years, 11 months ago Testing User A Test
bind_address: Bind more than one address

In normal situation, there should be only one IP bind to db server. Application will connect to this binding address. But on our environment, our developer need to access to the db on another network segment.

I tried to define the parameter as follows:

[mysqld] bind_address=10.x.x.1,192.168.x.x

When starting using /usr/bin/galera_new_cluster, it turned out with the following error messages:

[ERROR] Can't create IP socket: Name or service not known

Is there any way to bind more than one IP?

 
3 years, 11 months ago Testing User A Test
Re: bind_address: Bind more than one address

It should be...

[galera] bind_address=10.x.x.1,192.168.x.x

If I define as follows, it works.

[galera] bind_address=10.x.x.1

It works also as follows:

[galera] bind_address=192.168.x.x

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.