[rrd-users] Incremental backup rrd file

[Steve Shipway]

I'm guessing that you have a 300MB RRD file with thousands of rows in the
RRAs, and are hoping to only backup the portions of it that have altered, in
much the same way that an Oracle RMAN backup only backs up altered records.

As far as I know there is no easy way to do this.  All databases suffer from
this; try backing up only the changed portions of a large mysql table, for
example.

You could write a custom daily script to dump the day's high-resolution data
(via rrdtool fetch) to an export file and backup that, though restore would
be a pain in the neck.  At least you'd not have to back up the
lower-resolution RRAs as their contents could be deduced from the
high-resolution data, if you keep it going back far enough.

The way we achieve this for MRTG/RRD is to have a much smaller (800 row) RRD
that backs up completely daily and then rotates.  The frontend allows us to
select archived versions of the RRD to view historical data, though this is
not as convenient as having it all in one 10,000 row RRD of course.

Another way is to run your updates through the trunk version of rrdcached,
and use the pause/resume function to quiesce writing while you snapshot the
filesystem.  Then, you can backup the snapshot (though you're still backing
up the full amount of data).  However this at least ensures you have
consistent backups with structural integrity.

Steve

  _____  

Steve Shipway

ITS Unix Services Design Lead

University of Auckland, New Zealand

Floor 1, 58 Symonds Street, Auckland

Phone: +64 (0)9 3737599 ext 86487

DDI: +64 (0)9 924 6487

Mobile: +64 (0)21 753 189

Email:  <mailto:s.shipway at auckland.ac.nz> s.shipway at auckland.ac.nz

P Please consider the environment before printing this e-mail 

 

 

From: rrd-users-bounces+s.shipway=auckland.ac.nz at lists.oetiker.ch
[mailto:rrd-users-bounces+s.shipway=auckland.ac.nz at lists.oetiker.ch] On
Behalf Of ccddtt
Sent: Monday, 16 July 2012 9:08 p.m.
To: rrd-users
Subject: [rrd-users] Incremental backup rrd file

 

 hi,rrd-users!

 

I had some rrd files more than 300M,need bakup to remote  server every day.

I use VPN access the remote server,the link  is very slow.

who can tell me how to incremental backup the rrd file ?

 

i think maybe like this:i can back that day rrd data(not need other day),and
put to remote server,and iput the bak data to rrd file.

 

thanks very much!

       

     

 

 

  _____  

2012-07-16

  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20120717/4563ad70/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 6080 bytes
Desc: not available
Url : http://lists.oetiker.ch/pipermail/rrd-users/attachments/20120717/4563ad70/attachment-0001.bin