Configure MySQL database integration

The health state feature is not supported for MySQL integrations. It will be supported in a future update.

To integrate MySQL with SolarWinds Observability SaaS:

1. In SolarWinds Observability SaaS, click Add Data at the top.

2. In the Add Data dialog Intro, click the Integrations tab, and then click MySQL.

3. In the Add MySQL DB dialog, select a host with the SolarWinds Observability Agent you want to use for MySQL and click Next.

   To display only Agents running in a Kubernetes cluster, click the List only Agents... toggle.

   If you want to install a dedicated Agent on a dedicated host, add the host and then add the MySQL integration. See Add a self-managed host.

   If you prefer using Docker, see Run the SolarWinds Observability Agent as a Docker image or Kubernetes deployment.

4. Select where MySQL is located:

   • On Host: MySQL runs on the same physical or virtual machine as the Agent.

   • Off Host: MySQL runs on a different physical or virtual machine than the Agent.

5. Provide the user name, copy the script, and run it on the MySQL.

   Collecting MySQL metrics requires that the account used to collect the data has access to appropriate tables. If the account cannot access the tables, relevant metrics will not be collected.

6. Specify credentials to be used for authenticating the MySQL integration in SolarWinds Observability SaaS.

   • Add New Credential

     Select this option to create new credentials. Provide a name for the credentials set and the requested details, such as password, API key, and client secret.

   • Use Existing Credential

     Select this option to use existing credentials. Select credentials from the list.

7. Review the configuration and click Deploy to deploy the changes to the agent.

   1. If you are onboarding AWS, select Amazon RDS MySQL. For on-premises, select MySQL.

   2. Select the Database Deployment Type as MySQL or Amazon RDS MySQL.

   3. Provide a Display Name.

   4. Review the Collection Interval. The default is 30 seconds.

   5. In the DBMS Instance Address field, add the IP/FQDN of the server with the port number as <IP/FQDN>:<Port>.

8. To use encrypted communication between the Observability Agent and MySQL, toggle the SSL Enabled option to On.

   When SSL is enabled, you can also specify the SSL Mode.

   SSL Mode:

   • Verify Full: The highest verification level. Ensures the server certificate is valid, trusted, and that the hostname matches the certificate.

   Certificates related:

   • SSL Authority Path

     Specify the location of the Certificate Authority (CA) file used to verify the authenticity of the MySQL server’s SSL certificate.

     The file must contain PEM-encoded data.

     Example paths:

     /etc/solarwinds/certs/ca.pem
C:\ProgramData\SolarWinds\UAMSClient\plugin-storage\ca.pem

   • SSL Certificate Path

     Provide the location of the client’s public key certificate file, which is used for mutual authentication between the client and the MySQL server.

     The file must contain PEM-encoded data.

     Example paths:

     /etc/solarwinds/certs/client_cert.pem
C:\ProgramData\SolarWinds\UAMSClient\plugin-storage\client_cert.pem

   • SSL Key Path

     Enter the location of the client’s private key file that corresponds to the client certificate.

     The file must contain encoded data and should be securely stored.

     Example paths:

     /etc/solarwinds/certs/client_cert.key
C:\ProgramData\SolarWinds\UAMSClient\plugin-storage\client_cert.key

When the installation is complete, you can continue to observe MySQL data. Use the buttons on the Summary screen.

To view metrics collected for MySQL, click Analyze > Metrics and search for mysql. See Metrics Explorer for details.