galera

database

Create

# start first node
galera_new_cluster
 
# install 
mariadb-backup
 
# /etc/mysql/conf.d/90-galera.cnf
wsrep_sst_method = mariabackup
 
# fix systemd timeout
systemctl show mysql.service -p TimeoutStartUSec
systemctl edit mysql.service
 
[Service]
TimeoutStartSec=7200s
 
systemctl daemon-reload
 
# cat /etc/systemd/system/mariadb.service.d/override.conf
[Service]
TimeoutStartSec=7200s

Show node IPs

for IP in db1 db2 db3; do
    echo ${IP}
    ssh ${IP} cat /var/lib/mysql/grastate.dat
done