I have this problem or rather an itch that I could really use help with. I use autoscale and several instances on Amazon. Problem is I have all these logs PHP, Apache, system but also my web app generating traffic logs etc etc. I want to consolidate all these logs. I know syslogd etc exist, but I was wondering whats the most effective , low administrative solution devops are using currently since my experience on Amazon AWS isn't that extensive. Plus I need the solution to be low resource usage if possible. Hitting database to save all that data every second is not a good solution for me.
Please note I am NOT talking about system monitoring which is served by CloudWatch etc. more for the applications and servers running as well as writing custom application logs. Also all systems are assumed to be Redhat Linux.
Any help or direction is appreciated.