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
Subject
Views
Written By
Posted
8174
February 01, 2006 10:19AM
4905
February 03, 2006 12:56AM
4882
February 03, 2006 02:35AM
Re: mysqlhotcopy to backup ARCHIVE tables?
4667
February 03, 2006 05:11AM
4476
February 03, 2006 09:45AM
4643
February 05, 2006 10:31PM
4485
June 20, 2006 05:14PM
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.