Wondering how to connect to a database from ECS task on Fargate? We can help you.

Here, at Bobcares, we assist our customers with several AWS queries as part of our AWS Support Services.

Today, let us see how our Support techs assist with this query.

How to connect to a database from ECS task on Fargate?

Before you proceed, confirm that you have an Amazon ECS cluster running on Fargate and an Amazon Relational Database Service (Amazon RDS) database.

Today, let us see the steps followed by our Support Techs to connect to database.

Connect your task to your database

1. Firstly, create a Python script that connects to your MySQL database.

2.Then, create a Dockerfile that includes the required commands to assemble an image. For example:

Important: Be sure to place your rds.py script and Dockerfile in the same folder.

3.Create an Amazon ECR repository, and then push the Docker image to that repository.

4.Create a task definition, and then add the Docker image from step 2 as the container image.

Please note in your task definition, set the values for the ENDPOINT, USER, and PASS environment variables.

You can pass these values directly as environment variables or retrieve them from secrets in AWS Secrets Manager.

5.Then, open the Amazon ECS console, and choose Task Definitions from the navigation pane.

6.Select your task definition, choose Actions, and then choose Run Task.

7.For Launch type, choose FARGATE.

8.For Cluster, choose the cluster for your task definition.

9.For Number of tasks, enter the number of tasks that you want copied.

10.In the VPC and security groups section, for Cluster VPC, choose your Amazon Virtual Private Cloud (Amazon VPC).

11.For Subnets, choose your subnets.

12.For Security groups, select at least one security group.

13.Finally, choose Run Task.

The rds.py script stops the task and returns the following message:

Essential container in task exited.

Confirm that your task is connected to your database

1.Firstly, open the Amazon ECS console.

2.From the navigation menu, choose Clusters, and then choose your cluster.

3.Choose the Tasks tab.

4.For Desired task status, choose Stopped to see a list of stopped tasks.

5.Choose your stopped task.

6.On the Details tab of your stopped task, in the Containers section, choose the expander icon.

7.Finally, choose View logs in CloudWatch.

You should see the following message in the AWS CloudWatch console:

Connection successful to [Your Endpoint]

[Need help with the process? We’d be happy to assist]

Conclusion

In short, we saw how our Support Techs connect to a database from ECS task on Fargate.