Before you can begin using the Management Pack, you must create an adapter instance to identify the host from which the Management Pack will retrieve data.

Procedure

  1. Log in to vRealize Operations as an admin user.
  2. Click the Administration administration_icon icon. In the right panel, the Solutions view will be displayed.
  3. Select MySQL Adapter from the Solutions list.
    solutions_list_after_install-3
  4. Click the Configure configure_icon icon. The Manage Solution window will appear.
    Note: Click the Add add_icon icon above the Instance Namelist on the left to create multiple adapter instances.

    manage_solution_window-2
  5. In the Manage Solution window, enter the following information:
    1. Adapter Settings:
      • Display Name: A name for this particular instance of the Management Pack
      • Description: Optional, but it can be helpful to describe multiple instances of the Management Pack
    2. Basic Settings:
      • Database:Optional; will connect to all available databases if left blank. If one (or more) is specified here (comma-separated), the Management Pack will connect to that database(s) only.
      • Host:Hostname or IP address of MySQL instance
      • Port:Default port is 3306; can be overridden
      • Credential: Select the credential you created when Creating a Credential (MySQL), or you can create one now by clicking the Add add_iconicon.
    3. Advanced Settings:
      • Use SSL: True/False
      • Server SSL Cert File Path: If the Use SSL field is set to True, you must specify the path to the SSL certificate on your vROps system.
      • Support Autodiscovery:True by default. This should not be set to False.
      • Monitor Tables: True/False
      • Monitor Queries: True/False
      • Active Query Count: Default = 10; enter “0” to disable
      • Maximum Query Resources: The maximum number of query resources to keep in vROps.
      Note: If there are multiple databases for a single connection, the limit is still set to this count. (Some of the worst ranked queries may be excluded for a database.)
      • Query History Interval (Hours): Represents how far back the system queries the database for slow queries
      • Order Queries By: Choose how you prefer to have your MySQL queries ordered. Available options are:
        • Average Time

        • Calls

        • Total Time

        • Average Lock Latency

        • Total Latency

        • Average Latency

        • Average Rows Sent

        • Average Temp Tables

        • Average Sort Merge Passes

        • Average Rows Examined

        • Average Rows Sorted

        • Average Rows Affected

        • Exec Count

        • Max Latency

        • Average Error Count

        • Average Temp Disk Tables

        • Average Warning Count

      • Connection Timeout (Seconds): Represents how long until the connection to the database closes if a response has not been received

What to do next