<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>We keep 6 months in our active database and then we archive and
purge anything older than that. The archive data itself is
available for reimport and historical investigation. We've done
this when importing historical data into XDMod.</p>
<p>-Paul Edmon-<br>
</p>
<div class="moz-cite-prefix">On 6/28/2021 10:43 AM, Yair Yarom
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAAHNG4a41QdafBUZm4-i-AR=QJUeUnaQwGUXuXfZt1D0C8E=zw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Hi list,</div>
<div><br>
</div>
<div>I was wondering if you could share your long term archiving
practices.</div>
<div><br>
</div>
<div>We currently purge and archive the jobs after 31 days, and
keep the usage data without purging. This gives us a
reasonable history, and a downtime of "only" a few hours on
database upgrade. We currently don't load the archives into a
secondary db.</div>
<div><br>
</div>
<div>We now have a use-case which might require us to save job
information for more than that, and we're considering how to
do that.<br>
</div>
<div><br>
</div>
<div>Thanks in advance,<br>
</div>
<br clear="all">
<br>
-- <br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<pre style="font-family:monospace"> <span style="color:rgb(133,12,27)">/|</span> |
<span style="color:rgb(133,12,27)">\/</span> | <span style="color:rgb(51,88,104);font-weight:bold">Yair Yarom </span><span style="color:rgb(51,88,104)">| System Group (DevOps)</span>
<span style="color:rgb(92,181,149)">[]</span> | <span style="color:rgb(51,88,104);font-weight:bold">The Rachel and Selim Benin School</span>
<span style="color:rgb(92,181,149)">[]</span> <span style="color:rgb(133,12,27)">/\</span> | <span style="color:rgb(51,88,104);font-weight:bold">of Computer Science and Engineering</span>
<span style="color:rgb(92,181,149)">[]</span><span style="color:rgb(0,161,146)">//</span><span style="color:rgb(133,12,27)">\</span><span style="color:rgb(133,12,27)">\</span><span style="color:rgb(49,154,184)">/</span> | <span style="color:rgb(51,88,104)">The Hebrew University of Jerusalem</span>
<span style="color:rgb(92,181,149)">[</span><span style="color:rgb(1,84,76)">/</span><span style="color:rgb(0,161,146)">/</span> <span style="color:rgb(41,16,22)">\</span><span style="color:rgb(41,16,22)">\</span> | <span style="color:rgb(51,88,104)">T +972-2-5494522 | F +972-2-5494522</span>
<span style="color:rgb(1,84,76)">//</span> <span style="color:rgb(21,122,134)">\</span> | <span style="color:rgb(51,88,104)"><a href="mailto:irush@cs.huji.ac.il" target="_blank" moz-do-not-send="true">irush@cs.huji.ac.il</a></span>
<span style="color:rgb(127,130,103)">/</span><span style="color:rgb(1,84,76)">/</span> |
</pre>
</div>
</div>
</div>
</div>
</blockquote>
</body>
</html>