> For the complete documentation index, see [llms.txt](https://docs.apica.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.apica.io/integrations/list-of-integrations/prometheus/prometheus-mysql-exporter.md).

# 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.