Monitor multiple MySQL instances from one plugin
You can monitor multiple MySQL instances using a single plugin. You can configure the input data like the MySQL hostname, password, and other details in the mysql.cfg file. This enables multiple instance monitoring using the same plugin without changing the plugin script.
To monitor multiple instances of MySQL using the MySQL plugin, follow the steps below:
Download and install the latest version of the Site24x7 Linux agent.
Download the mysql.py and mysql.cfg files from the GitHub repository.
Configure the host, port, username, and password in your mysql.cfg file.
Then, add a new section with the instance name for identification in the mysql.cfg file.
[instance_name]
host = localhost
port = 3306
username = test
password = your_password
Any field with a name password will be automatically encrypted once the server agent picks it up. The field will subsequently change to an encrypted password.host = localhost
port = 3306
username = test
encrypted password = hash_for_your_password_created_by_site24x7
The agent will start executing the plugin with the defined configuration setup of mysql.cfg. For each configuration, the agent will add a MySQL plugin monitor for each MySQL instance. You can find the instances of MySQL by their respective instance names appended to the plugin monitor name.
Related Articles
Troubleshoot the "pymysql module not found" error when installing the MySQL plugin
If you're encountering the pymysql module not found error, it likely means that the pymysql Python library is not installed on the server. pymysql is a Python package that provides a way to interact with MySQL databases using Python code and is used ...How is the basic and advanced monitor count calculated in the Site24x7 web client?
Site24x7 licensing and pricing works based on the type of monitor. Monitors are classified as basic and advanced monitors. The Super Admins can view a detailed breakdown of license usage with License Usage Summary. The monitors in your Site24x7 ...No data for service and process in Windows server monitor
If you see "No Data" for process and service metrics (such as CPU or memory usage of monitored services) in the Site24x7 Windows server monitor user interface, follow the troubleshooting steps below. Run PowerShell Commands Open PowerShell as ...Amendments to Site24x7 Monitor Names
We've recently renamed a few of our Monitors to help keep in sync with the current IT and DevOps trends. The new monitor names are designed to correctly resonate with the IT & DevOps crowd. We've made necessary changes in the Web client, Help ...Steps to partially update monitor settings in bulk using API
Monitor details like notification profiles, threshold and availability can be changed/updated in bulk using API without affecting the existing configuration settings. Use Case: A user wants to change only the notification profile of a monitor without ...