38.107.179.23438.107.179.234 InterMapper Database Changes in 5.1
InterMapper.comiMapper Community 
 
InterMapper Database Changes in 5.1

Several new features and enhancements to InterMapper Database have been implemented in InterMapper 5.1. This tech note contains a summary of those changes.

Configuration Improvements

  • When InterMapper Database detects an InterMapper server running on the same machine, it now gives the option of automatically registering that server for export. This avoids the need to open the Server Settings and enable it manually.

Import Improvements

  • The import operation is now far less resource-intensive, especially for servers with a very large number of devices and interfaces. This results in lower processor and memory usage during normal operation, and less time taken to import old data when a server is first registered for export.

Sample Generation and Retention Policies

  • Data Retention Policies are now applied individually, instead of in sequence. For example, specifying an hourly data expiration of two days now causes hourly samples to be deleted after two days, instead of two days plus the raw and custom expirations. This is more intuitive, and makes it easier to predict how long data will remain available.

Automatic Backup Improvements

  • The automatic and manual backup and restore actions have received many bug fixes and improvements based on user feedback. Most importantly, backups no longer time out for large databases, and the restore operation is more reliable.

  • The automatic backup page in the web interface now shows a progress indicator. It also provides a cancel button, which will stop the current operation and automatically clean up any temporary files.

Web Interface Additions

  • The web interface now includes a 'Disk Usage Stats' page, which provides an overview of the database's contents. This page contains charts showing the number of maps, devices, interfaces, events and data points stored in the database. It also shows how quickly these entries are being accumulated, how much disk space is required to store them, and a rough estimate of how much space they will consume in the future.

  • The 'Database Settings' page now includes a per-user 'Remote Login' check-box. This automatically configures the database to grant that user access from any machine on the network, removing the need to manually edit the pg_hba.conf file.

  • The web interface now includes a 'Maintenance Tasks' page, containing several new actions for power-users. Most notably, it provides a 'Pause Import' button, which temporarily disables import for all servers, giving time to perform maintenance on the database while it is running.