{"action":"created","issue":{"url":"https://api.github.com/repos/codership/galera/issues/283","labels_url":"https://api.github.com/repos/codership/galera/issues/283/labels{/name}","comments_url":"https://api.github.com/repos/codership/galera/issues/283/comments","events_url":"https://api.github.com/repos/codership/galera/issues/283/events","html_url":"https://github.com/codership/galera/issues/283","id":85086296,"number":283,"title":"Cluster automatic recovery after graceful shutdown of all nodes","user":{"login":"joffrey92","id":7384759,"avatar_url":"https://avatars.githubusercontent.com/u/7384759?v=3","gravatar_id":"","url":"https://api.github.com/users/joffrey92","html_url":"https://github.com/joffrey92","followers_url":"https://api.github.com/users/joffrey92/followers","following_url":"https://api.github.com/users/joffrey92/following{/other_user}","gists_url":"https://api.github.com/users/joffrey92/gists{/gist_id}","starred_url":"https://api.github.com/users/joffrey92/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joffrey92/subscriptions","organizations_url":"https://api.github.com/users/joffrey92/orgs","repos_url":"https://api.github.com/users/joffrey92/repos","events_url":"https://api.github.com/users/joffrey92/events{/privacy}","received_events_url":"https://api.github.com/users/joffrey92/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-06-04T12:53:18Z","updated_at":"2015-06-12T22:48:23Z","closed_at":null,"body":"Hi,\r\n\r\nI really like the recovery feature (pc.recovery) : http://galeracluster.com/documentation-webpages/pcrecovery.html \r\n\r\nUnfortunately, this doesn't cover the case when the cluster is gracefully shutdown, as the grwstate.dat file is deleted on all nodes.\r\n\r\nOne example situation would be a power failure in a data-center:\r\n1) Power failure\r\n2) Ups runs\r\n3) Ups has no battery and stops gracefully the servers\r\n4) Power is back\r\n5) Cluster doesn't start\r\n6) Operator needs to bootstrap the cluster by starting one node first, or creating a fake grwstate.dat file.\r\n\r\nWhat do you think?\r\nJoffrey\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/codership/galera/issues/comments/111635331","html_url":"https://github.com/codership/galera/issues/283#issuecomment-111635331","issue_url":"https://api.github.com/repos/codership/galera/issues/283","id":111635331,"user":{"login":"chandler63","id":5338980,"avatar_url":"https://avatars.githubusercontent.com/u/5338980?v=3","gravatar_id":"","url":"https://api.github.com/users/chandler63","html_url":"https://github.com/chandler63","followers_url":"https://api.github.com/users/chandler63/followers","following_url":"https://api.github.com/users/chandler63/following{/other_user}","gists_url":"https://api.github.com/users/chandler63/gists{/gist_id}","starred_url":"https://api.github.com/users/chandler63/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chandler63/subscriptions","organizations_url":"https://api.github.com/users/chandler63/orgs","repos_url":"https://api.github.com/users/chandler63/repos","events_url":"https://api.github.com/users/chandler63/events{/privacy}","received_events_url":"https://api.github.com/users/chandler63/received_events","type":"User","site_admin":false},"created_at":"2015-06-12T22:48:23Z","updated_at":"2015-06-12T22:48:23Z","body":"Joffrey also links to http://galeracluster.com/documentation-webpages/pcrecovery.html which states \r\n\r\nThis feature allows for: Graceful full cluster restarts, without the need for explicitly bootstrapping a new Primary Component.\r\n\r\nHow does this work? If I gracefully shutdown to 1 node, then do 'service mysql restart' on that node, it will not come back up without bootstrapping it."}}