RDS

• OLTP , Transitional applications, complex queries

• RDS is NOT a key/value store

• You can enable Slow query logs to troubleshoot SQL logs within RDS

• Transparent Data Encryption (TDE)

  • Automatically encrypt data before it is written to storage, and automatically decrypt data when the data is read from storage.

• Multi-AZ deployments are synchronous , it improves availability and NOT scalability (use read replicas for scalability)

• Read Replicas

  • Support read-heavy database workloads

  • Enabling autobackp is mandatory before creating read replicas

  • Apps can connect directly to read replica for read operation

  • Only used for reads

  • Improve scalability

  • Can be in same or different AZ or region

  • Are not deleted when main db is deleted, you need to delete by yourself