Keepalived vIP as Galera wsrep_cluster_address I have a MariaDB Galera cluster.
If some nodes fail, I cannot blindly restart them, I have to determine a good wsrep_cluster_address first.

If I can keep a keepalived virtual IP on one of the healthy nodes, can I use this IP as wsrep_cluster_address on other nodes? So in case of node failure, the joining node would always have a right wsrep_cluster_address? Or are there any other solutions enabling automatic rejoin?

I feel it should be somehow possible to keep the cluster up and automatically rejoin nodes as long as there is at least 1 healthy node (or Primary Component?) up.

(Note: I am aware of the answer in Galera cluster without having to specify all hosts on wsrep_cluster_address, but multicast is unfortunately not an option.)
You can put multiple addresses into wsrep_cluster_address, e.g. gcomm://10.1.1.1,10.1.1.2,10.1.1.3, and Galera Cluster will detect it smartly.

I has used Percona XtraDB Cluster (which is based on Galera Cluster too) to run serveral (> 10) clusters in production environment:


One has been running with 2 DB servers and 1 garbd server, and we put all three servers into wsrep_cluster_address.
Another was 7 database servers, and we just put first three servers (which were in different racks) into wsrep_cluster_address.


There were power failures (all three servers), hardware failures, software bugs on these clusters in four years, and they worked pretty well.