Hi Vin,
What do you mean when you refer to the internal database? Are you
talking about InterMapper's local storage for chart data? If so, then
yes, that remains completely unchanged, besides some performance
improvements. The database holds a separate copy of all that data, and
can collect it from more than one IM server.
The database does require a significant amount of space, since it stores
the data less efficiently in order to make it available via SQL. It
also requires a fair amount of free space on the disk in order to
perform maintenance operations. We're actively working on reducing the
amount of space required for both storage and maintenance, but for now,
if you do want to use the database, I'd just recommend a little planning
in advance.
1. Pick a good data retention policy; one that keeps as little 'raw
data' as possible. Reports barely even uses the raw data, so unless
you're planning to write your own SQL queries, I would recommend the
following:
- Keep raw data for just a few days; not more than a week
- Keep 5-minute samples for 1-3 months
- Keep hourly samples for 6-12 months
- Keep daily samples forever
Raw and 5-minute data tend to make up about 90% of the database's
overall size, so the more you can limit those, the less disk space
you'll need.
2. Once you've applied a good server-wide policy, wait for the database
to go through another collection cycle, then use the 'Overview' page on
its web interface to see estimated future disk usage. Add at least 50%
to that value, and that's how much space you'll need to set aside. For
example, if the estimated usage reaches 5GB and then levels off, you'll
want to make about 8-10GB available for the database.
3. Be mindful that as you add more devices to your network, the database
will grow beyond that initial estimate.
I hope that helps,
David
On 3/14/2011 7:36 AM, Vin Latus (ISD) wrote:
So far we have not used the InterMapper Database server and used only
the internal database due to drive space concerns. From what I've read
so far it seems the new reporting features of 5.4.x depend on use of the
database server. My question is; do you still have the option of using
the internal database in 5.4?
------------------------------
David Schnur - Dartware, LLC
[email protected]
____________________________________________________________________
List archives:
http://www.mail-archive.com/intermapper-talk%40list.dartware.com/
To unsubscribe: send email to: [email protected]
