If your MySQL server acts as a master in a replication setup, you can use a slave server to make your backups instead of backing up the master:
The advantage of making a backup this way is that it doesn't take place on the master server. Thus, the master need not be interrupted at all, and the backup procedure does not impose any extra disk or processing load on it. |