AWS RDS Integration
Monitor relational database performance, query latency, and connection pool utilization. Performance Insights integration gives you query-level visibility with AI root cause analysis for slow queries.
How It Works
Deploy CloudFormation Stack
Launch the TigerOps CloudFormation template to create the IAM role and enable CloudWatch Metric Streams for the AWS/RDS namespace. No changes to your database instances are required.
Enable Enhanced Monitoring
Enable RDS Enhanced Monitoring on your instances. TigerOps collects OS-level metrics (CPU steal, memory, I/O) via the RDS monitoring agent that cannot be obtained from CloudWatch alone.
Enable Performance Insights
Turn on RDS Performance Insights and connect TigerOps to the Performance Insights API. Query-level wait events, top SQL, and database load metrics are available in TigerOps dashboards instantly.
Correlate with Application Traces
TigerOps automatically links slow database queries from Performance Insights with the application traces that triggered them, giving full end-to-end context for every slow request.
What You Get Out of the Box
Query Latency & Top SQL
Per-query latency, execution count, and wait event breakdown via RDS Performance Insights. TigerOps surfaces the top N queries by cumulative load and alerts on regressions after deployments.
Connection Pool Monitoring
Active connections, connection errors, and connection limit utilisation. TigerOps alerts before connection pool exhaustion and identifies which application services are holding excess connections.
Storage & I/O Metrics
Free storage space, IOPS utilisation, read/write throughput, and I/O latency. TigerOps predicts storage exhaustion using trend analysis and alerts with sufficient lead time to act.
Read Replica Lag
Replica lag monitoring for read replicas with trend alerts. TigerOps correlates increased replica lag with write load spikes on the primary so you can diagnose replication bottlenecks quickly.
Multi-AZ Failover Tracking
RDS Multi-AZ failover events are captured and surfaced as incidents. TigerOps tracks the time to promote the standby, the application reconnection time, and the error rate spike during the failover window.
AI Slow Query Root Cause
When query latency spikes, TigerOps AI correlates the event with CPU pressure, storage I/O saturation, lock wait time, and connection count changes to identify the root cause automatically.
RDS Enhanced Monitoring & Performance Insights
Enable enhanced monitoring and Performance Insights on your RDS instances.
# Enable Enhanced Monitoring and Performance Insights on RDS instance
aws rds modify-db-instance \
--db-instance-identifier my-production-db \
--monitoring-interval 15 \
--monitoring-role-arn arn:aws:iam::123456789:role/rds-monitoring-role \
--enable-performance-insights \
--performance-insights-retention-period 7 \
--apply-immediately
# Deploy TigerOps RDS integration stack
aws cloudformation deploy \
--template-url https://tigerops-cfn.s3.amazonaws.com/rds-integration.yaml \
--stack-name tigerops-rds \
--capabilities CAPABILITY_IAM \
--parameter-overrides \
TigerOpsApiKey=${TIGEROPS_API_KEY} \
EnablePerformanceInsights=true \
PerformanceInsightsRegion=us-east-1
# IAM permissions needed for Performance Insights
# {
# "Effect": "Allow",
# "Action": [
# "pi:GetResourceMetrics",
# "pi:DescribeDimensionKeys",
# "pi:ListAvailableResourceDimensions"
# ],
# "Resource": "arn:aws:pi:*:*:metrics/rds/*"
# }Common Questions
Which database engines does TigerOps support for RDS?
TigerOps supports all RDS engines: MySQL, PostgreSQL, MariaDB, Oracle, and Microsoft SQL Server. Performance Insights integration is available for MySQL 5.7+, PostgreSQL 10+, and MariaDB 10.2+ instances.
Does TigerOps require any changes to RDS security groups?
No. TigerOps collects metrics via CloudWatch Metric Streams (push-based) and the RDS Performance Insights API. No inbound connections to your database VPC are required and no security group modifications are needed.
How does TigerOps use RDS Performance Insights?
TigerOps calls the RDS Performance Insights GetResourceMetrics and DescribeDimensionKeys APIs using a read-only IAM role. It ingests the database load (DBLoad) metric broken down by wait event and top SQL digest every minute.
Can TigerOps alert on RDS storage running low?
Yes. TigerOps monitors FreeStorageSpace and computes the projected time to full based on the current growth rate. You receive an early warning alert days before storage exhaustion, with enough time to expand the volume or clean up data.
Does TigerOps support RDS Proxy metrics?
Yes. TigerOps collects AWS/RDS namespace metrics for RDS Proxy including ClientConnectionsReceived, DatabaseConnectionsCurrentlyBorrowed, QueryRequests, and MaxDatabaseConnectionsAllowed to help you right-size your proxy configuration.
Query-Level Database Visibility Without the Overhead
Performance Insights integration, replica lag alerts, and AI slow query analysis. Connect in minutes.