Hi Max, On Wed, Aug 19, 2015 at 9:40 AM, Max Zulio <zulioexpr...@gmail.com> wrote: > > If I kill -9 mysqld on all three of my nodes in the cluster, then start the > services simultaneously,the cluster comes back online successfully using the > gvwstate.dat file. > > If I gracefully shutdown mysql on all three nodes as you mentioned the > gvwstate.dat file is deleted. This means when the cluster needs to be > restarted I am forced to edit my.cnf and replace > wsrep_cluster_address=gcomm://x.x.x.x,y.y.y.y,z.z.z.z with > wsrep_cluster_address=gcomm:// on one of the nodes before I can bring up the > cluster. > > Is there anyway to have the last node that is shutdown gracefully keep it's > gvwstate.dat file so that the next time the cluster is started it can come > online without editing the config file? >
It might not help a whole lot to only have a gvwstate.dat file on the last node that shuts down, since that would only allow for recovering a cluster with that single node. In that case, it would kind of be like a shortcut to bootstrapping. There is a feature request on Codership's Github that requests a new wsrep_provider_option: pc.recover_minimum_weight. If that ever gets added to Galera, that would allow you to automatically recover a cluster after a graceful shutdown: https://github.com/codership/galera/issues/283 Thanks, Geoff _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
