I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?
By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials.
New databases can be added for monitoring by using the steps below:
From the Site24x7 web console, navigate to Database > MySQL > Instance name in which the new database resides.
In the Database tab of the MySQL monitor instance, click Discover Databases. Now, you can add or remove databases.
Related Articles
Can I add all the databases in my MySQL server as monitors?
For now, Site24x7 has limited 200 databases for individual database monitoring. To check the feasibility of monitoring more databases, please contact support@site24x7.com. Check this page to learn more about how licensing is done for MySQL ...How is MySQL added for monitoring in Site24x7?
Site24x7 uses the server monitoring agent to monitor MySQL databases. To install the Site24x7 Server monitoring agent, follow the below steps: Log in to Site24x7. Install the Linux Server monitoring agent by navigating to Server > Server Monitor > ...MySQL monitoring FAQs
Please find below some common FAQ's related to MySQL monitoring from Site24x7: Does Site24x7 need write permission to access databases? No. Site24x7 needs SELECT permission for performance_schema, information_schema, and EXECUTE permission for sys ...No Data for some of the metrics in MySQL 5.6/MariaDB 10.5
You might not be able to view the data for some of the metrics in MySQL or MariaDB monitors because the sys schema is not present in MariaDB version 10.5 and below and MySQL version 5.6 and below. As a result, Site24x7 MySQL individual database ...How to set thresholds for MySQL databases?
From the Site24x7 web console, navigate to Database > MySQL > Instance Name to which you wish to add thresholds. Click the hamburger icon near the instance name and then click Edit. Navigate to Threshold and Availability under Configuration Profiles ...