How to enable lambda_sync/lambda_async functions in Aurora

Question

When I attempt to grant the INVOKE LAMBDA privileges on my user it fails with a syntax error:

mysql> GRANT INVOKE LAMBDA ON mydb.* TO 'myuser'@'myaddress';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVOKE LAMBDA ON mydb.* TO 'myuser'@'myaddress'' at line 1

The lambda_sync and lambda_async functions are also not defined:

mysql> select lambda_sync("arn:aws:lambda:ap-southeast-1:xxxxxxxxxxx:function:MyLambda", '{"operation":"ping"}');
ERROR 1305 (42000): FUNCTION mydb.lambda_sync does not exist

I've also tried using mysql.lambda_sync/mysql.lambda_async here.

According to the docs, these functions should be native to my version of aurora.

You can call the native functions lambda_sync and lambda_async when you use Aurora MySQL version 1.16 and later.

mysql> select AURORA_VERSION();
+------------------+
| AURORA_VERSION() |
+------------------+
| 2.01.1           |
+------------------+
1 row in set (0.10 sec)

The lambda_sync and lambda_async functions are built-in, native functions that invoke a Lambda function synchronously or asynchronously.

I've gone through the documentation, created an aurora instance using mysql 5.7 compatibility, creating a role on my db cluster with the lambda invoke permissions, and done half a dozen other things suggested in the docs. What am I missing?

There's not supposed to be a _ between words in GRANT INVOKE LAMBDA .... — Michael - sqlbot
– Michael - sqlbot, Commented Apr 27, 2018 at 23:18

Michael - sqlbot · Accepted Answer · 2018-04-28 11:45:32Z

6

Currently, Aurora MySQL 2.01 does not support features added in Aurora MySQL version 1.16 and later.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/AuroraMySQL.Updates.20180206.html

Aurora/MySQL 2.x is not a "later" version than Aurora/MySQL 1.x... they're two different release families. The native Lambda invocation functions are not available in 2.x (yet).

answered Apr 28, 2018 at 11:45

Michael - sqlbot

180k28 gold badges388 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ellipse-of-uncertainty Over a year ago

Wow! That explains it, what a pain. Thanks!

tfrancois Over a year ago

See my comment below...looks like based on my testing Aurora/MySQL 2.x does now support the native lambda functions.

tfrancois · Accepted Answer · 2018-08-10 16:46:21Z

I am running an instance of AWS Aurora 2.02.2 and although the native Lambda invocation functions are still not yet available, it DOES have support for the mysql.lambda_async stored procedure call using

CALL mysql.lambda_async('<<<<< AWS LAMBDA ARN GOES HERE >>>>>>', options);

And using this stored procedure did not require the explicit GRANT INVOKE LAMBDA privilege to run it. It worked out of the box for me once I correctly setup the IAM roles necessary in AWS for RDS to access my lambda function.

Where options in the call above is a JSON object with the parameters you want passed into the function, received by the event parameter in the Node.JS 8.10 handler function.

Hope this is helpful for those who need that functionality now. Hopefully AWS ports support for the native functions in the near future, but until then this works fine for me.

kirilclicks · Accepted Answer · 2018-09-28 21:58:07Z

2

Try allowing mysql.lambda_sync / mysql.lambda_async to your user(s):

GRANT EXECUTE ON PROCEDURE mysql.lambda_async TO 'your_user'@'%'

answered Sep 28, 2018 at 21:58

kirilclicks

1,68721 silver badges12 bronze badges

Comments

tfrancois · Accepted Answer · 2020-05-16 04:54:01Z

0

As of 5/16/2020, I am running on AWS Aurora MySQL 2.07.2 and I can confirm that it finally appears as if the lambda_async and lambda_sync native functions are enabled and working. They might have recently been silently enabled by Amazon but not publicly announced. Can anyone else confirm the same?

answered May 16, 2020 at 4:54

tfrancois

1731 silver badge10 bronze badges

Collectives™ on Stack Overflow

How to enable lambda_sync/lambda_async functions in Aurora

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related