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 still have a bunch of consistency >>> testing to do, but it's looking very promising indeed. >> Looks like I spoke a little too soon ... the InnoDB tables are failing >> consistency after restore. This needs more work. > > ...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'm using a similar approach to back up MySQL on ZFS and I'm seeing "db not cleanly shutdown" and "replaying logs" messages after starting the cloned db. Looking at zetaback they essentialy do the same and claim it should work. I had no time to delve deeper into this but at least the generated dumps look good, so right now I'm ignoring this problem. ;-) Please give me short note if you find something out. Attila ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
