In this tutorial, I will take you step by step how to dockerize SpringBoot with MySQL database. And it’s quite a clear process. It takes three main steps which we would take in this tutorial. Then I’ll briefly talk about docker networks.<\/p>\n
So let’s get started!<\/p>\n
This lessons corresponds to Part 53 of the video series on FleetMS version 2.<\/p>\n
<\/p>\n
Now we first obtain a MySQL image. We don’t have to build this as it is already available in docker hub. We’ll simply pull it from there. Then we need to run the image. To run the image, we specify the image name as well as the following environment variables:<\/p>\n
Let’s follow the steps below<\/p>\n
Step 1<\/strong> – Pull the MySQL image using the command below<\/p>\n Then you can use the docker image ls<\/strong> <\/em>command to check that the mysql image was pulled.<\/p>\n Step 2<\/strong> – We now run the mysql image using the following command:<\/p>\n The port parameter indicates that the mysql runs on port 3308 outside the container and 3306 inside the container. So the port mapping is outside:inside<\/strong><\/em><\/p>\n Step 3<\/strong> – Connect to the container and access the database inside the container. Use the command:<\/p>\n <\/p>\n Step 4<\/strong> – Login into the MySQL server using the command:<\/p>\n After getting in, you can use the show databases command to display the databases in the server. You will see that the fleetdb-docker database is available as well.<\/p>\n Optional<\/strong> – Try to connect to MySQL container using MySQL Workbench via port 3308<\/p>\n <\/p>\n Now we would have to also create a docker image of our Spring Boot application. There are two ways to do it: with Dockerfile and without Dockerfile(using Buildpacks, the easy way!). Learn both ways here<\/a>. In this tutorial, we would use Dockerfile.<\/p>\n Step 1<\/strong> – Create a file named Dockerfile in the root directory of the Spring Boot application. It should have the following content:<\/p>\n <\/p>\n Update:<\/strong> For Spring Boot 3.0, you have to use this:<\/p>\n <\/p>\n Step 2<\/strong>\u00a0– Adjust the spring.datasource.url<\/strong> <\/em>parameter in the application.properties file to\u00a0 connect to the MySQL database in the container. So the new value would be:<\/p>\n Note we changed the port number and the database name. Also remember to set the right username and password.<\/p>\n Step 3<\/strong>\u00a0– From the root directory of the project, run the command<\/p>\n Note the period at the end!<\/p>\n You can now use docker images command to check the the fleet-image is created.<\/p>\n Step 4<\/strong> – Start the application again and ensure it works.<\/p>\n What we’ve\u00a0<\/strong>achieved<\/b><\/p>\n We have succeeded in creating an image of\u00a0 our application and we also pulled a MySQL image. Then we made our application run locally and connect to MySQL inside a container. Read on for next steps<\/p>\n <\/p>\n Now we want our application run inside a container as well as the MySQL. So somehow we need to network the two containers. This is called Docker Network<\/strong>.<\/p>\n Step 1<\/strong> – Adjust the spring.datasource.url parameters to point to the docker-mysql image, then change the port to the internal port. So it would look like this:<\/p>\n Remember you need to rebuild the image after this change.<\/p>\n We would now spin up the container for our application such that it starts up along with the MySQL containers as well.<\/p>\n Step 2<\/strong> – Start the application using the following command<\/p>\n <\/p>\n This command spins up both containers and they’ll just work fine.\u00a0 If you got here thus far, thumbs up to you. We could cover the following topics in subsequent tutorials:<\/p>\n <\/p>\n Similar to how we used the –link option in the docker run command, we can also use docker networks to achieve same objective. We simply have to create\u00a0 a new network and then assign the two containers to the same network and that’s it!<\/p>\n Let follow the steps:<\/p>\n Step 1<\/strong> – Create a docker network using the command below:<\/p>\n The network is created and you can use docker network ls<\/em><\/strong> to see the networks.<\/p>\n Step 2<\/strong> – Connect the mysql-docker container to the fleet-net docker network using the command:<\/p>\n <\/p>\n Step 3<\/strong> – Connect the fleet-image container to the command below:<\/p>\n <\/p>\n You can go ahead to test the network just like before.<\/p>\n","protected":false},"excerpt":{"rendered":" In this tutorial, I will take you step by step how to dockerize SpringBoot with MySQL database. And it’s quite a clear process. It takes … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[311],"tags":[],"class_list":["post-1995","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=1995"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1995\/revisions"}],"predecessor-version":[{"id":2163,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1995\/revisions\/2163"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=1995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=1995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=1995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}docker pull mysql\r\n<\/pre>\n
docker run -d -p 3308:3306 --name=mysql-docker --env=\"MYSQL_ROOT_PASSWORD=root\" --env=\"MYSQL_PASSWORD=root\" --env=\"MYSQL_DATABASE=fleetdb_docker\" mysql\r\n<\/pre>\n
docker exec -it mysql-docker bash\r\n<\/pre>\n
mysql -uroot -proot\r\n<\/pre>\n
2. Setup the Spring Boot Container<\/strong><\/h4>\n
FROM adoptopenjdk\/openjdk11:alpine-jre\r\nADD target\/fleetapp_v2-0.0.1-SNAPSHOT.jar app.jar\r\nENTRYPOINT [\"java\",\"-jar\",\"\/app.jar\"]\r\n<\/pre>\n
FROM openjdk:17-jdk-alpine\r\nADD target\/product-app-0.0.1-SNAPSHOT.jar app.jar\r\nENTRYPOINT [\"java\",\"-jar\",\"\/app.jar\"]\r\n<\/pre>\n
spring.datasource.url=jdbc:mysql:\/\/mysql-docker:3308\/fleetdb_docker?serverTimezone=UTC\r\n<\/pre>\n
docker build -t fleet-image .\r\n<\/pre>\n
3. Link the two Container<\/strong><\/h4>\n
spring.datasource.url=jdbc:mysql:\/\/mysql-docker:3306\/fleetdb_docker?serverTimezone=UTC\r\n<\/pre>\n
docker run -t --link mysql-docker:mysql -p 8080:8080 fleet-image\r\n<\/pre>\n
\n
4. Basics of Docker Networks<\/strong><\/h4>\n
docker network create fleet-net\r\n<\/pre>\n
docker network connect fleet-net mysql-docker\r\n<\/pre>\n
docker network connect fleet-net fleet-image\r\n<\/pre>\n