Do the filesystems pass a ZFS scrub? If so, the corruption is somewhere inside MySQL or ibbackup flying the bits around. This is MySQL 5 right?
-J On Thu, Jun 5, 2008 at 12:06 PM, Ethan Erchinger <[EMAIL PROTECTED]> wrote: > > > 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 mailing list [email protected] http://mail.opensolaris.org/mailman/listinfo/storage-discuss
