Re: backup database
For more than 5 years (and probably still going on now) the backup/recovery procedure used by mysql.com was to run a slave server that was shutdown daily and a file-system level snapshot taken. To recover you just needed to reload that backup, which included the master.info file, and START SLAVE on it to allow it to catch up transactions missed.
It worked flawlessly and was the quickest and most reliable option for creating new slave images or recovering a dead slave.
So while what you are saying is wise advice, Peter, it is not the only way, and can have problems with recovery in a replicated environment (as you need to ensure you have the binlogs synced with your backup).
Webmaster -
http://www.SkySQL.com/
Subject
Written By
Posted
September 06, 2011 02:58AM
September 06, 2011 03:41AM
September 06, 2011 03:51AM
September 06, 2011 04:03AM
September 06, 2011 01:01PM
September 06, 2011 01:13PM
Re: backup database
September 06, 2011 11:09PM
September 06, 2011 11:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.