github.com/observiq/bindplane-agent@v1.51.0/config/google_cloud_exporter/mysql/README.md (about)

     1  # Mysql Metrics with Google Cloud
     2  
     3  The Mysql Receiver can be used to send Mysql metrics to Google Cloud Monitoring.
     4  
     5  ## Limitations
     6  
     7  The agent must be installed on the Mysql system.
     8  
     9  ## Prerequisites
    10  
    11  See the [documentation](https://github.com/observIQ/bindplane-agent/blob/main/docs/receivers.md) for Mysql prerequisites.
    12  
    13  See the [prerequisites](../README.md) doc for Google Cloud prerequisites.
    14  
    15  ## Authentication Environment Variables
    16  
    17  The configuration assumes the following environment variables are set:
    18  - `MYSQL_USERNAME`
    19  - `MYSQL_PASSWORD`
    20  
    21  Set the variables by creating a [systemd override](https://wiki.archlinux.org/title/systemd#Replacement_unit_files).
    22  
    23  Run the following command
    24  ```bash
    25  sudo systemctl edit observiq-otel-collector
    26  ```
    27  
    28  If this is the first time an override is being created, the file will be empty. Paste the following contents into the file. If the `Service` section is already present, append the two `Environment` lines to the `Service` section.
    29  
    30  Replace `otel` with your Mysql username and password.
    31  ```
    32  [Service]
    33  Environment=MYSQL_USERNAME=otel
    34  Environment=MYSQL_PASSWORD=otel
    35  ```
    36  
    37  After restarting the agent, the configuration will attempt to use the username:password `otel:otel`.
    38  
    39  ```bash
    40  sudo systemctl restart observiq-otel-collector
    41  ```