I have a Percona XtraDB cluster with 3 nodes. Only one of these nodes is connected to by the application that uses the database.
I would like to perform 'hot backups' simply using mysqldump
on one of the nodes that doesn't serve the application by running:-
mysqldump --opt --skip-lock-tables --skip-add-locks \
--single-transaction --routines > dump.sql
Will this affect the performance of the node serving the application? Or would I be ok running this every 2 or 3 hours on one of the other nodes?