Make sure to address the following: How would you diagnose slow MySQL queries on that database? Would
Question:
Make sure to address the following:
- How would you diagnose slow MySQL queries on that database?
- Would you recommend a different database strategy or a caching strategy? Why or why not?
- Would you implement logging? If yes, what services would you use? If not, why not?
- Would you implement Application Performance Monitoring? If yes, what services would you use? If not, why not?
- Provide at least one other recommendation for the team lead to improve the application. This recommendation does not have to be limited to logging, monitoring, or performance. You are a software engineer on a small team. You work on an application that is hosted in the cloud. It is a Java-based application that runs on three servers behind a load balancer on AWS. It utilizes a MySQL database managed by RDS. A web application that communicates to the Java service, and the Java service communicates with the database.
You have noticed that the application is beginning to perform poorly. As more users begin to use the application, page load speeds have increased significantly. You also notice that you regularly lose connections. You know that the database contains a lot of information across many tables. Your team lead has asked you to try to figure out how to improve the application's performance. Since this is a critical product, the price of a solution is not the most important factor.
Considering what you have learned related to databases, caching, logging, and monitoring, perform research utilizing the Internet. Provide at least two references on the following topics and .
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi