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

Reply via email to