Category: aws

Multi Master Aurora Replicas vs MySql Replicas Global Aurora Feature Aurora Global Database Cross-Region Read Replica Use Case Disaster recovery, low-latency reads Read scaling Regions Supported Up to 5 regions One region per replica Replication Lag <1 second (storage-based) Minutes (logical) Write Availability Only one primary Only primary writes Automatic Failover? ✅ Yes ❌ No…

Encryption at rest can be enabled – includes DB storage, backups, read replicas and snapshots. You can only enable encryption for an instance during creation time, it cannot be changed. Transparent Data Encryption (TDE) can be used for Oracle and SQL Server. AWS KMS is used to manage encryption keys. Read replicas from a encrypted…

Recovery Time Objective (RTO) – the maximum acceptable time to recover time to recover data and resume processing after a failure. Recovery Point Objective (RPO) – maximum period of acceptable data loss. With RDS you can take EBS volume snapshots of your database instances, snapshots include all database on the instance and are store in…

Amazon RDS Read Replicas are a feature that allows you to create one or more read-only copies of your Amazon RDS database. These replicas can be used to scale out read operations, improve application performance, and provide additional data redundancy for fault tolerance. Read Replicas are a strategy to scale horizontally, API calls must be…

Amazon RDS Multi-AZ (Multi-Availability Zone) is a high-availability feature designed to enhance database durability and fault tolerance. In a Multi-AZ configuration, Amazon RDS automatically maintains a synchronous standby replica of the database in a separate Availability Zone (AZ) within the same AWS Region. This ensures minimal downtime and automatic failover in the event of a…

Amazon Aurora is a fully managed relational database service designed for high performance, availability, and scalability. It is compatible with MySQL and PostgreSQL, offering the simplicity of open-source databases combined with enterprise-grade features and the reliability of AWS infrastructure. High Performance: High Availability: Serverless Option: Global Database: Automatic Backups: Security: Durability

AWS RDS Proxy is a fully managed database proxy service designed to improve the performance, scalability, and availability of applications that connect to Amazon RDS databases and Aurora. It acts as an intermediary between your application and the database, pooling and sharing established database connections to optimize database usage and handle high-concurrency workloads efficiently. Connection…

Amazon S3 offers several mechanisms to prevent accidental or malicious deletion of your objects and buckets. These features are critical for ensuring data durability and protection against accidental loss. S3 Versioning What it Does: Enables multiple versions of an object to be stored in a bucket. When versioning is enabled, deleting an object does not…

AWS Migration Hub is a centralized service that simplifies the migration of applications and resources to AWS by providing a single interface for tracking progress. It integrates with various AWS migration tools and partner solutions to help you assess, plan, and execute migrations efficiently. Centralized Tracking: Provides a unified dashboard to monitor migration tasks and…

AWS Database Migration Service (DMS) is a managed service that helps migrate databases to AWS quickly and securely, with minimal downtime. It supports both homogeneous migrations (e.g., Oracle to Oracle, MySQL to MySQL) and heterogeneous migrations (e.g., Oracle to MySQL, SQL Server to PostgreSQL). Minimal Downtime: AWS DMS ensures minimal disruption to applications by keeping…