Adding an Amazon RDS MySQL, Aurora MySQL, or Remote Instance

The PMM Add Instance is now a preferred method of adding an Amazon RDS database instance to PMM. This method supports Amazon RDS database instances that use Amazon Aurora, MySQL, or MariaDB engines, as well as any remote PostgreSQL, ProxySQL, MySQL and MongoDB instances.

Following steps are needed to add an Amazon RDS database instance to PMM:

  1. In the PMM web interface, go to PMM > PMM Add Instance.

  2. Select Add an AWS RDS MySQL or Aurora MySQL Instance.

    image

  3. Enter the access key ID and the secret access key of your IAM user.

    image

  4. Click the Discover button for PMM to retrieve the available Amazon RDS instances.

    image

    For the instance that you would like to monitor, select the Start monitoring button.

  5. You will see a new page with the number of fields. The list is divided into the following groups: Main details, RDS database, Labels, and Additional options. Some already known data, such as already entered AWS access key, are filled in automatically, and some fields are optional.

    image

    The Main details section allows to specify the DNS hostname of your instance, service name to use within PMM, the port your service is listening on, the database user name and password.

    image

    The Labels section allows specifying labels for the environment, the AWS region and availability zone to be used, the Replication set and Cluster names and also it allows to set the list of custom labels in a key:value format.

    image

    The Additional options section contains specific flags which allow to tune the RDS monitoring. They can allow you to skip connection check, to use TLS for the database connection, not to validate the TLS certificate and the hostname, as well as to disable basic and/or enhanced metrics collection for the RDS instance to reduce costs.

    Also this section contains a database-specific flag, which would allow Query Analytics for the selected remote database:

    • when adding some remote MySQL, AWS RDS MySQL or Aurora MySQL instance, you will be able to choose using performance schema for the database monitoring

    • when adding a PostgreSQL instance, you will be able to activate using pg_stat_statements extension

    • when adding a MongoDB instance, you will be able to choose using Query Analytics MongoDB profiler

  6. Finally press the Add service button to start monitoring your instance.

Table of Contents

Previous topic

Required AWS settings

Next topic

Understanding Dashboards

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.