Multiple MySQL instances

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: 

  1. Download and install the latest version of the Site24x7 Linux agent

After successful installation, you will see the Linux server monitor in the Site24x7 Control Panel. This confirms that the agent can communicate with our data center.

  1. Download the mysql.py and mysql.cfg files from the GitHub repository.

  2. Configure the host, port, username, and password in your mysql.cfg file.

  3. 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.
      [instance_name]

      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

    • What is a plugin template and a plugin monitor?

      Plugin Template:A plugin template is a set of attributes to be monitored.  Example: mysql.py file consisting of attributes like slow queries, reads, writes etc Plugin Monitor: A monitor that uses a plugin template for monitoring purposes Example: The ...
    • What do I get for one basic server monitor added?

      Each server (irrespective of CPU/RAM) is a Basic Monitor. For every server monitor added, the following will be included: One minute polling frequency Server uptime with special false alert protection More than 60 performance metrics including CPU, ...
    • Possible reasons why my Linux plugin has not been added to my Site24x7 account

      Check if the Site24x7 Linux monitoring agent version is above 15.0.0. You can check your agent version in the Summary tab of your server monitor, below the display name. The python directory path installed in the user's machine should match the path ...
    • Possible reasons why my Windows plugin is not added to my account

      The following are the possible list of cases where a Windows plugin monitor will not be configured to your Site24x7 account: Check if the version of the Site24x7 Windows monitoring agent is above 15.5.0 Ensure script is in Batch, VB, PowerShell or ...
    • Can I associate a threshold profile to multiple server monitors in one go?

      Yes, you can bulk associate a threshold profile to multiple server monitors in one go. Use Case: A user has 20 servers for monitoring. The account has a threshold profile "Server" created. Now, the user wants to associate the profile "Server" to 15 ...