How should Amazon RDS be designed for production in AWS?

Choose instance and storage based on workload, use Multi-AZ for availability, read replicas for read scaling, configure backups, monitor connections and slow queries, and use RDS Proxy when useful.