First off thanks to percona, ive been very impressed with your webinars, products, customer service, etc. Class Act!
I’ve redoing our current backup strategy and will be using innobackupex, as we have both databases with both InnoDB tables and MyISAM tables.
I’ve read and reread just about every piece of documentation produced by percona about innobackupex and to me it is unclear when to prepare the backup. Immediately after the backup or right before the restore?
It appears to be right before the restore, is this correct?
If this is the case I guess I am missing something, because I am confused how that would work if i tried to restore something that was months old. At that point the binary logs will have been rotated a few times now. Does this even matter?
Any insight would be great.