fP and data integrity...how to maintain on non-quiescent systems?

Kenneth Brody kenbrody at bestweb.net
Mon Feb 19 08:47:42 PST 2007


Quoting Bill Campbell (Sat, 17 Feb 2007 19:11:20 -0800):
[... Backing up an active database ...]
> MySQL handles this by (a) making a snapshot of the database, and noting
> the offset within the current logfile.  The secondary system is created
> from that snapshot, then it's given the offset in the remote log file,
> effectively does a seek into that file, and proceeds to continuously
> update its databases, keeping track of its current position in the log
> processing.
[...]

How does MySQL handle updates while taking the snapshot?  How long
does it take to make the snapshot on such a large set of tables?

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list