search

rancher / catalog-dockerfiles

Dockerfiles for Rancher Catalog containers
Apache License 2.0
131 stars 102 forks source link

MariaDB Galera Cluster : Add a sidekick for backup #59

Open wanaoishi opened 8 years ago

wanaoishi commented 8 years ago

Hi,

Is there a way to have a sidekick for backup of the Galera cluster? Or to mount a /var/lib/mysql from the galera data on the host?

I had a big DDOS last week, which crushed the Galera cluster totally, and I was unable to access it or restart it. And when I did restart it, it cleared the databases empty. (had backups but from 6 hours before so lot's of datas were lost).

So having the possibility to have immediate backup out of the dockers or a volume would be great.

Thanks

ahfeel commented 8 years ago

Hi @wanaoishi

I'm curious about what did cause the crash ? I don't think it's really possible to have a sidekick for immedate backup other than having another mysql replicating live or something like that... If you came up with a solution I'm curious to know about it !

pdefert commented 7 years ago

hi @wanaoishi and @ahfeel

in my case, i add automysqlbackup on each server node But for that to work, I needed to do ' printenv > /etc/environment' to make available the environment variables for cron

automysqlbackup copy backup with rsync on another server