Hosting a Two-Tier Flask Application with MySQL Database Using Docker Compose πŸ‘¨β€πŸ’»πŸ³

Hosting a Two-Tier Flask Application with MySQL Database Using Docker Compose πŸ‘¨β€πŸ’»πŸ³

Play this article

πŸ“ Introduction:

In this tutorial, we will guide you through the process of hosting a two-tier Flask application with a MySQL database using Docker Compose. This architecture allows you to separate your frontend (Flask application) from your backend (MySQL database) and deploy them together using containers. We assume you have a basic understanding of Git, Docker, and Python. Let's get started! πŸš€

πŸ”Prerequisites πŸ› οΈ

Before we dive in, make sure you have the following prerequisites in place:

  • Basic understanding of Git, Docker, and Python.

  • Open port 5000 from your inbound rule (security group) of the server

  • Docker is installed and running on your system. You should also be added to the Docker group to execute Docker commands without sudo.

  • Internet connectivity to clone the GitHub repository and download Docker images.

Step 1: Clone the Repository πŸ“‚

Let's start by cloning the repository containing the source code for our two-tier application. Open your terminal and execute the following commands:

git clone

cd two-tier-architecture-flask-application-with-mysql-database

You're now ready to dive into the project!

Step 2: Install Docker Compose πŸ‹

If you haven't already installed Docker Compose, no worries! Run this command to install it:

sudo apt install docker-compose -y

Docker Compose will help us manage our multi-container application effortlessly.

Step 3: Start the Application with Docker Compose 🚒

Now, let's use Docker Compose to start our two-tier application. Execute this command in the terminal:

docker-compose up -d

This command will create and start the containers defined in the docker-compose.yml file in detached mode. Smooth sailing ahead! β›΅

Step 4: Verify Containers πŸ•΅οΈβ€β™‚οΈ

To make sure everything is up and running, execute the following command:

docker ps

This will display a list of running containers. Keep an eye out for any issues!

Step 5: Create a MySQL Data Volume πŸ—„οΈ

Now, let's create a data volume to store the MySQL data. Run this command:

sudo mkdir /var/lib/mysql/

Our data will be securely stored and ready for action.

Step 6: Access MySQL Database πŸ’Ύ

Time to dive into the MySQL database running in the container. First, find the container name using the docker ps command. Then, use the following command to access the MySQL shell:

docker exec -it CONTAINER_NAME bash 

mysql -u root -p

Step 7: Creating table messages along with column

You'll need to enter the MySQL root password. Once logged in, execute these SQL commands to interact with the database:

use two_tier;

show tables;

create table messages (message varchar(255));

describe messages;

You're now in control of your database schema!

Step 8: Access the Application 🌐

To witness your Flask application in action, open a web browser and enter the following URL:


Replace PUBLIC_IP_OF_SERVER with the actual public IP address of your server. Enjoy the view of your hard work!

Conclusion πŸŽ‰

Congratulations! You've successfully hosted a two-tier Flask application with a MySQL database using Docker Compose. 🎈 This architecture gives you the power to manage your application components as isolated containers, ensuring scalability and maintainability. Remember, this tutorial provides a basic setup. In a production environment, consider additional factors like security, data backup, and container orchestration.

Feel free to explore and modify the source code to build more advanced features on top of this foundation. Happy coding! πŸ’»πŸŒŸ

πŸ” Checkout GitHub Repository for projects:


πŸ” Check out my YouTube channel - Prasad Suman Mohan:


Did you find this article valuable?

Support Prasad Suman Mohan by becoming a sponsor. Any amount is appreciated!