All Products
Search
Document Center

:Install and configure other exporters

Last Updated:Aug 04, 2023

Managed Service for Prometheus allows you to install and configure exporters of the database type, messaging system type, HTTP server type, and other types. Managed Service for Prometheus also provides out-of-the-box dashboards that you can use to monitor your applications.

Quick access for other types of exporters is under development and will be released in the future. If your exporter is not supported by Managed Service for Prometheus, install the exporter, configure service discovery, and then create a dashboard. This topic provides an example on how to install and configure open source exporters that are not supported by Managed Service for Prometheus. In this example, MySQL is used.

For more information about the exporters of open source Prometheus, see Exporters and integrations.

Prerequisites

Procedure

The following figure describes how to use Managed Service for Prometheus to monitor a MySQL database.

How It Works

Step 1: Deploy an application

To capture MySQL data in an ACK cluster, you must deploy the mysqld-exporter image that is provided by open source Prometheus to the ACK cluster. To deploy the mysqld-exporter image, perform the following operations:

  1. Log on to the ACK console.
  2. In the left-side navigation pane, click Clusters.

  3. On the Clusters page, find the cluster to which you want to deploy the application and click Applications in the Actions column.

  4. Create a container group.

    1. In the left-side navigation pane, choose Workloads > Deployments.

    2. On the Deployments page, click Create from YAML in the upper-right corner.

    3. On the Create page, enter the following code in the Template code editor and click Create:

      Note

      Replace the values of <yourMySQLUsername>, <yourMySQLPassword>, <IP>, and <port> with the actual values of the MySQL database.

      apiVersion: apps/v1 # for versions before 1.8.0 use apps/v1beta1
      kind: Deployment
      metadata:
        name: mysqld-exporter
        labels:
          app: mysqld-exporter
      spec:
        replicas: 1
        selector:
          matchLabels:
            app: mysqld-exporter
        template:
          metadata:
            labels:
              app: mysqld-exporter
          spec:
            containers:
            - name: mysqld-exporter
              imagePullPolicy: Always
              env:
                - name: DATA_SOURCE_NAME
                  value: "<yourMySQLUsername>:<yourMySQLPassword>@(<IP>:<port>)/"
              image: prom/mysqld-exporter
              ports:
              - containerPort: 9104
                name: mysqld-exporter

    The newly created container group is displayed on the Deployments page. mysqld-exporter application

  5. Create a Service.

    1. In the left-side navigation pane, choose Network > Services.

    2. On the Services page, click Create Resources in YAML.

    3. On the Create page, enter the following code in the Template code editor and click Create:

      apiVersion: v1
      kind: Service
      metadata:
        labels:
          app: mysqld-exporter
        name: mysqld-exporter
      spec:
        ports:
        - name: mysqld-exporter
          port: 9104
          protocol: TCP
          targetPort: 9104
        type: NodePort
        selector:
          app: mysqld-exporter

    The newly created Service is displayed on the Services page. mysqld-exporter service

Step 2: Configure service discovery

To configure service discovery of Managed Service for Prometheus to receive data from the MySQL database, perform the following steps:

Important
  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 that you want to manage. In the left-side navigation pane of the page that appears, click Settings.
  4. In the left-side navigation pane, click Service Discovery. On the Service Discovery page, click the Configure tab. Then, click the ServiceMonitor tab.

  5. On the ServiceMonitor tab, click Add ServiceMonitor.

  6. In the Add ServiceMonitor dialog box, enter the following code and click OK:

    apiVersion: monitoring.coreos.com/v1
    kind: ServiceMonitor
    metadata:
      # Enter a unique name.
      name: tomcat-demo
      # Enter a namespace.
      namespace: default
    spec:
      endpoints:
      - interval: 30s
        # Enter the value of the Name field of the Port parameter of the Prometheus exporter in the service.yaml file.
        port: tomcat-monitor
        # Enter the path of the Prometheus exporter.
        path: /metrics
      namespaceSelector:
        any: true
        # The namespace of the NGINX demo application.
      selector:
        matchLabels:
          # Enter the value of the Label field in the service.yaml file to find the service.yaml file.
          app: tomcat

    The configured service discovery task is displayed on the ServiceMonitor tab. mysqld-exporter-ServiceMonitor

Step 3: Configure a Grafana dashboard

To configure a Grafana dashboard to display data, perform the following steps:

  1. Go to the homepage of Grafana dashboards.

    Note

    You must activate Grafana Pro Edition.

  2. In the left-side navigation pane, choose image.png > Import.

  3. On the Import page, enter 7362 in the Import via grafna.com field and click Load next to the field. 7362 is the ID of the MySQL Grafana template provided by Prometheus.

    Import Grafana Dashboard
  4. On the Import page, perform the following operations and click Import:

    Import Grafana Dashboard with Options
    1. Enter a dashboard name in the Name field.

    2. Select your ACK cluster from the Folder drop-down list.

    3. Select your ACK cluster from the prometheus drop-down list.

    The following figure shows the configured Grafana dashboard. ARMS Prometheus Grafana MySQL

Step 4: Create an alert rule

To create an alert rule to monitor a metric, perform the following steps:

  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 that you want to manage. In the left-side navigation pane of the page that appears, click Alert Rules.
  4. On the Prometheus Alert Rules page, click Create Prometheus Alert Rule. On the page that appears, set the parameters as prompted. For more information, see Create an alert rule for a Prometheus instance.