multiple changes in database

[ehomo]

Hi!

I want to make multiple changes on my cacti server.
convert all my 1846 Interface-traffic data sources from In/Out Bits to In/Out Bits (64bit counters).

i think that this info is stored in mysql table "data_input_data".
is that all if i only change "value" from 13 to 14?

[gandalf]

Of course you'll have to use SNMP V2c for all those hosts ...
Reinhard

[ehomo]

Hi!
I mean that all my data sources currently 32bit, and i need to perform muliple changes to convert that DS to 64bit. And i asking... This information stored only in DataBase? What could happen if i change this info. in DB?

Thank you.

[TheWitness]

Here is a pretty rough procedure. Hope it helps.

1) Change the max value in the rrd file first using the rrdtool tune function.
2) Create new 64bit data sources in Cacti by creating the 64bit graphs.
3) Copy the 32bit data source rrd files over the 64bit ones via file copying.

For example, if your 32bit data source was:

myhost_traffic_in_1234.rrd

And your 64bit data source was:

myhost_traffic_in_2345.rrd

The last step would be to:

copy myhost_traffic_in_1234.rrd myhost_traffic_in_2345.rrd

4) Let the poller run a few passes and view your 64bit graphs to make sure everyting copied over well.
5) Delete your 32bit data sources in Cacti, take the graphs with them.
6) Delete your 32bit rrd files. I do this by looking at file save times and deleting all those that have not updated in X days.

I have used this process on several occasions. Now, before I create graphs for a host type, I perform a pre-assessment to insure the "polability" to prevent the rework articulated above.

TheWitness

[Matt`G]

Sorry to resurrect an old thread, but I've got a "what-if" that corresponds with this. The OP wanted to change all interface stats to 64bit counters. If he were to re-define the data query for in/out bits and set the data sources to the 64-bit counters, what effect would that have? Would that still create new rrd's and need the procedure you outlined?

[TheWitness]

None, the data is stored as octets in the RRD file and converted to bit's via a CDEF.

TheWitness