First time setting up Galera (Ubuntu 14.04) and I'm unable to restart the cluster after rebooting my nodes. I'm following the this guide and it doesn't exactly mention how to handle a shutdown or reboot (for kernel patches, hypervisor updates, routine maintenance).
I found a bit of info here which explains how to find the node which is "safe_to_bootstrap" but I think this is describing a crashed node. The link above describes this as a crashed node with seemingly little luck for recovery:
# cat /var/lib/mysql/grastate.dat # GALERA saved state version: 2.1 uuid: a4f9af07-f235-11e7-a0c0-233dd732dc29 seqno: -1 safe_to_bootstrap: 1
When I try to start that node however, I get an error in
`WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)`
What's the best way to shut the cluster down and how do I restart it safely? I'm assuming the customary
reboot command is not adequte for cleanly shutting down the Galera cluster.