theprogrammerin
/ slowquery_logger.sh
Created
November 26, 2014 09:31
Bash script to fetch the log for that hour from Amazon RDS and push it to ElasticSearch / Kibana
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # Ashutosh Agrawal | |
| # http://blog.theprogrammer.in | |
| # | |
| # | |
| # This bash script simply fetches the log for that hour from Amazon RDS, | |
| # parse and genarlise it using mysql_slow_log_parser (https://gist.github.com/theprogrammerin/e3206a4ec7a7a4086ac2) | |
| # and then push the parsed log to elastic search using logstash (slowquery.conf)(https://gist.github.com/theprogrammerin/034a3efd849112d166ea) | |
| # For analysis on analytic tool like kibana. |