Intro

• Regional Service (supports global databases)
• Supports Multi AZ
• AWS managed Relational DB cluster
• Preferred over RDS
• Auto-scaling (max 128TB)
• Up to 15 read replicas
• Asynchronous Replication (milliseconds)
• Supports only MySQL & PostgreSQL
• Cloud-optimized (5x performance improvement over MySQL on RDS, over 3x the performance of PostgreSQL on RDS)
• Backtrack: restore data at any point of time without taking backups

Endpoints

• Writer Endpoint (Cluster Endpoint)
  • Always points to the master (can be used for read/write)
  • Each Aurora DB cluster has one cluster endpoint
• Reader Endpoint
  • Provides load-balancing for read replicas only (used to read only)
  • If the cluster has no read replica, it points to master (can be used to read/write)
  • Each Aurora DB cluster has one reader endpoint
• Custom Endpoint:
  • Load balance to a subset of replicas
  • Provides load-balanced based on criteria other than the read-only or read-write capability of the DB instances like instance class (ex, direct internal users to low-capacity instances and direct production traffic to high-capacity instances)

High Availability & Read Scaling

• Self healing (if some data is corrupted, it will be automatically healed)
• Storage is striped across 100s of volumes (more resilient)