Re: [Bacula-devel] Snapshot backups of MySQL

2010-10-08 Thread Phil Stracchino
On 10/08/10 18:09, Attila Fülöp wrote: > Phil Stracchino wrote: >> ...Then again, I could have just made a stupid, trivial configuration >> error on the secondary MySQL server I was loading the restored shapshots >> onto. But none of us ever do that, do we...? > > Phil, > > I don't thinks so. I'

Re: [Bacula-devel] Snapshot backups of MySQL

2010-10-08 Thread Attila Fülöp
Phil Stracchino wrote: > On 10/08/10 13:19, Phil Stracchino wrote: >> On 10/08/10 10:42, Phil Stracchino wrote: >>> So, as I mentioned a little while back, I've been playing around with >>> snapshot-based backups of MySQL. The key to success is knowing how to >>> properly quiesce InnoDB tables. I

Re: [Bacula-devel] Snapshot backups of MySQL

2010-10-08 Thread Phil Stracchino
On 10/08/10 13:19, Phil Stracchino wrote: > On 10/08/10 10:42, Phil Stracchino wrote: >> So, as I mentioned a little while back, I've been playing around with >> snapshot-based backups of MySQL. The key to success is knowing how to >> properly quiesce InnoDB tables. I still have a bunch of consis

Re: [Bacula-devel] Snapshot backups of MySQL

2010-10-08 Thread Phil Stracchino
On 10/08/10 10:42, Phil Stracchino wrote: > So, as I mentioned a little while back, I've been playing around with > snapshot-based backups of MySQL. The key to success is knowing how to > properly quiesce InnoDB tables. I still have a bunch of consistency > testing to do, but it's looking very pr

[Bacula-devel] Snapshot backups of MySQL

2010-10-08 Thread Phil Stracchino
So, as I mentioned a little while back, I've been playing around with snapshot-based backups of MySQL. The key to success is knowing how to properly quiesce InnoDB tables. I still have a bunch of consistency testing to do, but it's looking very promising indeed. It should work on any underlying