The JusDB Database Engineering Blog

A step-by-step guide to migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server — covering native backup/restore via S3 with the rds_restore_database stored procedure, AWS DMS full-load + CDC for near-zero downtime, option group and IAM setup, cutover, and post-migration hardening.

Understand RDS Multi-AZ for HA and Read Replicas for read scaling — failover behavior, replication lag, and costs

RDS MySQL audit logs stored in CloudWatch cost significantly more than S3 — and most teams don't need real-time log access. Here's how to export audit logs to S3 and cut your AWS bill.

Aurora and RDS share the MySQL engine but diverge at the storage layer in ways that produce very different cost and performance profiles — the right choice depends entirely on your I/O pattern.

Authenticate to RDS and Aurora using IAM credentials instead of passwords. Eliminates long-lived passwords with 15-minute token-based access. Covers PostgreSQL and MySQL setup.

A measurement-led guide to RDS and Aurora cost control: right-size safely, cover steady usage, govern storage, schedule idle systems, and verify each change.

AWS RDS, Aurora, and Aurora Serverless v2 all run MySQL and PostgreSQL — but their pricing models differ dramatically. Learn when to use each and how to avoid expensive I/O surprises.

Master AWS RDS connection limits for MySQL and PostgreSQL. Learn max_connections calculation, connection pooling strategies, and optimization techniques.

A production guide to Amazon Aurora PostgreSQL — the shared storage architecture, fast failover mechanics, Aurora Serverless v2 ACU scaling, Global Database, Parallel Query, and an honest comparison against standard RDS.

A production guide to AWS RDS Proxy — how it works, when to use it, IAM authentication setup, and the connection pool sizing rules that prevent Lambda-induced database overload.

Reduce AWS RDS MySQL costs by 40-60% with proven optimization strategies. Learn Reserved Instance planning, right-sizing, storage optimization, and read replica strategies.

Optimize AWS RDS PostgreSQL costs without sacrificing performance. Learn instance sizing, storage class selection, backup strategies, and Multi-AZ optimization.