Live Backups of MySQL Using Replication

Friday Jun 17th 2005 by DatabaseJournal.com Staff
Share:

One of the difficulties with a large and active MySQL database is making clean backups without having to bring the server down.

[From O'Reilly ONLamp.com]

One of the difficulties with a large and active MySQL database is making clean backups without having to bring the server down. Otherwise, a backup may slow down the system and there may be inconsistency with data, since related tables may be changed while another is being backed up. Taking the server down will ensure consistency of data, but it means interruption of service to users. Sometimes this is necessary and unavoidable, but daily server outages for backing up data may be unacceptable. A simple alternative method to ensure reliable backups without having to shut down the server daily is to set up replication for MySQL.

The article continues at http://www.onlamp.com/pub/a/onlamp/2005/06/16/MySQLian.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved