[CentOS] realtime backup
Toby Bluhm
tkb at alltechmedusa.com
Wed Feb 18 20:35:14 UTC 2009
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
More information about the CentOS
mailing list