[CentOS] realtime backup

Wed Feb 18 20:35:14 UTC 2009
Toby Bluhm <tkb at alltechmedusa.com>

Joost Waversveld wrote:


> 
> 1.
> ===
> RAID IS NO BACKUP! RAID is only to survive hardware failure of the hard 
> disk(s) (and only if you don't use RAID0!).
> 
> Other people are mentioning the Master/Slave setup. This will do if you 
> just need one up to date backup for the coincidence the complete master 
> server fails but not for the occasion someone / something enters the 
> wrong SQL query and deletes the wrong data! Then the slave server will 
> also execute this SQL query and deletes the data also!
> 
> If you want to have the opportunity to go back in time, then you have to 
> make dumps through mysqldump.
> 
> 2.
> ===
> The bigger the data, the slower the backup will be, the longer the 
> tables will be locked, the greater is the change your users will notice 
> it with using the application.

For a speedy backup, could put the db on LVM. Then your procedure would 
be shutdown/freeze db, make lv snapshot, startup/unfreeze db, 
rsync/backup data, remove snapshot.


-- 
tkb