Applies To:

Show Versions Show Versions

Manual Chapter: Statistics Database Storage
Manual Chapter
Table of Contents   |   Next Chapter >>

About the health and performance monitoring database

When statistics data collection is enabled, Enterprise Manager™ stores the following information in its statistics database for each managed device on which the Data Collection Agent is installed:

  • Specifics about the managed devices, such as host name, IP address, and software version.
  • Details, such as object type and name, about any enabled network objects associated with a managed device.
  • Performance and health data for managed devices and associated network objects.

You can use the collected statistics to display standardized reports about the health and performance of managed devices in your network. This helps you identify any systems that are not performing at full capacity and assists you in determining when you should add new devices.

Important: Enterprise Manager collects statistics only from devices that have BIG-IP® Local Traffic Manager™ licensed and provisioned. Starting with Enterprise Manager version 2.3, Enterprise Manager can also collect statistics from devices licensed and provisioned for BIG-IP Global Traffic Manager™.

To start collecting statistics, you must enable the collect statistics data feature and install the Data Collection Agent.

Note: For additional information about the health and performance monitoring feature, see the Enterprise Manager™ Administrator Guide.

Task summary

Enabling statistics data collection

To collect statistics you must enable data collection, which is disabled by default.
Important: Due to the processing power required to collect and store statistics data, only Enterprise Manager™ 3000 and 4000 platforms and Enterprise Manager Virtual Edition (VE) support statistics data collection. If you are upgrading from a version of Enterprise Manager that is earlier than 1.7, you must re-license the system before enabling data collection.
  1. On the Main tab, click Enterprise Management > Options > Statistics > Data Collection.
  2. For the Collect Statistics Data setting, select Enabled.
  3. Click the Save Changes button.
When you enable statistics collection, Enterprise Manager verifies that each managed device has a compatible version of the Data Collection Agent installed.

Installing the Data Collection Agent

When data collection is enabled, Enterprise Manager™ collects health and performance monitoring statistics data for each managed device in your network on which the most current version of the Data Collection Agent is installed. If a device on which statistics is enabled requires a more recent version of the Data Collection Agent, Enterprise Manager displays that device as Impaired in the device list, and indicates that an upgrade is required.
You can use the Data Collection Agent Installation wizard to update and install the Data Collection Agent.
  1. On the Main tab, click Enterprise Management > Tasks > Task List.
  2. Click the New Task button.
  3. For the Software Installation setting, click Install Data Collection Agent, and then click Next. The Data Collection Agent Installation screen opens.
  4. For the Device Filter setting, click the Devices with data collection enabled requiring update option. The screen refreshes to display the devices that require an update.
  5. Select the check box next to each device on which you want to install the most recent version of the Data Collection Agent, and click Next. The Task Options screen opens.
  6. From the Configuration Archive list, select an option to include or exclude private SSL keys in the configuration archive.
  7. From the Device Error Behavior list, select an option to specify how you want the system to proceed if an error occurs during the Data Collection Agent installation task.
  8. Click Next. The Task Review screen opens.
  9. In the Task Name field, you can type a new name to customize the name that displays in the task list.
  10. Click the Start Task button. The Task Properties screen opens, displaying the progress of the task. The task progress displays as Finished when the Data Collection Agent is installed.
Enterprise Manager starts collecting and storing health and performance monitoring statistics for the devices on which data collection is enabled and the Data Collection Agent is installed.

About external storage for health and performance monitoring statistics

By default, Enterprise Manager™ stores health and performance monitoring statistics data in the database located on its hard drive. You have the option of configuring Enterprise Manager to store these statistics on a hard drive that is separate (external) from the Enterprise Manager system. Storing statistics on an external database clears space on Enterprise Manager for more storage of archives, images, configuration files, and so forth. A space dedicated only to health and performance monitoring statistic data can also provide you with more historical data storage.

To use an external database for health and performance monitoring statistics storage, you must create the external database and then configure Enterprise Manager to store data on that database.

If you previously collected data locally on the Enterprise Manager system, you have the option to back up and restore the data to the external database.

Task summary

Creating an external database for health and performance monitoring statistics storage

Before configuring Enterprise Manager™ to store statistics data on an external database, you must create an external database on a system that is running Oracle® MySQL® version 5.1 with patch 52 or later.

Important: Versions of MySQL other than 5.1 are not compatible with the statistics database schema. All patches for MySQL version 5.1 (with patch 52 or later) are compatible. In some operating environments, the number of file handles required by the partitioning feature of MySQL exceed the number configured by default. If this occurs, MySQL logs the errors Too many open files or File table overflow. For systems using a Linux operating system, this issue may be resolved by setting the open file limit to 12000 (open-files-limit=12000) in the my.cnf configuration file.
Storing statistics on an external database clears space on Enterprise Manager for more storage of archives, images, configuration files, and so forth. A space dedicated only to health and performance monitoring statistic data can also provide you with more historical data storage. To create an external database for statistics storage, you use a specific sequence of SQL commands.
  1. create database <database> , where <database> is the name of the external database.
  2. grant all privileges on <database>.* to <username>@<host> identified by <password> , where <host> includes the IP address of the Enterprise Manager system that is storing data on the external database and <password> is the password for the user name specified.
  3. grant select on mysql.proc to <username>@<host>
    This command sets privileges for the specified user to initiate the required procedures for Enterprise Manager to store and access data on the external database.
  4. set global log_bin_trust_function_creators = 1
    This command relaxes the privilege conditions so that Enterprise Manager can create necessary functions and procedures that enable you to store and access statistics data.
