Amazon RDS Performance Insights vs. Icinga

When you need to monitor your database at low level metrics such as query load or CPU usage at some point in time. You can also use it to understand which component is a heavy load on your DB. It is a great tool for routine monitoring of your DB and to help plan for capacity. I would not use it as an exclusive source for scaling your DB though since the is not long-term or very granular data to be able to run a thorough analysis on peaks of predictive analysis.

Incentivized

Icinga is a world-class monitoring system. It can be used for most general monitoring situations. It is not a silver bullet, however, and there are instances where domain-specific monitoring systems are necessary. However, the output from those monitoring systems can be funneled into Icinga as a central monitoring and alerting system.

Incentivized

• RDS Infrastructure Metrics
• RDS Logical Metrics
• Real time visualization of query load
• Identify Performance Bottlenecks
• Historical Performance Analysis of load

Incentivized

• Wealth of community-developed plugins.
• Stable codebase.
• Icinga 2 supports distributed monitoring.
• Very performant, can support tens of thousands of checks per server.

Incentivized

• Easier way to identify to which service the query comes from
• Easier way to identify correlation between metrics
• More customization, right now it is too restricted
• The interval could be smaller between data points for peaks of usage

Incentivized

• High learning curve, setting up Icinga from scratch can be a bit of a challenge starting out.
• If the io2db process fails you UI stops updating, which can be very frustrating.
• There is no simple mechanism for adding new hosts and services through the web UI, it's all very config-file based.

Incentivized

Icinga is a solid solution which does everything it promises. It is backwards compatible with most Nagios instances, making the transition very easy. Once you get the hang of installing new plugins and editing configuration files expanding its monitoring capabilities are easy.

Incentivized

Amazon RDS Performance Insights is a out of the box plug and use solution for AWS with a press of a button, whereas Prometheus would require a lot of configuration and deployment and the learning curve is slower, making it not so user friendly. Datadog on the other hand offers similar capabilities but at a much higher cost. With that in mind, Amazon RDS Performance Insights is the choice to integrate with your AWS services quickly and affordably.

Incentivized

Icinga is better than Nagios because of its nicer user interface. New Relic can monitor CPU/memory and disk usage, but it's more of a performance and application troubleshooting tool rather than monitoring

Incentivized

• Help Optimize Query and app performance
• Help better plan capacity for the DB
• Improved the company capacity on troubleshooting problems in DBs

Incentivized

• With one check you know which applications are faulty e.g. after an upgrade. Which is big time saver
• You easily detect outages ion the applications so that your customer ideally does not even realize there was an outage.
• Detect if the environment does deliver the same result as in the same time as before to detect shortages.
• Additional information when debugging. Saved us several hours where we could simply point to a database which was slow.

Incentivized