![\"\"](\"https:\/\/developers.redhat.com\/blog\/wp-content\/uploads\/2017\/11\/Logotype_RH_OpenShiftContainerPlatform_wLogo_CMYK_Black-1024x263.jpg\")
<\/p>\n<\/p>\n
This article shows how to take an existing Spring Boot <\/a>standalone project that uses MySQL and deploy it on Red Hat OpenShift<\/a>, In the process, we\u2019ll create docker images which can be deployed to most container\/cloud platforms. I\u2019ll discuss creating a Dockerfile, pushing the container image to an OpenShift registry, and finally creating running pods with the Spring Boot app deployed.<\/p>\n To develop and test using OpenShift on my local machine, I used Red Hat Container Development Kit (CDK),<\/em><\/a> which provides a single-node OpenShift cluster running in a Red Hat Enterprise Linux VM, based on minishift. You can run CDK on top of Windows, macOS, or Red Hat Enterprise Linux. For testing, I used Red Hat Enterprise Linux Workstation release 7.3. It should work on macOS too.<\/p>\n To create the Spring Boot app I used this article<\/a> as a guide. I\u2019m using an existing openshift\/mysql-56-centos7<\/a> docker image to deploy MySQL to OpenShift.<\/p>\n You can download the code used in this article from my personal github repo. <\/a><\/em> In this article, I\u2019ll be building container images locally, so you\u2019ll need to be able to build the project locally with Maven. This example exposes a rest service using: com.sample.app.MainController.java<\/em>.<\/p>\n In the repository, you\u2019ll find a Dockerfile in src\/main\/docker-files\/. The dockerfile_springboot_mysql<\/a><\/em> file creates a docker image, having the Spring Boot application based on java8<\/em> docker<\/em> image as a base . While this is ok for testing, for production deployment you\u2019d want to use images that are based on Red Hat Enterprise Linux.<\/p>\n Building the application:<\/p>\n 1. Use mvn clean install to build the project.<\/p>\n 2. Copy the generated jar in the target folder to src\/main\/docker-files. When creating the docker image, the application jar can be found at the same location.<\/p>\n 3. Set the database username, password, and URL in src\/main\/resources\/application.properties. Note: For OpenShift, it is recommended to pass these parameters into the container as environment variables.<\/p>\n Now start the CDK VM to get your local OpenShift cluster running.<\/p>\n 1. Start the CDK VM using minishift start<\/em>:<\/p>\n $ minishift start<\/p>\n 2. Set your local environment for docker and the oc CLI:<\/p>\n $ eval $(minishift oc-env) Note: the above eval commands will not work on Windows. See the CDK documentation for more information.<\/p>\n 3. Login to OpenShift and Docker using the developer<\/em> account:<\/p>\n $ oc login Now we\u2019ll build the container images.<\/p>\n 1. Change the directory location to src\/main\/docker-files within the project. Then, execute the following commands to build the container<\/em> images. Note: The period (.) is required at the end of the docker build command to indicate the current directory:<\/p>\n $ docker build -t springboot_mysql -f .\/dockerfile_springboot_mysql .<\/p>\n Use the following command to view the container images that were created:<\/p>\n $ docker images<\/p>\n 2. Add the tag springboot_mysql to the image, and push it to the OpenShift registry:<\/p>\n $ docker tag springboot_mysql $(minishift openshift registry)\/myproject\/springboot_mysql 3. Next, pull the OpenShift MySQL<\/em> image, and create it as an OpenShift application which will initialize and run it. Refer to the documentation<\/a> for more information:<\/p>\n docker pull openshift\/mysql-56-centos7 4. Wait for the pod running MySQL to be ready. You can check the status with oc get pods:<\/p>\n $ oc get pods 5. Next, ssh to the mysql<\/em> pod and create a MySQL root user with full privileges:<\/p>\n $ oc rsh mysql-56-centos7-1-nvth9 GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ WITH GRANT OPTION; FLUSH PRIVILEGES; exit<\/p>\n 6. Finally, initialize the Spring Boot app using imagestream<\/em> springboot_mysql:<\/p>\n $ oc get svc $ oc new-app -e spring_datasource_url=jdbc:mysql:\/\/172.30.145.88:3306\/test springboot_mysql 7. Check the pod logs:<\/p>\n oc logs -f springbootmysql-1-5ngv4<\/p>\n 8. Next, expose the service as route:<\/p>\n $ oc get svc $ oc expose svc springbootmysql $ oc get route 9. Test the application using curl. You should see a list of all entries in the database table:<\/p>\n $ curl -v http:\/\/springbootmysql-myproject.192.168.42.182.nip.io\/demo\/all<\/p>\n 10. Next, use curl to create an entry in the db:<\/p>\n $ curl http:\/\/springbootmysql-myproject.192.168.42.182.nip.io\/demo\/add?name=SpringBootMysqlTest 11. View the updated list of entries in the database:<\/p>\n $ curl http:\/\/springbootmysql-myproject.192.168.42.182.nip.io\/demo\/all<\/p>\n [{“name”:”UBUNTU 17.10 LTS”,”lastaudit”:1502409600000,”id”:1},{“name”:”RHEL 7″,”lastaudit”:1500595200000,”id”:2},{“name”:”Solaris 11″,”lastaudit”:1502582400000,”id”:3},{“name”:”SpringBootTest”,”lastaudit”:1519603200000,”id”:4},{“name”:”SpringBootMysqlTest”,”lastaudit”:1519603200000,”id”:5}<\/p>\n That\u2019s it!<\/p>\n I hope this article is helpful to you for migrating an existing spring-boot<\/em> application to OpenShift. Just a note, in production environments, one should use Red Hat Supportable Images. This document is intended for development purposes only. It should assist you in creating spring-boot<\/em> applications that run in containers; and in how to set up MySQL<\/i> connectivity for spring-boot<\/em> in OpenShift.<\/p>\n
\n$ eval $(minishift docker-env)<\/p>\n
\n$ docker login -u developer -p $(oc whoami -t) $(minishift openshift registry)<\/p>\n
\n$ docker push $(minishift openshift registry)\/myproject\/springboot_mysql<\/p>\n
\noc new-app -e MYSQL_USER=root -e MYSQL_PASSWORD=root -e MYSQL_DATABASE=test openshift\/mysql-56-centos7<\/p>\n
\nNAME READY STATUS RESTARTS AGE
\nmysql-56-centos7-1-nvth9 1\/1 Running 0 3m<\/p>\n
\nsh-4.2$ mysql -u root
\nCREATE USER ‘root’@’%’ IDENTIFIED BY ‘root’;
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
\nNAME CLUSTER-IP EXTERNAL-IP PORT(S) AGE
\nmysql-56-centos7 172.30.145.88 none 3306\/TCP 8m<\/p>\n
\n$ oc get pods
\nNAME READY STATUS RESTARTS AGE
\nmysql-56-centos7-1-nvth9 1\/1 Running 0 12m
\nspringbootmysql-1-5ngv4 1\/1 Running 0 9m<\/p>\n
\nNAME CLUSTER-IP EXTERNAL-IP PORT(S) AGE
\nmysql-56-centos7 172.30.242.225 none 3306\/TCP 14m
\nspringbootmysql 172.30.207.116 none 8080\/TCP 1m<\/p>\n
\nroute “springbootmysql” exposed<\/p>\n
\nNAME HOST\/PORT PATH SERVICES PORT TERMINATION WILDCARD
\nspringbootmysql springbootmysql-myproject.192.168.42.182.nip.io springbootmysql 8080-tcp None<\/p>\n
\nSaved<\/p>\n