You can now configure Enterprise Manager to store health and performance monitoring statistics in the external database that you created.

Backing up and restoring existing database statistics

If you previously collected data locally on the Enterprise Manager system, you can back up and restore the local data to the external database that you created.

  1. On the Main tab, click Enterprise Management > Options > Statistics > Data Collection.
  2. From the Collect Statistics Data list, select Disable.
  3. Click the Save Changes button.
  4. On the system on which the local database is located, create a back up of the data by running the following command: mysqldump -u <user> -p -R f5em_extern> dump.sql, where <user> is the user name assigned to the database.
  5. On the system on which you created the external database, restore the data by running the following command: mysql -u <user> -p -D remotedb < dump.sql, where <user> is the user name assigned to the database.
  6. On the Main tab, click Enterprise Management > Options > Statistics > Data Collection.
  7. From the Collect Statistics Data list, select Enabled.
  8. Click the Save Changes button.
You can now configure Enterprise Manager™ to store health and performance monitoring statistics on the external database.

Configuring Enterprise Manager to store statistics on an external database

After you have created the external database on the remote system, you can configure Enterprise Manager™ to store data there.

Configuring Enterprise Manager to store health and performance monitoring statistics on an external database frees system resources, and provides you with space to store statistics that is limited only by the system's hard drive on which you configure the external database.

Important: When configured to use an external database for statistics storage, Enterprise Manager no longer monitors, reports, nor sends alerts regarding storage capacity and usage, and you cannot schedule or perform statistics database backups and restorations from Enterprise Manager. When statistics are stored in an external database, the administrator of the remote system on which the statistics are stored must perform capacity management, and backup and restoration tasks independently of Enterprise Manager.

If you have two Enterprise Manager systems configured as a high availability system, configure the external database the same way on each system.

  1. On the Main tab, click Enterprise Management > Options > Statistics > Data Storage.
  2. For the Statistics Data Location setting, select External. The screen refreshes to display additional fields specific to the external database option.
  3. In the External Database Address field, type the IP address of the system on which you configured the external database.
  4. In the External Database Port field, leave 3306 for the MySQL default port, or type a new port number in the field.
  5. In the External Database Name field, type a name for the external database.
  6. In the External Database User and External Database Password fields, type the credentials required to access the database.
  7. In the Allocated Statistic Storage Space field, type a value for the number of gigabytes (GB) that you want to dedicate to storing statistics. This value cannot exceed the available amount of disk space of the system on which you set up the external database. Enterprise Manager does not monitor the amount of disk space on the external database.
  8. Click Save Changes. The screen displays a summary of the configuration.
  9. If the summary details are correct, click Confirm to initialize the configuration.
When the configuration changes are fully initialized, Enterprise Manager begins to store health and performance monitoring statistics data in the external database. (This transition may take a few minutes.) Content currently stored in the local database remains there until you remove it.

Removing local statistics data storage

After you configure Enterprise Manager™ to store health and performance monitoring statistics on an external database location, you may want to remove the data stored locally. Before removing the local statistics, first verify that external statistics storage, data retrieval, and reporting functionality are working as expected, and that the locally-stored data is no longer useful or relevant. Or, if you want to retain the local data, back up the local data to store elsewhere, prior to deleting it.
Removing the locally-stored statistics increases the amount of storage that Enterprise Manager can use for archives, images, configuration files, and so forth.
  1. On the Main tab, click Enterprise Management > Statistics > Options > Data Storage.
  2. Click the Delete Local Statistics Data button.
  3. Click Confirm.
Enterprise Manager frees the local disk space that was previously dedicated to storing statistics data.

Modifying the amount of stored historical health and performance monitoring data

When Enterprise Manager™ is configured to collect statistical data, the Data Storage screen displays a system-generated estimate of the number of days until the system reaches capacity for statistical data storage. This number is calculated based on the current rate of data collection and the amount of disk space you specified for the storage space allocation. To retain more or less historical data, you can modify the storage allocation space.
  1. On the Main tab, click Enterprise Management > Statistics > Options > Data Storage.
  2. In the Allocated Statistic Storage Space field, type a new value for the number of gigabytes (GB) on the external database hard drive that you want to dedicate to storing statistics.
  3. Click the Save Changes button.
After you save your changes, Enterprise manager recalculates and displays the new Estimated Statistics Storage Capacity With Current Settings value based on the newly allocated storage space. You can modify the storage allocation space as needed, until you are satisfied with the number of days of historical data remaining.
Table of Contents   |   Next Chapter >>

Was this resource helpful in solving your issue?




NOTE: Please do not provide personal information.



Incorrect answer. Please try again: Please enter the words to the right: Please enter the numbers you hear:

Additional Comments (optional)