Skip to content

recover mysql cluster from complete outage

Jump to bottom
Émilien Devos (perso) edited this page Mar 11, 2023 · 1 revision
  1. shutdown all the nodes except the first one
  2. mysqlsh
  3. shell.connect('root@mysql-server-1:3306', dbPass)
  4. var cluster = dba.rebootClusterFromCompleteOutage("mysqlreplication01",{force: true})
  5. Remove all the instances: cluster.removeInstance("mysql-server-XXX")
  6. Delete data directory of all the other nodes then bring them back up
  7. Add the nodes back: cluster.addInstance({user: "root", host: "mysql-server-XXXX", password: dbPass})
Clone this wiki locally