Hi,
I think there is another usable method to backup databases in MySQL.
And that is using a slave server, (that can be running in the same
server),
and when backuping up the databases you do (in the slave):
STOP SLAVE; -- This will stop the replication
-- Now you backup the databases (using mysqldump or anything you
prefer) from
the slave server
START SLAVE; -- This will restart the replication
This way you have a consistent snapshot of your database, without stop
the
main database, that is being used to whatever aplication you need.
Hope this help,
themage
On Monday 08 May 2006 00:07, Logan, David (SST - Adelaide) wrote:
> 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]
--
Merlin, the Mage
http://www.sites-favoritos.com/user/merlin
http://www.cultodavida.com
http://www.code.online.pt
Carpe Vitam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
