<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 6 6 2 2 2 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
mso-believe-normal-left:yes;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><![if mso 9]><style>p.MsoNormal
{margin-left:7.5pt;}
</style><![endif]><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-NZ link=blue vlink=purple style='margin-left:7.5pt;margin-top:7.5pt;margin-right:7.5pt'><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Steve<o:p></o:p></span></p><div><div class=MsoNormal align=center style='margin:0cm;margin-bottom:.0001pt;text-align:center'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Steve Shipway<o:p></o:p></span></b></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>ITS Unix Services Design Lead<o:p></o:p></span></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>University of Auckland, New Zealand<o:p></o:p></span></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Floor 1, 58 Symonds Street, Auckland<o:p></o:p></span></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><i><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#595959'>Phone: +64 (0)9 3737599 ext 86487<o:p></o:p></span></i></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><i><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#595959'>DDI: +64 (0)9 924 6487<o:p></o:p></span></i></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><i><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#595959'>Mobile: +64 (0)21 753 189<o:p></o:p></span></i></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><i><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#595959'>Email: <a href="mailto:s.shipway@auckland.ac.nz"><span style='color:#595959'>s.shipway@auckland.ac.nz</span></a><o:p></o:p></span></i></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span lang=EN-GB style='font-size:18.0pt;font-family:Webdings;color:green'>P</span><span lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:blue'> </span><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:green'>Please consider the environment before printing this e-mail</span><span lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:blue'> </span><span lang=EN-GB style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:navy'><o:p></o:p></span></p><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><i><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></i></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> rrd-users-bounces+s.shipway=auckland.ac.nz@lists.oetiker.ch [mailto:rrd-users-bounces+s.shipway=auckland.ac.nz@lists.oetiker.ch] <b>On Behalf Of </b>ccddtt<br><b>Sent:</b> Monday, 16 July 2012 9:08 p.m.<br><b>To:</b> rrd-users<br><b>Subject:</b> [rrd-users] Incremental backup rrd file<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:13.5pt;font-family:"Verdana","sans-serif"'> hi,rrd-users!</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'> <o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:13.5pt;font-family:"Verdana","sans-serif"'>I had some rrd files more than 300M,need bakup to remote server every day.</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:13.5pt;font-family:"Verdana","sans-serif"'>I use VPN access the remote server,the link is very slow.</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:13.5pt;font-family:"Verdana","sans-serif"'>who can tell me how to incremental backup the rrd file ?</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'> <o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:13.5pt;font-family:"Verdana","sans-serif"'>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.</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'> <o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:13.5pt;font-family:"Verdana","sans-serif"'>thanks very much!</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-family:"Verdana","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-family:"Verdana","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-family:"Verdana","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-family:"Verdana","sans-serif"'> <o:p></o:p></span></p></div><div class=MsoNormal align=center style='margin:0cm;margin-bottom:.0001pt;text-align:center'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><hr size=2 width=122 style='width:91.5pt' align=center></span></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:silver'>2012-07-16</span><span style='font-family:"Verdana","sans-serif";color:silver'><o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span style='font-family:"Verdana","sans-serif";color:silver'> <o:p></o:p></span></p><div><p class=MsoNormal style='margin:0cm;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:silver'> <o:p></o:p></span></p></div></div></div></div></body></html>