A company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application.The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.
How can the database specialist minimize the performance degradation after failover?
Enable cluster cache management for the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-0
Enable cluster cache management tor the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-1
Enable Query Plan Management for the Aurora DB cluster and perform a manual plan capture
Enable Query Plan Management for the Aurora DB cluster and force the query optimizer to use the desired plan
To the best of my knowledge, the answer is:
Enable cluster cache management for the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-0