MySQL Forums
Forum List  »  Archive Storage Engine

Re: mysqlhotcopy to backup ARCHIVE tables?
Posted by: Brian Aker
Date: February 03, 2006 05:11AM

Hi!

Yes, I am the primary person, and this is my pet project. You can find a log of some of my thoughts on it at:
archive.krow.net

I don't write about it all that often, most of my notes for it sit in an opml file I keep.

Anyway, the compression buffer will be flushed out with a FLUSH TABLES. So if you locked, then flushed you would be fine. You could also just flush and then copy and you would get a snapshot of what was in the table at the point of the flush, the lock really is not needed. In 5.2 this won't be needed since it will use a new method for storage will remove any issues surrounding losing the compression buffer.

The other item that needs to be done at some point is I should allow it to keep a version list when mysqldump is used to do a dump, so that it would give a consistent snapshot.

Cheers,

-Brian

Options: ReplyQuote


Subject
Views
Written By
Posted
8174
February 01, 2006 10:19AM
Re: mysqlhotcopy to backup ARCHIVE tables?
4667
February 03, 2006 05:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.