Used Discspace? 2 years of data? Tree - Hosts under Host?

Kini · Post by **Kini** » Mon Jul 27, 2009 9:10 am

How much memory will the database need?

Is it possible to save data for 2 Years?

BSOD2600 · Post by **BSOD2600** » Mon Jul 27, 2009 12:58 pm

User_1337 wrote:How much memory will the database need?

Entirely depends how many devices you use. A basic cacti install mysql db is ~1mb. Graph data is stored in rrd files.

User_1337 wrote:Is it possible to save data for 2 Years?

Yes, rrdtool can be set up for that. http://docs.cacti.net/manual:087:8_rrdt ... _data_loss

Kini · Post by **Kini** » Tue Jul 28, 2009 2:08 am

Thanks for the fast answer.

I think saving the data for two years with this instruction you posted will not be a problem anymore. Thanks for that BSOD2600.

Talking about the needed memory again I think it will be the best to setup all needed devices and build all needed graphs and then check the needed memory of the database.

There will be about 200 devices added in Cacti in the end.

Associated Graph Templates will be

Cisco - CPU Usage
Unix - Ping Latency

Associated Data Querries will be

SNMP - Interface Statistics

Every devices will have about 8 to 10 graphs in the end.

Is it possible to make an approximately allegation how much memory will be needed by saving the information for 2 years?

Howie · Post by **Howie** » Tue Jul 28, 2009 2:20 am

rrdtool files are fixed in size at the time they are created, so you should be able to calculate from one device how much 200 devices will need.

Kini · Post by **Kini** » Tue Jul 28, 2009 4:52 am

In the moment there happened another problem.

Cacti created two hosts in the tree under another host.
I just want them to be under the upper header but cacti placed them under the last host of the header?

Deleting them from the tree and adding them again to the tree does not make any difference. The two hosts are further on listed under the other host.

Is it need to delete the two wrong placed hosts or is there any other way to replace them on the tree?

----------------------------------------

Back to the other two questions:

I thought perhabs one of you knows an approximately number of memory in MB but if not it is no problem. During this week I am going to add all devices and so I can check the memory by myself.

The question for saving the memory for 2 years is answered so far. Tomorrow there will be time for me to try as described above in the other post.

Kini · Post by **Kini** » Tue Jul 28, 2009 7:48 am

BSOD2600 wrote:
User_1337 wrote:[...]

User_1337 wrote:Is it possible to save data for 2 Years?
Yes, rrdtool can be set up for that. http://docs.cacti.net/manual:087:8_rrdt ... _data_loss

So i got time to do this earlier I thought myself.
I did that like described in the link above.

I also configured the Cisco CPU Usage and the Unix - Ping Latency into this 2year RRA.

The Ping and CPU Graphs of the testdevice are visible. But there were no graphs made for the traffic. Why?

Kini · Post by **Kini** » Tue Jul 28, 2009 8:42 am

Next question:

In Configuration -> Settings -> Authentication I want to use LDAP but it isn`t listed.

LDAP Authentication - Allows for authentication against a LDAP server. Users will be created automatically on first login if the Template User is defined, otherwise the defined guest permissions will be used. If PHP's LDAP module is not enabled, LDAP Authentication will not appear as a selectable option.

How to enable PHP`s LDAP module?

BSOD2600 · Post by **BSOD2600** » Tue Jul 28, 2009 12:04 pm

User_1337 wrote:How to enable PHP`s LDAP module?

Enable it in your php.ini

... well assuming the php_ldap module is present too.

Kini · Post by **Kini** » Wed Jul 29, 2009 1:19 am

LDAP done. It works. But a bit unpractical by adding all users again. Is there no way to identify each user due to the existing LDAP Server?

------------------------------------

The problem with the two hosts listed under one other host in the tree could only be resolved by completely deleting them including all data. After I added those two hosts again it was possible to add them into the tree correctly.

------------------------------------

Further on I yesterday did the thing with the two years data saving:
I added a new RRA named "(1) Saving data 2 years" with the following settings:

Consolidation Function: AVERAGE AND MAX
X-Files Factor: 0.5
Steps: 1
Rows: 210240
Timepawn: 66106368

I borrowed the Consolidation Function, the X-Files Factor and the Steps from the old further on existing RRA. The Rows are: 365*2*24*12 = 210240 for two years, 24hours a day and 12 5min intervals per hour. The Timespawn was calculated like follows: 365*2*24*60*60 = 66106368. This is the count of seconds of two years.

Was all this correct? The rest I did like described in the documentation.

I also added Cisco - CPU Usage and Unix - PING Latency.

The CPU Usage and the PING Latency is working. The traffic isn`t showing any graphs.

Used Discspace? 2 years of data? Tree - Hosts under Host?

Used Discspace? 2 years of data? Tree - Hosts under Host?

Who is online