Hi Luke,
Like most backup systems, there is no window unless you are locking the
table/database. If the record has been read and passed out to mysqldump,
any further updates will not be included until the next backup.
The only way to ensure you get complete referential integrity is to stop
any applications and lock all users out of the database.
This is highly impractical in many cases so a hot backup is the only
solution. A common solution is to have the database on a mirrored
volume, drop the apps, break the mirror, restart the apps and backup
from the unused half of the mirror. Rejoin the mirror at the end of the
backup.
If you are using InnoDB, Innobase have a hot backup product which (I
believe) works well. Other than that, I don't know if there is any
product currently for the MyISAM engine but I believe there are noises
afoot from MySQL in this regard.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Luke Vanderfluit [mailto:[EMAIL PROTECTED]
Sent: Monday, 8 May 2006 8:32 AM
To: MySQL List
Subject: updates during database dump
Hi.
When mysql is doing a dump, do the updates that happen during the dump
get included in the dump.
I have a dump that starts at 11pm and goes for 2 hours. If someone
updates data at say 11:45pm, does that update get included in the dump?
When does the window, on what gets included in a dump, close?
Thanks.
Kind regards.
--
Luke Vanderfluit.
Analyst/Programmer.
Internode Systems Pty. Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
