Skip to content

MySQL

MySQL Monitor in MCT is a type of synthetic check that assesses the health and performance of MySQL databases. This monitor simulates connections to MySQL instances, executes queries to verify data consistency, and checks the database's overall state to ensure it is functioning as expected.

label: language:java; os:alma8

Configuration

Required

  • MySQL URL: the URL of the MySQL instance
  • Database Name: the name of the database to connect to

Optional

  • Username: the username to use for authentication, if required
  • Password: the password to use for authentication, if required
  • Query: the MySQL query to execute for health check, default is SELECT 1
  • Expected Response: the expected response from the MySQL query, default is 1
  • Timeout: the timeout for the MySQL connection and query execution, optional