> ## Documentation Index
> Fetch the complete documentation index at: https://docs.germainux.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Deploy Monitoring for MySQL with GermainUX

> Deploy GermainUX monitoring for MySQL to monitor database availability, performance, queries, connections, storage, and errors.

Components
[`Engine`](https://docs.germainux.com/main/germain-ux-engine)
[`JS Profiler`](https://docs.germainux.com/main/germain-ux-js-profiler)
[`RPA Bot Recorder`](https://docs.germainux.com/main/germain-ux-rpa-bot-recorder)
[`RUM JS`](https://docs.germainux.com/main/germain-ux-rum-js)

Availability
2017.1 or later

> **[Create a MySQL Monitoring Account](#1-create-a-mysql-monitoring-account)**
>
> Least-privilege database account

> **[Add MySQL as a Data Source](#3-add-mysql-as-a-data-source)**
>
> Connect MySQL instance

> **[Configure the Monitoring Schedule](#6-configure-the-monitoring-schedule)**
>
> Set check frequency

> **[MySQL / RDS Requirements](#mysql-/-rds-requirements)**
>
> Check RDS prerequisites

**Deploy Monitoring for MySQL**

Deploy GermainUX monitoring for MySQL to monitor database availability, performance, queries, connections, storage, errors, and application-specific database conditions.

> [!NOTE]
>
> MySQL monitoring is executed by the **GermainUX Engine** using a database connection to the monitored MySQL instance.

## 1. Create a MySQL Monitoring Account

Create or select a database account for GermainUX monitoring.

![Deploy Monitoring for MySQL with GermainUX: 1. Create a MySQL Monitoring Account](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/deploy-monitoring-for-mysql-with-germainux/image2023-2-21_10-33-32.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=930931e3389f1ec77fd99da26b6f5f63)

For basic monitoring, use an account with permission to connect to the required MySQL instance and access the database information required by the monitors you intend to deploy.

Additional permissions may be required when monitoring:

* MySQL system tables
* Performance information
* Application tables
* Business data
* Custom database conditions

Apply the minimum permissions required for your monitoring scope.

## 2. Add the Database Credentials

In Germain Workspace, navigate to:

Germain Workspace
Left Menu
Settings
Data Sources
Credentials

Add the credentials used by GermainUX to connect to MySQL.

These credentials will be referenced by the MySQL database data source.

![Deploy Monitoring for MySQL with GermainUX: 2. Add the Database Credentials](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/deploy-monitoring-for-mysql-with-germainux/image-20230221-140323.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=719226bd558e6c8acb2b9331b3543790)

## 3. Add MySQL as a Data Source

Navigate to:

Germain Workspace
Left Menu
Settings
Data Sources
Database
Add New Configuration

Configure the connection to the MySQL instance.

Enter the connection information required for your environment and associate the appropriate database credentials.

![Deploy Monitoring for MySQL with GermainUX: 3. Add MySQL as a Data Source](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/deploy-monitoring-for-mysql-with-germainux/image-20230221-140419.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=0a55df8eef0394a345960fdd1ac8c47a)

## 4. Validate Database Connectivity

Verify that GermainUX can connect to the MySQL instance using the configured data source and credentials.

Confirm that the monitoring account can access the database tables or system information required for the monitoring capabilities you intend to enable.

Resolve connectivity, authentication, or permission issues before configuring individual monitors.

## 5. Select the Monitoring Node & Engine

MySQL monitoring executes from a GermainUX Engine.

When deploying a monitor, configure:

**Monitoring Node** \
 The GermainUX Node from which the Engine operates.

**Engine** \
 The GermainUX Engine that will execute the monitor.

Ensure that the selected Engine has network connectivity to the MySQL instance.

## 6. Configure the Monitoring Schedule

Define how frequently the MySQL monitor should execute.

Choose a monitoring frequency appropriate for:

* The condition being monitored
* Required detection speed
* Database workload
* Query complexity
* Operational requirements

Use higher-frequency monitoring selectively for conditions requiring rapid detection.

## 7. Validate the Deployment

After deployment, confirm that:

* GermainUX can connect to MySQL
* Credentials are valid
* Required permissions are available
* The selected Engine can execute the monitor
* Monitoring executes according to schedule
* Expected telemetry is received

Verify the deployed monitor in:

**Germain State**

## Next Steps

Once the MySQL connection is operational, configure the metrics and conditions relevant to your environment.

For example:

* Database availability
* Query performance
* Connections
* Storage utilization
* Backup status
* Errors

> **Show all 9**
>
> * Custom SQL queries
> * Application-specific database KPIs
> * SLAs and alerts

See **Configure Monitoring for MySQL** for configuration instructions.

## MySQL / RDS Requirements

Some MySQL environments may require additional database or platform configuration before all monitoring information is accessible.

For example, managed MySQL services such as Amazon RDS may restrict access to certain system information or require platform-specific settings.

Configure only the permissions and platform settings required for the monitoring capabilities being deployed.

![Deploy Monitoring for MySQL with GermainUX: MySQL / RDS Requirements](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/deploy-monitoring-for-mysql-with-germainux/image2017-7-3_9-23-8.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=98553e9a57db34d4b15e530956cb23e3)

## Get More Information

The required MySQL permissions depend on the database information and application data you choose to monitor.

The GermainUX team can help determine the appropriate database account permissions, data source configuration, monitoring Engine, and deployment architecture for your environment.

Please contact us [for any help.](https://docs.germainux.com/main/support.md)

## Get Help

> **[Contact GermainUX Support](https://docs.germainux.com/main/support.md)**
>
> The Germain Team can help you set this up.

> **Can't find what you need?**
>
> Search all GermainUX docs with **Ctrl + K**, or use the feedback buttons at the bottom of this page to tell us what is missing.

The content of this document is proprietary to GERMAIN SOFTWARE.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.