Execute Lambda using mysql.lambda_async from local MySQL server using UDF

Readme.md

You'll want to have lib_mysqludf_sys (this link is to a branch of a fork that includes a fix for x64 systems) installed on your MySQL Server for this to work.

mysql.lambda_async.sql

DELIMITER $$

USE `mysql` $$
CREATE PROCEDURE `lambda_async`(
		lambda_function_ARN VARCHAR(1024),
		lambda_function_input TEXT
    )
BEGIN
	DECLARE v_null INT;
	SET v_null := sys_exec(CONCAT('/usr/bin/node /usr/local/runlambda/runlambda ', lambda_function_ARN, ' ', lambda_function_input));
END $$

runlambda.js

// Saved at /usr/local/runlambda/runlambda.js
const AWS = require('aws-sdk');

AWS.config = new AWS.Config({
        accessKeyId: 'XXXXXXXXXXXXXXXXXXXX',
        secretAccessKey: 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
        region: 'us-east-1'
});

const funcName = process.argv[2];
const payload = process.argv[3] || '{}';

const lambda = new AWS.Lambda();

lambda.invoke({
        FunctionName: funcName,
        Payload: payload,
        InvocationType: 'Event'
}, (err, data)=>{
        if(err){
                console.error(err, err.stack);
                return;
        }
});

Does this work with Aurora serverless?

This is for a local MySQL installation to emulate the lambda_async function available in Aurora.