To register an Amazon RDS for MySQL or Aurora database for DPA to monitor:
|Enter Monitored Database Instance Connection Information|| |
Enter the host name or IP address and port of the server.
SolarWinds DPA monitors all databases within the instance. If more than one instance exists on the server, you must register each instance separately in DPA.
SolarWinds DPA ignores data generated by the monitoring user on the monitored database instance. For this reason, do not specify a user that causes load on the monitored instance. SolarWinds recommends creating a separate account for the monitoring user.
To create a new account:
To specify an existing account:
Alternatively, you can use the script that DPA provides to create a monitoring user.
SolarWinds DPA ignores data on the monitored database instance from the specified monitoring user. Make sure the monitoring user will not cause load on the monitored instance.
|Oracle Repository Tablespace|| |
If your repository database is not Oracle, the wizard skips this step.
Choose the tablespace in the repository database to store DPA performance data for this monitored instance.
By default, the performance data is stored in the default tablespace of the repository user. However, data for monitored instances can be stored in separate tablespaces.
|Select the Alert Groups|| |
If you have no Alert Groups set up, or if this new database instance does not match the database type of the Alert Group, the wizard skips this step.
Alert Groups simplify alert configuration and help make alerting more consistent across the monitored database instances.
Select the Alert Groups you want the new database instance to join.
|MySQL Configuration for Monitoring|| |
Select a Typical or Custom configuration. SolarWinds recommends the Typical configuration.
Select Custom to change the Performance Schema setup.
Performance Schema setup
Select one of the following options to specify what data the Performance Schema collects and maintains. This table shows which consumers and instruments each option enables.
The MySQL Performance Schema must be enabled. If you select Leave As Is, verify that Global Instrumentation and Thread Instrumentation are enabled in the existing Performance Schema configuration.
✔ = Enabled.
NC = No change. DPA does not change the existing Performance Schema configuration.
* Values that are outside of the MYSQL_PERFORMANCE_SCHEMA configuration scope of DPA are not changed. For example, an instrument named
|Summary||Review the information and click Register Database Instance.|
|Database Instance Registration Complete||Click Finish to return to the DPA homepage.|