2023-10-21

A Guide For AWS Lambda with Python and MySQL

Amazon Web Services (AWS) Lambda is a serverless computing service that lets you run code without provisioning or managing servers.

AWS Lambda automatically scales your application by running code responding to triggers such as changes to data in Amazon S3 buckets or updates in a DynamoDB table. It automatically manages the compute resources, ensuring the code runs in a highly available environment.

Setting Up:

Before diving into code samples, ensure you have the following:

An AWS account.
AWS CLI installed and configured.
Python and pip installed.
A MySQL database (either on AWS RDS or any accessible server).

Creating a Lambda Function:

1. Setting up the Python Environment:

First, create a new directory for your Lambda function and set up a virtual environment:

mkdir lambda_mysql_function
cd lambda_mysql_function
python3 -m venv venv
source venv/bin/activate

2. Installing Required Libraries:

For our function to interact with MySQL, we need the mysql-connector-python library:

pip install mysql-connector-python

3. Writing the Lambda Function:

Create a new file named lambda_function.py:

import mysql.connector
import os

def lambda_handler(event, context):
    connection = mysql.connector.connect(
        host=os.environ['DB_HOST'],
        user=os.environ['DB_USER'],
        password=os.environ['DB_PASSWORD'],
        database=os.environ['DB_NAME']
    )

    cursor = connection.cursor()
    cursor.execute("SELECT * FROM your_table_name LIMIT 10;")
    results = cursor.fetchall()

    cursor.close()
    connection.close()

    return {
        'statusCode': 200,
        'body': results
    }

Replace your_table_name with the name of your table in the MySQL database.

4. Packaging the Function:

To deploy the function to AWS Lambda, you need to create a deployment package:

deactivate
zip -r9 function.zip .

Deploying to AWS Lambda:

Navigate to the AWS Lambda console and create a new function.
Upload the function.zip file.
Set the runtime to Python 3. x.
Add environment variables: DB_HOST, DB_USER, DB_PASSWORD, and DB_NAME with appropriate values.
Increase the timeout if your queries are expected to take longer.
Add a trigger, like an API Gateway, to invoke the function or test it directly from the console.

AWS Lambda offers a powerful platform for running serverless applications. Integrating it with a MySQL database using Python allows you to build scalable and cost-effective applications without the overhead of managing servers. This guide provides a basic introduction, but the possibilities with Lambda are vast, from data processing tasks to building full-fledged applications.

Özgür Özkök