On Feb 23, 2010, at 8:06 PM, Benjamin Franz <jfranz at freerun.com> wrote: > 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. Well make sure to setup a non-broken replica... :-) -Ross