Review Mode Set 4 Question: Cloudfront for RDS?

[cordyceps]

This question is about slow read performance on an RDS Multi-AZ. There is also static content as this is a WordPress website, but static content is not the bottleneck as stated in the question. However this presents CF as a potential answer and says “Adding a CloudFront distribution to the website will significantly
reduce the read operations on the server and on the database as well”.

CF may have other benefits in this architecture, but I don’t understand how it solves the problem of read performance on a SQL Database.

[KitKwok12]

Agree with you. but my third choice is to implement sharding.

[Carlo-TutorialsDojo]

Hello cordyceps and KitKwok12,

Thank you for posting your feedback here.

I have reviewed the question, and I agree that while CloudFront can be useful for caching dynamic content, it won’t likely address the primary issue of read bottleneck in the database. Its capability to cache content is quite different from optimizing database query response. Based on the options available, a viable approach would be to scale out through sharding.

We’ll make the necessary revisions to ensure the correct answers are more closely aligned with the question.

Let me know if you have further questions.

Regards,

Carlo @ Tutorials Dojo