AWS Lambda for DBA maintenance
August 23, 2019

AWS Lambda for DBA maintenance

Jacob Biguvu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with AWS Lambda

AWS Lambda is an event-driven, serverless computing platform and a compute service that runs code in response to events and automatically manages the computing resources required by the code. AWS Lambda is being used by our team and across the whole organization. It's being used as part of our DR solution to run the code at scheduled times.
  • I have used the AWS Lambda for moving the RDS snapshots from cross-region like East to West and West to East. We used it as part of our DR solution. AWS Lambda is the service provided by AWS, and it makes it easy to manage the AWS resources.
  • I have used AWS Lambda for running a cleanup code against the database at scheduled times. I use Python as the coding language. AWS Lambda is the service provided by AWS, which makes easy to manage the AWS resources.
  • We can use AWS lambda function for serverless architecture.
  • We can use AWS Lambda for managing Micro-service architecture.
  • AWS Lambda has not worked in an efficient way for running long-lived applications, especially on serverless architecture.
  • AWS Lambda provides a zip deployment method, but there is a limit on size, like 500MB.
  • AWS Lambda has a significant issue with "Cold Start." It takes some time for it to handle the first request -- there, we see a real problem.
  • AWS Lamdba fulfills our DR requirements and audit requirements. It's cost-saving, and has easy setup and event-triggers.
Jenkins is a solution for CD/CI pipelines. We can leverage this tool to run code automatically. Long-lived applications and jobs can also be run through it.
No need to manage server/architecture and easy to setup and run the code. It is function as a service. it support different languages such as python, java, Node.js and Go.
AWS Lambda is best for short-lived applications/codes. Configure AWS Lambda to act based on the events that are produced on certain services. It works. We used it to move the RDS snapshot from WEST to EAST and EAST to WEST whenever the RDS automatic backups are done. It helps in other scenarios, like when application teams don't have a server or don't have a place to run a job on a regular basis. Then we can leverage this AWS Lambda to run the code against the database. As I mentioned, this is not suited for long-lived applications.

Using AWS Lambda

There's no need to manage server/architecture, and it's easy to set up and run the code. It is functional as a service. It supports different languages, such as Python, Java, Node.js, and Go.