MySQL is a widely used relational database management system worldwide. It is known for its simplicity, performance, and reliability. MySQL offers a range of features, including full SQL support, the ability to handle large volumes of data, scalability, and support for ACID transactions (Atomicity, Consistency, Isolation, and Durability). It is commonly used in web applications, content management systems, e-commerce systems, and many other data storage scenarios. MySQL is an open-source solution but is also offered as a managed service by cloud providers, making it easier to deploy and manage MySQL databases in different environments.
How to Monitor a MySQL DB on the One Platform
To set up monitoring for MySQL on the platform, follow these steps:
-
Go to the product application where you want to add MySQL as a dependency in the platform.
-
Click on the “Products” menu and select the desired product card.
-
Then, click on the name of the specific application where you want to configure MySQL monitoring.
-
Look for the section called “External Dependencies,” usually located just below the latency graph of the application.
-
To add an already registered dependency, type the name of the dependency in the search field and select it when it appears in the list.
-
If MySQL is not yet registered as a dependency, click on the green button with a plus (+) symbol to add a new dependency.
Click “Add” and a modal will appear allowing you to name the database and select the Environment. In the “Check type” field, choose the option “DB,” and in the “Method” field, select “MySQL.” After selecting the method, a field for the Healthcheck URL will appear.
Below is an example of string for Postgres:
e.g., USER:PASSWORD@tcp(HOST:PORT)/DATABASE
Note: For security reasons, it is not permitted to enter an IP in the healthcheck field. To monitor an IP, you need to enter it in a secret and use it in healthcheck