All Products
Search
Document Center

:Install and configure the MySQL component

Last Updated:Jan 24, 2024

Alibaba Cloud Managed Service for Prometheus allows you to install and configure the MySQL component. Managed Service for Prometheus also provides out-of-the-box dashboards that you can use to monitor your applications.

Entry points

Entry point 1

  1. Log on to the ARMS console.
  2. In the left-side navigation pane, choose Prometheus Service > Prometheus Instances.
  3. Click the name of the Prometheus instance instance that you want to manage to go to the Integration Center page.

Entry point 2

  1. Log on to the ARMS console.

  2. In the left-side navigation pane, click Integration Center. In the Application Components section, find the MySQL component and click Install. In the panel that appears, configure a MySQL exporter as prompted.

Configure a MySQL exporter

This section describes how to configure a MySQL exporter on the Integration Center page. Perform the following steps:

  1. Install or add the MySQL component.

    • If you install the MySQL component for the first time, perform the following operation:

      In the Not Installed section of the Integration Center page, find the MySQL component and click Install.

    • If you have installed the MySQL component, add the component again:

      In the Installed section of the Integration Center page, click Add next to MySQL.

  2. On the Settings tab in the STEP2 section, configure the parameters and click OK. The following table describes the parameters.

    Parameter

    Description

    Component Name

    The unique name of the MySQL exporter. The name must meet the following requirements:

    • It can contain only lowercase letters, digits, and hyphens (-), and cannot start or end with a hyphen (-).

    • It must be unique.

    Note

    If you do not specify this parameter, the system uses the default name, which consists of the exporter type and a numeric suffix.

    MySQL URL

    The URL that is used to access the MySQL database.

    Note

    The URL of the MySQL database that is deployed in ACK, ECS, or ApsaraDB RDS is automatically displayed in the drop-down list.

    MySQL Port

    The port number of the MySQL database. Example: 3306.

    Username

    The username and password of the MySQL database.

    Important

    We recommend that you do not use an administrator account to avoid data breach risks. Create a MySQL account for mysqld_exporter and grant minimum permissions to the account. For more information, see Permissions required for mysqld_exporter to access a MySQL database.

    Password

    Note

    You can view the monitoring metrics on the Metrics tab in the STEP2 section.

    You can also configure the resource quotas for the exporter in the Advanced Settings: Exporter Resource Limits section. The default value of the CPU (Cores) parameter is 100m, and the default value of the memory parameter is 50Mi.

    The installed components are displayed in the Installed section of the Integration Center page. Click the component. In the panel that appears, you can view information such as targets, metrics, dashboard, alerts, service discovery configurations, and exporters. For more information, see Integration center.