Sumologic

MySQL

To monitor MySQL, enter the corresponding port number in data.json and username and password for a monitoring user. If unspecified, the default values as below will be used.

"mysql": {
     "port": 3306,
     "username": "",
     "password": "",
     "enableperfschema": false,
     "schemas": []
 }

If your MySQL version is atleast 5.6.0 and you have enabled performance schema, you have the option of monitoring useful metrics like query latency and query throughput per schema. This can help you boil down to a problematic schema in case of an incident. To enable monitoring, you can set enableperfschema to true in the config file, and specify the schemas you wish to monitor in the schemas field.

Creating a monitoring user

It is recommended to create a user having read only access to the stats tables.

Creating a monitoring user:

CREATE USER 'archagent'@'127.0.0.1' IDENTIFIED BY 'archagent';
GRANT REPLICATION CLIENT ON *.* TO 'archagent'@'127.0.0.1' WITH MAX_USER_CONNECTIONS 5;
GRANT PROCESS ON *.* TO 'archagent'@'127.0.0.1';
GRANT SELECT ON performance_schema.* TO 'archagent'@'127.0.0.1';

Replace the password & username values as per your preference.

Having updated data.json on your server (no need to restart archagent), enable this plugin from the server's rule config page. Set thresholds for metrics that you care about and want to be alerted on. Enabling a plugin.

Details on individual metrics can be found here.

results matching ""

    No results matching ""