logzio/mysql-logs repository overview

Docker hub repository⁠

⁠Usage (docker run)

docker run -d --name logzio-mysql-logs -e LOGZIO_TOKEN=VALUE [-e LOGZIO_LISTENER=VALUE] \
          [-e MYSQL_ERROR_LOG_FILE=VALUE] [-e MYSQL_SLOW_LOG_FILE=VALUE] [-e MYSQL_LOG_FILE=VALUE] \
          -v path_to_directory:/var/log/logzio -v path_to_directory:/var/log/mysql \
          logzio/mysql-logs:latest

⁠Mandatory

LOGZIO_TOKEN - Your Logz.io App⁠ token, where you can find under "settings" in the web app.

⁠Optional

MYSQL_ERROR_LOG_FILE - Path to mysql error log. Default: /var/log/mysql/error.log MYSQL_SLOW_LOG_FILE - Path to mysql slow query log. Default: /var/log/mysql/mysql-slow.log MYSQL_LOG_FILE - Path to mysql general log. Default: /var/log/mysql/mysql.log LOGZIO_LISTENER - Logzio listener host name. Default: listener.logz.io

⁠Example

docker run -d \
  --name logzio-mysql-logs \
  -e LOGZIO_TOKEN="YOUR_TOKEN" \
  -v /path/to/directory/logzio:/var/log/logzio \
  -v /path/to/directory/mysql:/var/log/mysql \
  --restart=always \
  logzio/mysql-logs:latest

⁠RDS Usage (docker run)

docker run -d --name logzio-mysql-logs -e LOGZIO_TOKEN=VALUE [-e LOGZIO_LISTENER=VALUE] \
          -e AWS_ACCESS_KEY=VALUE -e AWS_SECRET_KEY=VALUE -e RDS_IDENTIFIER=VALUE [-e AWS_REGION=VALUE] \
          [-e RDS_ERROR_LOG_FILE=VALUE] [-e RDS_SLOW_LOG_FILE=VALUE] [-e RDS_LOG_FILE=VALUE] \
          -v path_to_directory:/var/log/logzio -v path_to_directory:/var/log/mysql \
          logzio/mysql-logs:latest

⁠Mandatory

LOGZIO_TOKEN - Your Logz.io App⁠ token, where you can find under "settings" in the web app. AWS_ACCESS_KEY - A proper AMI credentials for RDS logs access (permissions for download-db-log-file-portion and describe-db-log-files are needed) AWS_SECRET_KEY - A proper AMI credentials for RDS logs access (permissions for download-db-log-file-portion and describe-db-log-files are needed) RDS_IDENTIFIER - The RDS identifier of the host from which you want to read logs from.

⁠Optional

RDS_ERROR_LOG_FILE - The path to the RDS error log file. Default: error/mysql-error.log RDS_SLOW_LOG_FILE - The path to the RDS slow query log file. Default: slowquery/mysql-slowquery.log RDS_LOG_FILE - The path to the RDS general log file. Default: general/mysql-general.log LOGZIO_LISTENER - Logzio listener host name. Default: listener.logz.io INTERVAL_SECONDS - RDS Sync interval. Default: 60 seconds AWS_REGION - Default: us-east-1

⁠RDS Example

docker run -d \
  --name logzio-mysql-logs \
  -e LOGZIO_TOKEN="YOUR_TOKEN" \
  -e AWS_ACCESS_KEY="YOUR_ACCESS_KEY" \
  -e AWS_SECRET_KEY="YOUR_SECRET_KEY" \
  -e AWS_REGION="YOUR_REGION" \
  -e RDS_IDENTIFIER="YOUR_DB_IDENTIFIER" \
  -e RDS_ERROR_LOG_FILE=error/mysql-error.log \
  -e RDS_SLOW_LOG_FILE=slowquery/mysql-slowquery.log \
  -e RDS_LOG_FILE=general/mysql-general.log \
  -v /var/log/logzio:/var/log/logzio \
  -v /var/log/mysql:/var/log/mysql \
  logzio/mysql-logs:latest

⁠Screenshots of dashboard from Logz.io

⁠About Logz.io

Logz.io⁠ combines open source log analytics and behavioural learning intelligence to pinpoint what’s actually important