We have a production database that needs to be backed up every 2 hours. There are two destinations actually; one is a staging server (on the same DB host) that we use for testing and the other is a copy of the database that we just need to make sure is in pristine backed up condition.
We want to do this efficiently, however we are finding that mysqldump
locks the database such that the entire webapp hangs for ~15 minutes during a dump due to the size of the database.
How can we get around this and do so in the most efficient manner possible?