Repository files navigation

Running a nodejs application with mysql database using docker and microservice architecture

• Launch mysql server in a docker container.
• Launch our simple node app in a separate container.
• Link these two containers and test our integrated mysql-nodejs app.

Watch this tutorial athttps://youtu.be/tIbMSqTEpfY

• must have docker set up and running on your system

1. Create a directory for our tutorialmkdir getting-started-docker-mysql-nodejs

2. Move to this directorycd getting-started-docker-mysql-nodejs/

3. Create a directory for our mysql microservicemkdir mysql-microservice

4. Move to this directorycd mysql-microservice/

5. Create a Dockerfile with following content (name of file will beDockerfile)

   ## Pull the mysql:5.7 imageFROM mysql:5.7## The maintainer name and emailMAINTAINER Your Name <name@email.com># database = test and password for root = passwordENV MYSQL_DATABASE=test \    MYSQL_ROOT_PASSWORD=password# when container will be started, we'll have `test` database created with this schemaCOPY ./test-dump.sql /docker-entrypoint-initdb.d/

6. We'll initialize our test database with a sample schema.Downloadtest-dump.sql and put it inside mysql-microservice folder along with Dockerfile

7. Create a data directory where mysql will store its contentmkdir data.We will specify this directory while running our mysql container.On Linux default storage directory is/var/lib/mysql but in this tutorial we'll use a custom storage directory.

8. Build the image with Dockerfiledocker build -t test-mysql .Note that we are inside mysql-microservice directory.test-mysql would be name of our image

9. You can check your newly built image usingdocker images

10. Run the newly created docker image as container

    docker run  -d \--publish 6603:3306 \--volume=/home/varunkumar/getting-started-docker-mysql-nodejs/mysql-microservice/data:/var/lib/mysql \--name=test-mysql-microservice test-mysql

11. With above command we started our container in detach mode-d and mapped host(your machine) port 6603 with container port 3306 (mysql server)--publish 6603:3306.We are also using our custom data storage directory by specifying host path volume--volume.Replace/home/varunkumar/getting-started-docker-mysql-nodejs/mysql-microservice/data path to absolute path of data directory which you created on your system.We are also naming our container as test-mysql-microservice--name

12. Check logs to see if everything went smoothdocker logs test-mysql-microservice

13. Check your container statedocker ps

14. We have successfully launched a mysql container

To verify that our test-mysql-microservice container is up and running, we'll connect to it.Follow below steps if you have mysql (mysql-client) installed on your system.

1. Check the ip of your system. On Linux useifconfig. Lets say that ip is 192.168.43.147

2. Connect to test-mysql-microservice container with following params-user-root, host=192.168.43.147, port=6603, database=test and password=password.Remember that we have specified root username and password in Dockerfile.Also our container is initialized with test-dump.sql (a schema with database name test)

3. mysql -u root -p -h 192.168.43.147 -P 6603 -D testUse password=password when prompt and hit enter

4. If connected successfully you can see a sample table studentsshow tablesexit when done.

1. Right now we are in mysql-microservice directory. We go to project root directorycd ..

2. create directory for node microservicemkdir nodejs-microservice

3. Move to this directorycd nodejs-microservice/

4. Create a Dockerfile with following content (name of file will beDockerfile)

   # Use Node v8 as the base image.FROM node:8# create and set app directoryRUN mkdir -p /usr/src/appWORKDIR /usr/src/app# Install app dependencies# A wildcard is used to ensure both package.json AND package-lock.json are copied# where available (npm@5+)COPY package*.json ./RUN npm install# Copy app source from current host directory to container working directoryCOPY . .# Run appCMD ["npm", "start"]

5. We need a package.json file for our node-microservice app as well as source code.For this tutorial, I've already created one.Downloadpackage.json as well asindex.js and put it inside nodejs-microservice folder along with Dockerfile.

6. Build the image with Dockerfiledocker build -t test-nodejs .Note that we are inside nodejs-microservice directory.test-nodejs would be name of our image

7. You can check your newly built image usingdocker images

8. Run the newly created docker image as container

   docker run  -d \--publish 4000:4000 \-e MYSQL_USER='root' \-e MYSQL_PASSWORD='password' \-e MYSQL_DATABASE='test' \-e MYSQL_HOST='172.17.0.2' \--link test-mysql-microservice:db \--name=test-nodejs-microservice test-nodejs

9. Explaination of above command-

• -d run in detach mode
• --publish map the host port 4000 to the container port 4000
• -e pass environment variables to nodejs app necessary to make mysql connection (check index.js file)
• --link test-mysql-microservice:db link to the container named test-mysql-microservice and refer to it as db
• --name naming our container as test-nodejs-microservice

10. How to know your MYSQL_HOST-Note that I am using172.17.0.2 ip-address as MYSQL_HOST. This is the IpAddress of our test-mysql-microservice container.You must replace this value to your container's ipAddress. Usedocker inspect test-mysql-microservice | grep IPAddress

If everything is good so far then congratulations 😄 You have a complete app running with two microservices. To test this you can use CURL command from your host machine

1. Get homepage of your appcurl -X GET localhost:4000

2. Get list of all students from test databasecurl -X POST 192.168.43.147:4000/get-studentsHere 192.168.43.147 is my host IpAddressifconfig | grep inet

3. Add a new student to your test dbcurl --header "Content-Type: application/json" -d '{"rollNo": 1130360, "name": "Abhishek Goswami"}' -X POST localhost:4000/add-student

4. Again fetch all students to see updated resultscurl -X POST 192.168.43.147:4000/get-students

5. Modify source code of nodejs app, build image, run container and test again.

You can contact me atvarunon9@gmail.com or create github issues.