This is a guest blog from Troy Davis of Papertrail, a SoftLayer Tech Marketplace Partner that helps customers detect, resolve and avoid infrastructure problems using log messages.
Tech Partners Marketplace: http://www.softlayer.com/marketplace/papertrail
Receive DB Slow Query Logs in Your Inbox
Want to wake up to important database and syslog messages with your bagel and coffee? Here’s how. It’s free and takes about 5 minutes.
Most of us run a database somewhere on our SoftLayer servers. Whether it’s MySQL, PostgreSQL, SQL Server, or another relational or NoSQL sibling, a responsive data store is critical to happy users. That’s why databases send slow queries to a log file. It’s much better than no logging at all, but as an engineer, I’d wanted more. I wanted to:
- View all my query logs in one place, without SSHing to each server for tail and grep. My workload shouldn’t scale linearly as I add systems
- Share log visibility with employees who don’t have server access or command-line knowledge (and email links to specific log messages to my developers and DBAs)
- Receive log messages in my inbox – or send them to my team or monitoring service – when I know they need attention
- Examine logs for related HTTP requests, daemon output, API invocations, and other parts of our stack — I can troubleshoot faster with start-to-finish logs on a single screen.
That’s where Papertrail was born. We built Papertrail to make log aggregation and log management effortless and usable. It’s the hosted log management service that we wanted as developers, systems engineers and tech entrepreneurs.
We know the hesitation you might have when approaching this kind of service, so our goal was to enable users to have Papertrail deliver those SQL slow query logs – or any other logs – to your inbox every morning for free: