data from 1 year move/convert/change to a new 5 year rrd

[intenso]

hello,

my cacti has gathered the last year data to 1 Minute rrd files. Now the 1 year is gone and i would like to move the gathered data to an 5 year rrd file.

how is it possible?

i created a new 5 year rra datasource:
rows: 2419200
timespan: 145152000


thanks


ronny

[gandalf]

Please provide
- output of rrdtool info for that rrd file
- a list of current RRA settings (Data Sources -> RRAs)
- a description of the consolidation levels and timespans you'd like to use
Reinhard

[noflies]

Well, depending on the number of steps, that will likely result in the world's largest RRD file!! If my math is correct, that archive will retain 23 years of data. Please reduce the number of rows.

[intenso]

hi,

sorry for my delayed answer. one free day from work on nice weather ...great

so here some informations from my side:

- i have attached the datasource->rra settings as png

- i would like to have all consolidation levels (avg, max, min, last) and a timespan greater then one year. (2years, 5 years, 10 years)
the 1 Minute data is importend, 5 Minutes are not exactly enough. better than 1 Minute are 1 second, but this is not possible with cacti, right?

- i calced the rows and the timespan on this way: (i hope its correct)

timespan
60sec. * 60sec. * 24hours * 7days * 4weeks * 12 months * 5 = 145152000

rows
60sec. * 24hours * 7days * 4weeks * 12 months * 5 = 2419200


- the rrdtool info of one of this big 1Minute / 1 year files.

Code: Select all

filename = "ixswitch06_traffic_in_696.rrd"
rrd_version = "0003"
step = 60
last_update = 1210242664
ds[traffic_in].type = "COUNTER"
ds[traffic_in].minimal_heartbeat = 120
ds[traffic_in].min = 0.0000000000e+00
ds[traffic_in].max = 1.0000000000e+08
ds[traffic_in].last_ds = "3104929206"
ds[traffic_in].value = 3.7881869508e+06
ds[traffic_in].unknown_sec = 0
ds[traffic_out].type = "COUNTER"
ds[traffic_out].minimal_heartbeat = 120
ds[traffic_out].min = 0.0000000000e+00
ds[traffic_out].max = 1.0000000000e+08
ds[traffic_out].last_ds = "2372048196"
ds[traffic_out].value = 1.5439559410e+07
ds[traffic_out].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 3386880
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[0].cdp_prep[1].value = NaN
rra[0].cdp_prep[1].unknown_datapoints = 0
rra[1].cf = "MIN"
rra[1].rows = 3386880
rra[1].pdp_per_row = 1
rra[1].xff = 5.0000000000e-01
rra[1].cdp_prep[0].value = NaN
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[1].cdp_prep[1].value = NaN
rra[1].cdp_prep[1].unknown_datapoints = 0
rra[2].cf = "MAX"
rra[2].rows = 3386880
rra[2].pdp_per_row = 1
rra[2].xff = 5.0000000000e-01
rra[2].cdp_prep[0].value = NaN
rra[2].cdp_prep[0].unknown_datapoints = 0
rra[2].cdp_prep[1].value = NaN
rra[2].cdp_prep[1].unknown_datapoints = 0
rra[3].cf = "LAST"
rra[3].rows = 3386880
rra[3].pdp_per_row = 1
rra[3].xff = 5.0000000000e-01
rra[3].cdp_prep[0].value = NaN
rra[3].cdp_prep[0].unknown_datapoints = 0
rra[3].cdp_prep[1].value = NaN
rra[3].cdp_prep[1].unknown_datapoints = 0

[gandalf]

Ok. So you had an RRA definition of that kind, spanning one year. Now you have a second RRA definition spanning 5 years, correct?
For new graphs, change Data Templates to refer to the new 5 year RRA instead of the 1 year. That's all for NEW rrd files.
To cope with OLD rrd files, please use http://docs.cacti.net/node/393
Reinhard