Ross Walker wrote:
Or a replica mysql database and use either mysqldump or lvm without having to take the master down or interrupt it's activities.
That works well as long as your replication setup doesn't mysteriously break. I've had issues with the 5.x replication spontaneously breaking silently. YMMV.