Learn how to connect applications in one AWS region to shared services like ElastiCache for Redis and Amazon RDS hosted in another. This step-by-step guide shows you how to set up VPC peering, configure routes, and use prefix lists for scalable security group management.
Automatically capture row lock/blocking forensics on Aurora/RDS MySQL every few seconds—complete with the exact blocking SQL—then use a proven checklist to reduce contention.
Long-running queries can wreak havoc on Aurora MySQL performance. Learn how to automatically detect, log, and kill queries that exceed a time limit using MySQL’s event scheduler. This step-by-step guide walks through building a killer procedure, testing safely, scheduling it, and keeping full audit logs.
If you’ve ever seen ERROR 1129 (HY000): Host is blocked because of many connection errors on an AWS RDS MySQL instance, you’re not alone. This guide walks through how to identify why it happens, quickly unblock the host, tune max_connect_errors in RDS, and verify the fix — so your applications can reconnect without disruption.
Enabling the slow query log in Amazon Aurora MySQL Serverless is one of the easiest ways to diagnose performance bottlenecks. With just a few parameter changes, you can capture queries that run longer than expected and send them to either a MySQL table for quick analysis or to CloudWatch Logs for dashboards and alerts. In this guide, we’ll walk through enabling the feature, viewing results, and using CloudWatch Logs Insights to surface your top slow queries.
Reliable Penguin provides managed web hosting, systems administration, website and server migrations, and expert consulting.
Submit the form—or for immediate service call 866-649-7984.