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