search

colinmollenhour / mariadb-galera-swarm

MariaDb Galera Cluster container based on official mariadb image which can auto-bootstrap and recover cluster state.
https://hub.docker.com/r/colinmollenhour/mariadb-galera-swarm
Apache License 2.0
219 stars 103 forks source link

Galera crash #102

Closed viki-v closed 2 years ago

viki-v commented 3 years ago

Hello Sir,

I have implemented this Galera swarm in production, It has been crashed and lost production data

please help me restore the data

when checked the logs the MySQL files are been removed, is there anyway restoration..?

colinmollenhour commented 3 years ago

Hi @viki-v I'm sorry to hear about the troubles. Operating a Galera cluster is definitely a task for an expert and I cannot offer help beyond what this code project offers. I would recommend reading the relevant sections of this guide to get a general idea about how to recover: Crash Recovery. This guide was used as a basis for creating this container image and some of the scenarios are automatic and some require manual intervention. MariaDb and Percona both offer paid support as well.

colinmollenhour commented 3 years ago

Also make sure you check the README of this project regarding the flag files, often times shutting down all nodes and then starting one with the new/cluster flag file is the quickest way to get the cluster back (the other nodes will have to do a full SST): https://github.com/colinmollenhour/mariadb-galera-swarm#flag-files