Solution
Enhancing Lambda and RDS Efficiency to Tackle Cost Concerns
By addressing our client's cost concerns head-on, we were able to optimize the AWS RDS and Lambda functions, which are core elements of their operations. Through our discovery, it was clear the Lambdas faced performance issues and reached their maximum concurrency executions, while the main RDS instance consistently operated near 100% CPU usage.
Identifying RDS slow performance in specific queries, we promptly added a necessary index to the table. This led to a significant query execution time reduction, from seconds to just one second for 1,000 queries. As a result, RDS CPU utilization decreased by an impressive 75%, enhancing Lambda efficiency.
After resizing the RDS instance to fit the decreased workload, we implemented additional database structure optimizations, based on a thorough review of performance bottlenecks. These enhancements had a remarkable outcome, leading to a 90% decrease in CPU usage. As a direct consequence, we were able to reconsider the size of the RDS instance once again. This decision resulted in a cost reduction to less than 15% of its original expense, demonstrating the substantial financial benefits stemming from these optimization endeavors.
Automating PDF Workflow Through Third-Party API Integration
Our client specializes in cybersecurity, as we know, cybersecurity entails a substantial number of reports that must be addressed promptly. Many of these reports are crucial for their customer to assess their performance periodically—whether on a monthly, weekly, or other basis—to ensure compliance and facilitate audits. Consequently, the generation of comprehensive HTML and PDF files containing the entire report becomes imperative for their customers.
The PDF builder application our client was using turned out to be slower and required more upkeep than their ideal standards. Speed was a significant factor for them, given its importance in the services they provide to their own customers. To address this issue, they started exploring a third-party API, which showed promise during the testing phase.
To streamline and automate the process, our cloud team stepped in. We integrated their HTML/ PDF builder with the third-party API. Now, whenever an item is added to the HTML bucket, a Lambda function triggers the API, resulting in the creation of a new PDF. The API then notifies our client's API gateway upon job completion. The generated PDF is given a new name for future reference, and this information is updated in a Dynamo DB table, including its status and count. The statuses include "delivered," "creation failed," and "delivery failed."
The PDF's name is directly linked to the database, allowing for easy retrieval and display on the web server once updated.
