Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps to asess the load on a database, and determine when and where to take action. Performance Insights helps non-experts to detect performance problems with a dashboard that visualizes database load. Performance Insights uses lightweight data collection methods that don’t impact the performance of your applications, and makes it easy to see which SQL statements are causing…
N/A
Icinga
Score 7.8 out of 10
N/A
Icinga is an open source network monitoring platform. It includes automation, modularized integration packages, and prebuilt alerts and reporting capabilities.
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.
If you're running bare-metal in a datacenter and your hosts are fairly static, it's probably okay to use something like Icinga to monitor your systems. In general, I would not recommend using any monitoring software based on Nagios (Icinga is a fork of Nagios) due to the outdated concepts inherent in those systems. There are a number of good SaaS monitoring solutions which are superior and several open source projects which implement an automation-centric approach to monitoring
I think Icinga has a great search feature. I can always search for the hosts, host groups, or check names. When using just regular Nagios, I don't recall being able to do this search.
The fact that I can use Active Directory or LDAP for logins is a great feature.
If you are familiar with Nagios, it's very simple to combine the two products to get a polished finished product.
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.
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.
Icinga was initially a fork of Nagios. Over time, the configuration language was replaced with something more programmatic. This configuration language is one of the big sellers of this product. It allows flexible, quick configuration of large sets of hosts and services with minimal input. Comparing it to other products like WhatsUp Gold, Zenoss, Zabbix, etc., it stands out as incredibly flexible. Adding additional features to Icinga can be as simple as searching for them online. And if they don't yet exist, there is a full API available for custom extensions.
