List:General Discussion« Previous MessageNext Message »
From:Joerg Bruehe Date:March 15 2011 7:36pm
Subject:Re: Backup Policy
View as plain text  
Hi!


Adarsh Sharma wrote:
> Dear all,
> 
> Taking Backup is must needed task in Database Servers. [[...]]

Correct.

> 
> We have options RAID, mylvmbackup , mysqldump. But it depends on the
> company requirement too.

RAID is no backup!

A RAID system may give you protection against a single disk drive
failing (depending on the RAID level you configure), but it doesn't
protect you against misuse, operator error, malware (virus, trojan),
wilful deletion, ...

RAID is no backup!  (This can't be repeated often enough.)

Doing a backup means to take the data (including schema, privileges,
passwords, triggers, ...) to some independent media where it is safe
from all misfunction on the original machine.
IMNSHO, a backup must be taken offline or write-protected in some other
way, so that even a misfunction of the backup machine does not damage
your backup.

Old tape drives (or newer tape cartridges) with their physical write
protection (ring, slider, ...) did provide such protection, it is a pity
that they are too slow and too small for today's data (or too expensive
for most people).

With disks, my solution is:
- Have the backup disks on a separate machine, via the network.
- Have external backup disks, which are powered off if not is use.
- Have two (or more) and use them alternating, so that even in case of a
  misfunction or drive failure (affecting the backup disk currently in
  use) the previous backup (on the other disk) remains safe.

> 
> We have a database of more than 250GB in mysql database & which is
> increasing day by day. Currently I am using mysqldump utility of MySQL
> I perform a full backup about 28 days ago. But is there any mechanism or
> script to backup only the incremental backups on weekly or daily bases.
> 
> Data is inserted in separate tables in separate databases. We cann't
> afford to have some proprietary solution.

If you can afford downtime (shutting down the database), "dirvish" is a
good means to take a file system backup (all your data areas). Check it
at www.dirvish.org  There are plenty of alternatives, but I didn't try
most of them. What I did try was "rsnapshot", but I found it too
inflexible for my purposes.

I can't comment on the other approaches.

Whatever approach you take: Make sure the backup gets stored os some
separate, protected media.


HTH,
Jörg

-- 
Joerg Bruehe,  MySQL Build Team,  joerg.bruehe@stripped
               (+49 30) 417 01 487
ORACLE Deutschland B.V. & Co. KG,   Komturstrasse 18a,   D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603

Thread
Backup PolicyAdarsh Sharma15 Mar
  • Re: Backup Policypetya15 Mar
    • Re: Backup PolicyKrishna Chandra Prajapati15 Mar
      • Re: Backup PolicyJohan De Meersman15 Mar
  • Re: Backup Policya.smith15 Mar
    • Re: Backup PolicyKaren Abgarian16 Mar
  • Re: Backup PolicyJoerg Bruehe15 Mar
    • Re: Backup PolicyWm Mussatto15 Mar
      • Re: Backup PolicyJim McNeely15 Mar