No commit activity in last 3 years
No release in over 3 years
Amazon RDS slow_log and general_log input plugin for Fluent event collector
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
 Dependencies

Development

>= 10.0.4, ~> 10.0
~> 3.2

Runtime

< 2, >= 0.14.0
~> 0.4.1
 Project Readme

Amazon RDS (for MySQL) input plugin for Fluentd

Gem Version

Overview

  • Amazon Web Services RDS(MySQL) general_log and slow_log input plugin.

Installation

$ fluent-gem install fluent-plugin-rds-log

Maybe, you also need the following packages

  • MySQL-shared
  • MySQL-shared-compat
  • MySQL-devel

RDS Setting

Working with MySQL Database Log Files / aws documentation

  • Set the log_output parameter to TABLE to write the logs to a database table.
  • Set the slow_query_log parameter to 1
  • Set the general_log parameter to 1
  • setting min_examined_row_limit
  • setting long_query_time

Configuration

<source>
  type rds_log
  log_type <slow_log | general_log>
  host <RDS Hostname1>,<RDS Hostname2>,<RDS Hostname3>.. # multiple database servers(comma separated)
  username <RDS Username>
  password <RDS Password>
  refresh_interval <number>
  auto_reconnect <true|false>
  tag <tag-name>
  add_host false # add database hostname in record
  where <condition> #option
</source>

Example GET RDS general_log

<source>
  type rds_log
  log_type general_log
  host endpoint.abcdefghijkl.ap-northeast-1.rds.amazonaws.com
  username rds_user
  password rds_password
  refresh_interval 30
  auto_reconnect true
  tag rds-general-log
  add_host false # add database hostname in record
  where argument LIKE '%sample_table%'
</source>

<match rds-general-log>
  type file
  path /var/log/rds-general-log
</match>

Changes

0.3.0

  • require fluentd version 0.14.0