A company hosts a production MySQL database on an Amazon Aurora single-node DB cluster. The database is queried heavily for reporting purposes. The DB cluster is experiencing periods of performance degradation because of high CPU utilization and maximum connections errors. A SysOps administrator needs to improve the stability of the database.
Which solution will meet these requirements?
Creating an Aurora Replica node will offload the reporting workload from the primary DB instance, reducing the CPU utilization and improving stability. By creating an Auto Scaling policy to scale replicas based on CPU utilization, you can automatically add or remove replicas as needed to handle the reporting workload. Ensuring that all reporting requests use the read-only connection string directs the reporting workload to the replica nodes, further reducing the load on the primary DB instance.
Creating an Aurora Replica node will offload the reporting workload from the primary DB instance, reducing the CPU utilization and improving stability. By creating an Auto Scaling policy to scale replicas based on CPU utilization, you can automatically add or remove replicas as needed to handle the reporting workload. Ensuring that all reporting requests use the read-only connection string directs the reporting workload to the replica nodes, further reducing the load on the primary DB instance.
AAAAAAAAAAAAAAAA
A is the correct answer
A, read degradation = read replica + reader endpoint
AAAAAAAAAAAAA
reporting --> replica