Backup Galera/MySQL
Hi all,
Just trying to determine if there are any gotchas, best practices or other things if I simply want to dump a DB or certain tables that reside in Galera/MySQL cluster. Can I simply do mysqldump (with --lock-tables=false) so tables are not locked during dump. Or is there another solution better recommended?
Thanks.
-
Official comment
Hi,
It really depends on what you want. Taking mysqldump backup without locking the whole cluster won't create consistent backup and, as such, you can't use it as a point in time view of the cluster. There are other methods - xtrabackup or even filesystem snapshot (EBS snapshot in EC2 for example but also LVM or some hardware-dependent SAN snapshots). I did a quick search within our blog posts and here are the links which you may find useful.
http://severalnines.com/blog/mysqldump-or-percona-xtrabackup-backup-strategies-mysql-galera-cluster
http://severalnines.com/blog/become-mysql-dba-blog-series-backup-restoreYou may also want to review our webinar on different backup approaches for MySQL and Galera:
http://severalnines.com/webinars/become-mysql-dba-webinar-series-deciding-relevant-backup-solution
Thanks,
KrzysztofComment actions
Please sign in to leave a comment.
Comments
1 comment