Comments - Getting Started with MariaDB Galera Cluster

10 years, 11 months ago Eric Howey

Just a suggestion, but the wsrep_sst_auth variable may need to be explained more clearly. I stumbled on this for a few hours. The only reason I figured this out was by looking at the mysql error log on the DONOR.

The errors looked like this:

[ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user '' --password '' --host '172.20.1.123' --port '3306' --local-port '33 06' --socket '/var/lib/mysql/mysql.sock' --gtid '5a568cb8-c658-11e2-0800-29e7f95d4235:0': 2 (No such file or directory)

wsrep_sst_auth needs to be defined with a username and password with root access to all dbservers in either my.cnf or as an argument to your mysqld command. The format for my.cnf is:

wsrep_sst_auth=username:password

Hope this helps.

 
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.