Amazon RDS
Papertrail can aggregate query logs from Amazon Relational Database Service (RDS), a hosted MySQL database service.
Introduction
By default, Amazon RDS outputs slow query logs to a table in the RDS instance called mysql.slow_log
. If configured, all queries can be logged to mysql.general_log
. Here’s more.
Two methods exist to send RDS logs to Papertrail:
- William Cheung has created a standalone Play Framework app that retrieves these logs from RDS instances and aggregates them in Papertrail.
- Joe Shaw created a standalone Go app called rdstail to stream logs to Papertrail.
Play ptmysqllog relay app
To set up the Play app, read the README and watch this video:
Aggregating Amazon RDS query logs in Papertrail
In addition to the client-side filtering covered in the video, Papertrail can filter unnecessary messages. See log filtering.
Go rdstail relay app
For setup information, visit rdstail README.