Not the answer you need?
Register and ask your own question!

Unattended cluster restart

dpolyakovdpolyakov EntrantInactive User Role Beginner
From the doc: "/etc/init.d/mysql bootstrap-pxc
This way values in my.cnf would remain unchanged. Next time node is restarted it won’t require updating the configuration file. This can be useful in case cluster has been previously set up and for some reason all nodes went down and the cluster needs to be bootstrapped again."

Is it possible to restart a cluster in unattended mode?
I understand that to start a cluster you need first to bootstrap a first server and then boot all others. But what if there is a short power failure that reboots every server and there is no one at this moment who can perform bootstrap. Will cluster restore in some way?

Thank you,
Dima

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    If all the cluster members are powered off in the same time, so that noone is alive, then yes, you need to manually pick one node and bootstrap it first. Of course, you should pick up a node being the most up to date in replication.
    With some external software though, like ClusterControl from Severalnines, this could be done automatically.
  • danielmdanielm Entrant Current User Role Beginner
    przemek wrote: »
    If all the cluster members are powered off in the same time, so that noone is alive, then yes, you need to manually pick one node and bootstrap it first. Of course, you should pick up a node being the most up to date in replication.
    With some external software though, like ClusterControl from Severalnines, this could be done automatically.

    Hi,

    Is its possible get info about most up to date node from any file,
    timestamp or something under /var/lib/mysql catalog?

    Regards Daniel
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.