# Prometheus MySQL Exporter

How to Integrate **Prometheus MySQL Exporter** with **Apica Ascent:**

### 1. Introduction

This guide explains how to send MySQL metrics from Prometheus mysqld\_exporter to Apica Ascent, and how to monitor and visualize them.

You'll learn:

* How to install and run MySQL Exporter
* How to configure Prometheus to scrape MySQL metrics
* How to connect Prometheus with Apica Ascent
* How to visualize metrics in dashboards

### 2. Install and Run MySQL Exporter

Follow the official documentation for installation [here](https://github.com/prometheus/mysqld_exporter).

* Create a dedicated user:

```
CREATE USER 'mysqld_exporter'@'127.0.0.1' IDENTIFIED BY 'yourpassword';
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'mysqld_exporter'@'127.0.0.1';
FLUSH PRIVILEGES;
```

* Create .my.cnf:

```
[client]
user=mysqld_exporter
password=yourpassword
host=127.0.0.1
port=3306
```

* Run exporter

```
Default metrics endpoint: http://localhost:9104/metrics
```

### 3. Configure Prometheus to Scrape MySQL Exporter

Update prometheus.yml:

```
scrape_configs:
  - job_name: 'mysql'
    static_configs:
      - targets: ['localhost:9104']
```

Restart Prometheus and verify on /targets.

### 4. Connect Prometheus to Apica Ascent

Add remote\_write to prometheus.yml:

```
remote_write:
  - url: "https://<your-ascent-env>/v1/receive/prometheus"
    tls_config:
      insecure_skip_verify: true
    authorization:
      type: "Bearer"
      credentials: "<YOUR_INGEST_TOKEN>"
```

* [More on remote\_write](https://docs.apica.io/integrations/list-of-integrations/prometheus/prometheus-remote-write)&#x20;
* [Generate an ingest token](https://docs.apica.io/integrations/overview/generating-a-secure-ingest-token)&#x20;

Optional: Relabel metrics for easier identification:&#x20;

```
write_relabel_configs: 
  - action: replace 
    source_labels: [__name__] 
    regex: "(.*)" 
    target_label: __name__ 
    replacement: "ascent_$1" 
```

This will rename metrics to ascent\_\<metric-name> before sending them.&#x20;

### 5. Verify Metrics in Apica Ascent

**Log in → Queries → New Query**

Run:

```
mysql_up
mysql_global_status_threads_connected
mysql_global_status_queries
```

Check results populate.

### 6. Example Dashboards

You can use this Ascent dashboard to get started.

### 7. Troubleshooting

* Exporter error: Check .my.cnf path and permissions.
* Access denied: Verify MySQL user and grants.
* Prometheus not scraping: Validate prometheus.yml.
* Metrics not in Apica: Check remote\_write URL and token.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.apica.io/integrations/list-of-integrations/prometheus/prometheus-mysql-exporter.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.