backup Galera/MySQL DB

Follow

john test

• November 25, 2015 15:48

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

0

• 

  Ashraf Sharif

  • November 25, 2015 16:12

  Hi John,

  For Galera, use --single-transaction to perform non-blocking backup for InnoDB tables only. Take note on the implication of running mysqldump as described in this page: http://severalnines.com/blog/mysqldump-or-percona-xtrabackup-backup-strategies-mysql-galera-cluster under 'mysqldump' section.

  Regards,

  Ashraf

  0

  Comment actions Permalink

Please sign in to leave a comment.