Which RDS (NOT Aurora) feature when used does not require you to change the SQL connection string?
Read Replicas add new endpoints with their own DNS name. We need to change our application to reference them individually to balance the read load.
●Multi-AZ keeps the same connection string regardless of which database is up.
A Read Replica in a different AWS Region than the source database can be used as a standby database and promoted to become the new production database in case of a regional disruption. So, we'll have a highly available (because of Multi-AZ) RDS DB Instance in the destination AWS Region with both read and write available.
RDS Read Replicas
Replication is ASYNC,so reads are eventually consistent
RDS Multi-AZ
Synchronization is established between the two databases
How many Aurora Read Replicas can you have in a single Aurora DB Cluster?
15
For your RDS database, you can have up to 15 Read Replicas.
What is the maximum number of Read Replicas you can add in an ElastiCache Redis Cluster with Cluster-Mode Disabled?
5
You have a MySQL RDS database instance on which you want to enforce SSL connections. What should you do?
Execute a REQUIRE_SSL SQL statement to all your DB users
You have an ElastiCache cluster with small cache size, so you want to ensure that only the data that's requested will be loaded into the cluster. Which caching strategy should you use?
Lazy Loading would load data into the cache only when necessary (actively requested data from the database).
You have an ElastiCache Redis Cluster that serves a popular application. You have noticed that there are a large number of requests that go to the database because a large number of items are removed from the cache before they expire. What is this called and how to solve it?
Cache Evictions, Scale up or out your ElastiCache Redis Cluster
You're hosting a dynamic website fronted by an ElastiCache Cluster. You have been instructed to keep latency to a minimum for all read requests for every user. Also, writes can take longer to happen. Which caching strategy do you recommend?
Write Through