Posted On: Dec 11, 2017
Last year, we announced support for asynchronously invoking AWS Lambda functions from Amazon Aurora with MySQL compatibility via an in-built stored procedure. Starting with version 1.16, we are extending this feature to be able to able to synchronously invoke Lambda functions. Further, we have implemented both the synchronous and asynchronous versions of the feature using native functions, allowing Lambda functions to be invoked from within queries.
AWS Lambda lets you run code without provisioning or managing servers or worrying about scalability. Lambda integration allows you to extend the capabilities of the Amazon Aurora MySQL database and invoke external applications to act upon data changes. For example, you can create a Lambda function that sends emails to customers whenever their address in the database is updated.
Use the native function lambda_sync when you must know the result of the execution before moving on to another action. Use the native function lambda_async, or the existing stored procedure mysql.lambda_async, when you do not need to know the result of the execution before moving on to another action. You can read more in the Amazon Aurora MySQL documentation.
To learn more about Amazon Aurora, a MySQL- and PostgreSQL-compatible relational database that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases, visit the Amazon Aurora product page. Please see the Aurora pricing page for regional availability.