MySQL Logs Monitoring

​

Setup & Configuration

1. Add the following lines in the file /etc/atatus-infra-agent/atatus.yml.
   logs_enabled: true
   
2. Copy the mysql example configuration file.
   cd /etc/atatus-infra-agent/conf.d/mysql.d/
   sudo cp mysql.yml.template mysql.yml
   
3. Update the file /etc/atatus-infra-agent/conf.d/mysql.d/mysql.yml with below configurations.
   # Log section
   logs:
   
     # - type : (mandatory) type of log input source (error / slowlog)
   
     - type: error
     - type: slowlog
   
   # If you have custom mysql log path, you can use below syntax
   
     # - type: (mandatory) type of log input source (error / slowlog)
     #   paths: (mandatory) Set paths if type is file
     #   service: (mandatory) name of the service owning the log
     #   source: (mandatory) attribute that defines which integration is sending the log
   
   # Log section
   logs:
      - type: error
        paths:
           - /var/log/mysql/error.log*
           - /var/log/mysqld.log*
        source: mysql
        service: mysql
      - type: slowlog
        paths:
           - /var/log/mysql/mysql-slow.log*
        source: mysql
        service: mysql
   
4. Restart the atatus infrastructure agent.
   sudo service atatus-infra-agent restart