Andrey Kuzmin wrote: > Using ZFS snapshots as an alternative hot backup approach is worth a > look. It gives you the same recovery guarantees provided your db log > shares the dataset with data, is lightweight, and may be used for > fairly frequent incremental backup, modern way :-). > The problem we have with this type of solution, is that there is no verification of the data pages inside InnoDB. You are blindly copying bits from one place to another, without knowing if the bits are "secure". Yes, with ZFS we should have assurance that there were no write errors resulting in bad data pages, or indexes. But, even with ZFS, we've still seen errors reading data later with ibbackup that went uncaught somehow. It may even be MySQL writing bad chksum data that is causing the issue, but ibbackup catches these issues. _______________________________________________ storage-discuss mailing list [email protected] http://mail.opensolaris.org/mailman/listinfo/storage-discuss
- [storage-discuss] ZFS or MPXIO failure after importin... Ethan Erchinger
- Re: [storage-discuss] ZFS or MPXIO failure after... James C. McPherson
- Re: [storage-discuss] ZFS or MPXIO failure a... Jason J. W. Williams
- Re: [storage-discuss] ZFS or MPXIO failure a... Bob Friesenhahn
- Re: [storage-discuss] ZFS or MPXIO failu... James C. McPherson
- Re: [storage-discuss] ZFS or MPXIO failu... Ethan Erchinger
- Re: [storage-discuss] ZFS or MPXIO failure a... Ethan Erchinger
- Re: [storage-discuss] ZFS or MPXIO failu... Andrey Kuzmin
- Re: [storage-discuss] ZFS or MPXIO failure after... Andrey Kuzmin
- Re: [storage-discuss] ZFS or MPXIO failure a... Ethan Erchinger
- Re: [storage-discuss] ZFS or MPXIO failu... Jason J. W. Williams
- Re: [storage-discuss] ZFS or MPXIO f... Ethan Erchinger
- Re: [storage-discuss] ZFS or MP... Jason J. W. Williams
- Re: [storage-discuss] ZFS o... Ethan Erchinger
- Re: [storage-discuss] ZFS or MPXIO failure after... Ben Rockwood
- Re: [storage-discuss] ZFS or MPXIO failure a... Jason J. W. Williams
- Re: [storage-discuss] ZFS or MPXIO failure a... Ethan Erchinger
- Re: [storage-discuss] ZFS or MPXIO failu... Ben Rockwood
- Re: [storage-discuss] ZFS or MPXIO f... Ethan Erchinger
