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 ...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 ...Monitor and validate DNS IP changes using regex
DNS administrators often monitor their DNS servers to detect changes in domain resolution and ensure IP mappings remain secure and accurate. Problem When your organization adds or modifies an IP address for your domain name, it’s critical to: Be ...Difference between a website monitor and a SOAP Web Service monitor
Website monitor will support monitoring of any web application via POST, GET and HEAD methods of configuration. Learn more on the performance metrics provided for a website monitor. SOAP Web Service monitors , on the other hand, lets you to ...Monitor websites that require a HTTP POST to determine availability
You can monitor websites that require HTTP POST to determine availability. You can configure HTTP request methods to be passed (POST/GET/HEAD/POST XML) under the HTTP Configuration while adding a monitor itself. Log in to the Site24x7 client and ...