Chapter 11 – Working with Relational Database Services
MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL, and Aurora.
Read replicas are read-only asynchronous copies, while Multi-AZ has one read-write master and a synchronous slave replica that isn't accessible until failover.
Primary instance for writes and replica instance for reads.
Snapshots don't affect Aurora's availability.
Snapshots can't be restored to an existing cluster.
Implement a read replica and point the BI to the read replica.
Make the RDS subnet private and specify the EC2 security group as the source in the RDS security group instead of the subnet address.