The Ultimate Guide to High Availability with MariaDB

Comments - IST replication failing on 2 node galera mariadb setup

5 years, 7 months ago Geoff Montee
Re: IST replication failing on 2 node galera mariadb setup 
mysql_1          | 2017-06-02 12:19:33 140261419019008 [Note] WSREP: IST receiver addr using tcp://192.168.60.123:4568
mysql_1          | 2017-06-02 12:19:33 140261419019008 [Warning] WSREP: Failed to prepare for incremental state transfer: Failed to open IST listener at tcp://192.168.60.123:4568', asio error 'bind: Cannot assign requested address': 99 (Cannot assign requested address)
mysql_1          | 	 at galera/src/ist.cpp:prepare():325. IST will be unavailable.

Are you sure that 192.168.60.123 is the joiner node's correct IP address? Based on the donor node's log, it looks like it might be 172.20.0.1.

mysql_1          | 2017-06-02 12:19:57 140421086836480 [Note] WSREP: (ce3e5068, 'tcp://0.0.0.0:4567') connection to peer 15b3ea58 with addr tcp://172.20.0.1:4567 timed out, no messages seen in PT3S
mysql_1          | 2017-06-02 12:19:57 140421086836480 [Note] WSREP: (ce3e5068, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://172.20.0.1:4567 
mysql_1          | 2017-06-02 12:19:58 140421086836480 [Note] WSREP: (ce3e5068, 'tcp://0.0.0.0:4567') reconnecting to 15b3ea58 (tcp://172.20.0.1:4567), attempt 0
mysql_1          | 2017-06-02 12:19:58 140421086836480 [Note] WSREP: (ce3e5068, 'tcp://0.0.0.0:4567') connection established to ce3e5068 tcp://172.20.0.1:4567
 
5 years, 7 months ago Sander Groenen
Re: IST replication failing on 2 node galera mariadb setup

that is the ip address of the docker container, the host has the mentioned 192.168.60.123 address. In the meanwhile we have tried some other things, namely setting the ist.recv_bind to 127.0.0.1 which seems to work for IST but it seems to randomly work or fail. We also tried to set ist.recv_bind to the 172.20.0.1 (the docker ip) and that has worked in some cases. We are currently using mariadb 10.3.9 with mariabackup instead of xtrabackup v2 and in that setup the docker ip does not seem to work for IST. The 127.0.0.1 does, but as stated its not 100%. We're having a hard time finding clear documentation on the proper settings for ist to work in combination with docker and replication (btw all ports on joiner and master are 100% open)

 
5 years, 3 months ago Simon Liu
Re: IST replication failing on 2 node galera mariadb setup

run docker with --network host option. like: docker run -itd --network host xxx

 
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.