Documentation forDatabase Performance Analyzer

Register an Amazon RDS for MySQL or MySQL-compatible Aurora database instance

Complete one of the following tasks to register an individual Amazon RDS for MySQL or MySQL-compatible Aurora database instance for monitoring with DPA.

You can also use mass registration to registrations to register multiple database instances, or you can register database instances using scripts that call the DPA API.

Register a read-only Amazon RDS for MySQL database instance

To register a read-only Amazon RDS for MySQL database instance, complete the following steps:

  1. Register the corresponding read/write instance in DPA using the registration wizard.
  2. Copy the user and permissions to the read-only instance.
  3. Open the following file in a text editor:

    <DPA_Home>\iwc\tomcat\ignite_config\idc\system.properties

  4. Add the following setting to the system.properties file and save it:

    com.confio.idc.wizard.allowDuplicateDatabaseRegistration=true

  5. Use the registration wizard to register the instance:
    • For the monitoring user, choose Provide monitoring user. Then enter the credentials for the same user specified for the read/write instance.
    • On the Configuration for Monitoring panel, choose Leave As Is.

Run the registration wizard

To register an Amazon RDS for MySQL or MySQL-compatible Aurora database for DPA to monitor:

  1. On the DPA homepage, click Register DB Instance for Monitoring.
  2. Under Amazon RDS, click Amazon RDS for MySQL.
  3. Click Next.
  4. Complete the remaining wizard panels as described in the following table.

If registration fails because your DPA server cannot connect to the instance's server, see DPA database registration failure when attempting to register a database on an external network.

Panel Instructions
Enter Monitored Database Instance Connection Information

Enter the host name or IP address and port of the server.

DPA monitors all databases within the instance. If more than one instance exists on the server, you must register each instance separately in DPA.

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:

  1. Click Provide a privileged user.
  2. Enter the credentials of an existing user with privileges to create the monitoring user and to grant the required permissions.

    The credentials for the privileged user are not used or stored after the registration.

    The privileged user requires the CREATE USER permission and must be able to grant the following permissions:

    PROCESS on *.*
    SELECT & UPDATE on performance_schema.*

    To enable the retrieval of query execution plans, this privileged user must be able to grant the following permissions:

    SELECT, INSERT, UPDATE, DELETE on *.*

  3. Enter credentials for the monitoring user. You can create a new user or use an existing one.

To specify an existing account:

  1. Click Provide the monitoring user.
  2. Enter credentials. DPA encrypts the password.

Alternatively, you can use the script that DPA provides to create a monitoring user.

  1. Click Monitoring User Creation Script, and follow the on-screen instructions.
  2. Copy the edited script to the MySQL console, and run it.
  3. Provide this user as your monitoring user.
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.

The DPA Recommended option is used for Performance Schema setup. Select Custom to change the Performance Schema setup.

Performance Schema setup

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.

Option Server Default DPA Recommended Detailed Leave as Is
Consumer Global Instrumentation

NC

Consumer Thread Instrumentation

NC

Consumer Statement Digest

NC

Consumer Statement (Current)

NC

Consumer Wait (Current)   NC
Instrument Wait (Lock/*)   NC
Instrument Wait (I/O table) (I/O/file)   NC
Instrument Wait (I/O/socket)   NC
Instrument Wait (Synch/*)     NC

= 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 stage exists in the MySQL Performance Schema. If you enable or disable that instrument, DPA will not change it.

Summary Review the information and click Register Database Instance.
Database Instance Registration Complete Click Finish to return to the DPA homepage.

If you register a database instance within the 14-day trial period, DPA begins monitoring the instance immediately. After the trial period, you must activate a license to monitor the database instance.