aws rds mysql 连接,可以AWS LAMBDA连接到RDS MySQL数据库和更新数据库？

I am trying to connect AWS Lambda function to RDS mysql database.

I just wanted to update the database from my lambda function. Is it possible to access RDS by specifiying IAM Role and access Policy?.

I can connect to mysql databse using mysql client.but when i try on lambda i can't do that. here is my code.

console.log('Loading function');

var doc = require('dynamodb-doc');

var dynamo = new doc.DynamoDB();

var mysql = require('mysql');

exports.handler = function(event, context) {

//console.log('Received event:', JSON.stringify(event, null, 2));

var operation = event.operation;

delete event.operation;

switch (operation) {

case 'create':

var conn = mysql.createConnection({

host : 'lamdatest.********.rds.amazonaws.com' , // RDS endpoint

user : 'user' , // MySQL username

password : 'password' , // MySQL password

database : 'rdslamda'

});

conn.connect();

console.log("connecting...");

conn.query ( 'INSERT INTO login (name,password) VALUES("use6","password6")' , function(err, info){

console.log("insert: "+info.msg+" /err: "+err);

});

console.log("insert values in to database");

break;

case 'read':

dynamo.getItem(event, context.done());

break;

default:

context.fail(new Error('Unrecognized operation "' + operation + '"'));

}

context.succeed();

};

解决方案

Yes. You can access a MySql RDS database from AWS Lambda.

You can use node-mysql library.

However, there is a big caveat that goes with it.

AWS Lambda does not (currently) have access to private subnets inside a VPC. So in order for AWS Lambda to access your RDS database, it must be publicly accessible, which could be a security risk for you.

Update (2015-10-30): AWS Lambda announced upcoming VPC support (as of re:Invent 2015), so this won't be an issue for much longer.

Update (2015-11-17): AWS Lambda still does not have VPC support.