Monitoring Amazon RDS Instances in SelectStar

Cloud database deployments have become commonplace in modern IT environments. This has created a unique situation where IT departments are responsible for monitoring both internal database deployments as well as those in the cloud. This often creates the need for additional tooling and resources to monitor hybrid environments.

SelectStar is a monitoring platform focused on moving your database monitoring into a single console. This includes both local deployments, as well as deployments located in one of the most popular cloud offerings for databases like Amazon RDS.

Complete Database Support

SelectStar has complete coverage of Amazon RDS-support database technologies. This includes Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server.

Figure 1: Amazon RDS database deployments (blue arrows) can be monitored side-by-side with local deployments (green arrow is an example).

The comprehensive Amazon RDS coverage in SelectStar, combined with local database monitoring, makes monitoring your database deployments simple. It’s worth noting that other Amazon databases are supported outside of RDS, such as Amazon DynamoDB.

Configuration Visibility

SelectStar provides configuration information on both your database and Amazon RDS instances. Configuration settings can be automatically monitored using the Recommendations feature in SelectStar. You can create Recommendations on a single database instance or Amazon RDS instance for one-off configuration settings, or create a Recommendation that spans all instances of a given type. Once you have setup Recommendations you will be alerted if the specified configuration value changes.

Figure 2: The Instance Configuration page of an Oracle Database. Configuration Recommendations can be seen in the right sidebar.

Every database technology has a different architecture, so available database configuration values will vary. An “Instance Configuration” section is available for each database type where you can view the current configuration settings. These databases will also have a Recommendations section in the right sidebar, making configuration anomalies obvious.

Amazon RDS configuration values are also available in SelectStar by navigating to an RDS Instance. In the Amazon RDS Instance page you will see both “AWS Configuration” and “Database Configuration” sections. AWS Configuration includes values such as Availability Zone, Class, Instance Create Time, and more. Database Configuration contains configuration such as Cluster Identification, Master Username, and Port.

Figure 3: Amazon RDS Instance configuration section. Amazon RDS Configuration Recommendations can be seen in the right sidebar.

Performance Monitoring

SelectStar monitors the performance of your Amazon RDS database as well as the underlying AWS performance. For the database monitoring portion, monitoring will be the same as if you were running the database locally. For more information on database-level monitoring for a specific technology, you can use the following “deep dive” write-ups:

When you first open a database running on Amazon RDS, you will notice an “Amazon RDS Performance” section. Some performance KPIs are listed in this section such as storage usage, CPU utilization, and network statistics. Clicking on this section will take you to the RDS resource where more performance information is available.

Figure 4: Amazon RDS performance overview found in a database running on RDS.

At the top of the Amazon RDS page you notice a Health section with links to Alerts. Alerts in SelectStar are performance-related problems and should be investigated when present as they impact both the Health and performance of your databases.

Figure 5: Top section of an RDS Instance. Two Alerts are present, as seen in both the Health Section and the Alerts sidebar.

Scrolling down the page you will find more metrics and metric categories containing performance information about disks, backups, network, workload, and more. Each metric category contains 3 metrics with a trend chart. Clicking on one of these categories will display all performance metrics in the selected category.

Figure 6: Some of the performance metric categories for an Amazon RDS instance.

Once on a specific metric category page, you can click any metric to view more historical data. See Figure 7 below for an example of the CPU Utilization metric set to display the past 3 days performance data.

Figure 7: CPU Utilization history for an Amazon RDS Instance.

Comprehensive database monitoring, including your Amazon RDS deployments, is just a few clicks away with SelectStar.

To learn more about SelectStar or request a free trial, visit selectstar.io.

LET'S GET STARTED!

Try SelectStar for 14 days. No credit card required.

TRY IT NOW!