By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Trigger Lambda Function from Amazon RDS MySQL Server (Not RDS Aurora MySQL)

0

Hi,

I need to trigger one of my lambda functions to initiate a process which is written in the lambda function using python.

I have one RDS MySQL(Not RDS Aurora MySQL, it's just RDS MySQL) server in which I have a table in which records are getting added by end users through an application. So, whenever a record gets added, I should trigger my lambda function.

How to invoke a lambda function via RDS MySQL server?

Could anyone please suggest a solution to trigger my lambda function on demand?

Topics
ServerlessComputeMigration & ModernizationAnalyticsDatabase
Tags
AWS LambdaAmazon Relational Database ServiceMySQL
Language
English
kasha
asked 8 months ago1214 views
2 Answers
0

You can follow the AWS Blog https://aws.amazon.com/blogs/database/trigger-an-aws-lambda-function-from-amazon-rds-for-mysql-or-amazon-rds-for-mariadb-using-audit-logs-and-amazon-cloudwatch/

Asad Aazam
answered 2 months ago
-1

Hi,

There is such a solution:

  1. write an SQL trigger to be started on each row insert for table(s) of interest: https://www.mysqltutorial.org/mysql-triggers/mysql-after-insert-trigger/
  2. Call the Lambda (sync or async from this trigger): https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.Lambda.html

Hope it helps! Didier

profile pictureAWS
EXPERT
Didier_Durand
answered 8 months ago
  • kasha
    8 months ago

    Hello,

    As I mentioned, It's RDS MySQL not RDS Aurora MySQL. Using lambda_sync and lambda_async native functions we can trigger lambda function but, incase of RDS MySQL how can we invoke a lambda function? Thanks, Kasha.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content