The Ultimate Guide to High Availability with MariaDB

Comments - Maria 10.2.18: error with Galera joining the second node

5 years, 7 months ago Geoff Montee
Re: Maria 10.2.18: error with Galera joining the second node [Answer]

You'll have to check the SST logs. See mariabackup SST Method: Logs.

The mariabackup SST method has its own logging outside of the MariaDB Server logging.

By default, on the donor node, it logs to innobackup.backup.log. This log file is located in the datadir.

By default, on the joiner node, it logs to innobackup.prepare.log and innobackup.move.log. These log files are located in the .sst directory, which is a hidden directory inside the datadir.

These log files are overwritten by each subsequent SST, so if an SST fails, it is best to copy them somewhere safe before starting another SST, so that the log files can be analyzed. See MDEV-17973 about that.

You can redirect the SST logs to the syslog instead by setting the following in your MariaDB configuration file:

[sst]
sst-syslog=1
 
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.