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.
- Log in to vRealize Operations as an admin user.
- Click the Administration icon. In the right panel, the Solutions view will be displayed.
- Select MySQL Adapter from the Solutions list.
- Click the Configure icon. The Manage Solution window will appear.
Note: Click the Add icon above the Instance Namelist on the left to create multiple adapter instances.
- In the Manage Solution window, enter the following information:
- 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
- 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 icon.
- Advanced Settings:
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.)
- 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.
- 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 Lock Latency
Average Rows Sent
Average Temp Tables
Average Sort Merge Passes
Average Rows Examined
Average Rows Sorted
Average Rows Affected
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
- Adapter Settings:
What to do next
- To validate data collection, see: Validating Data Collection (MySQL).