# Percona 5.7.22-22, Ubuntu 18.04 LTS - Cluster restart on Reboot without bootstrapping **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [September 3, 2018, 7:31pm UTC](https://forums.percona.com/t/percona-5-7-22-22-ubuntu-18-04-lts-cluster-restart-on-reboot-without-bootstrapping/6555 "2018-09-03T19:31:47Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![HeloJunkie](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/helojunkie/32/1239_2.png) [@HeloJunkie](https://forums.percona.com/u/HeloJunkie)\ **Post date:** [September 3, 2018, 7:31pm UTC](https://forums.percona.com/t/percona-5-7-22-22-ubuntu-18-04-lts-cluster-restart-on-reboot-without-bootstrapping/6555/1 "2018-09-03T19:31:47Z")
mysql\> SHOW VARIABLES LIKE ‘%version%’; ±------------------------±------------------------------------------------------------------------------------------------+ | Variable\_name | Value | ±------------------------±------------------------------------------------------------------------------------------------+ | innodb\_version | 5.7.22-22 | | protocol\_version | 10 | | slave\_type\_conversions | | | tls\_version | TLSv1,TLSv1.1,TLSv1.2 | | version | 5.7.22-22-57-log | | version\_comment | Percona XtraDB Cluster (GPL), Release rel22, Revision da86071, WSREP version 29.26, wsrep\_29.26 | | version\_compile\_machine | x86\_64 | | version\_compile\_os | debian-linux-gnu | | version\_suffix | -57-log | ±------------------------±------------------------------------------------------------------------------------------------+ 9 rows in set (0.01 sec) I am running a three node cluster. Everything is working great, but for some reason, I cannot get my cluster to come back online after rebooting the cluster stack of three servers. I followed this article: [url][https://www.percona.com/blog/2014/12/03/auto-bootstrapping-an-all-down-cluster-with-percona-xtradb-cluster/[/url]](https://www.percona.com/blog/2014/12/03/auto-bootstrapping-an-all-down-cluster-with-percona-xtradb-cluster/%5B/url%5D) and was able to bring up the cluster after doining a killall -9 mysqld on all of my nodes, came right back up just as it should. When I reboot my cluster, I can go to my primary node (what I call primary), bootstrap it (/etc/init.d/mysql restart-bootstrap) then start all other nodes and everything comes up fine. I guess my question is simple - how to I make sure the cluster comes back online unattended after a cluster reboot? Many Thanks ---
**Author:** ![Patrick\_C](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/patrick_c/32/5241_2.png) [@Patrick\_C](https://forums.percona.com/u/Patrick_C)\ **Post date:** [September 5, 2018, 6:59am UTC](https://forums.percona.com/t/percona-5-7-22-22-ubuntu-18-04-lts-cluster-restart-on-reboot-without-bootstrapping/6555/2 "2018-09-05T06:59:25Z")
If you only reboot 1 at a time you should not have this problem? ---
**Author:** ![HeloJunkie](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/helojunkie/32/1239_2.png) [@HeloJunkie](https://forums.percona.com/u/HeloJunkie)\ **Post date:** [September 5, 2018, 9:47am UTC](https://forums.percona.com/t/percona-5-7-22-22-ubuntu-18-04-lts-cluster-restart-on-reboot-without-bootstrapping/6555/3 "2018-09-05T09:47:12Z")
So the fix is not to reboot all of the cluster at the same time? I am more concerned about something like a power outage that takes my cluster down. I am trying to determine why the cluster does not come back online without having to bootstrap it at all. Is this not possible? ---
**Author:** ![Patrick\_C](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/patrick_c/32/5241_2.png) [@Patrick\_C](https://forums.percona.com/u/Patrick_C)\ **Post date:** [September 5, 2018, 1:05pm UTC](https://forums.percona.com/t/percona-5-7-22-22-ubuntu-18-04-lts-cluster-restart-on-reboot-without-bootstrapping/6555/4 "2018-09-05T13:05:52Z")
If all 3 go down at once, then you have to pick which one you like as the bootstrap node . Start up that node regularly and then run: SET GLOBAL wsrep\_provider\_options=‘pc.bootstrap=true’; Then you can turn on the other 2. After they all sync up, I don’t know for certain if you need to then set this back to false - maybe someone else can chime in. SET GLOBAL wsrep\_provider\_options=‘pc.bootstrap=false’; ---
**Author:** ![HeloJunkie](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/helojunkie/32/1239_2.png) [@HeloJunkie](https://forums.percona.com/u/HeloJunkie)\ **Post date:** [September 5, 2018, 1:31pm UTC](https://forums.percona.com/t/percona-5-7-22-22-ubuntu-18-04-lts-cluster-restart-on-reboot-without-bootstrapping/6555/5 "2018-09-05T13:31:19Z")
Got it, so if they all fail for some reason, or if you shut down all three nodes - manual intervention is required to bring the cluster back online. That is what I needed to know. Thank You for the help!