How should an organization design a comprehensive database resilience and disaster recovery strategy combining Multi-AZ, read replicas, cross region replication, and automated backups?

A comprehensive strategy typically layers Multi-AZ deployment for protection against a single Availability Zone failure, cross region read replicas or Aurora Global Database for protection against an entire region becoming unavailable along with reduced latency for geographically distributed users, automated backups with an appropriately long retention period for point in time recovery from data corruption or accidental deletion, and regular disaster recovery testing to actually validate that failover and recovery procedures work as expected under realistic failure scenarios, rather than only trusting they will work when a real disaster eventually occurs.

aws rds create-global-cluster --global-cluster-identifier my-global-database --source-db-cluster-identifier my-aurora-cluster