Spring Boot Kubernetes and MySQL

Sample project to test and deploy spring boot application with mysql database in kubernetes.

Prerequisite

• Docker with kubernetes enabled
• Kubernetes command-line tool(kubectl)
• JDK 21 LTS
• Gradle 8

Start application

• Create secrets and start mysql database

kubectl apply -f deployment/secrets.yaml
kubectl apply -f deployment/mysql-deployment.yaml

• Build application and deploy in kubernetes

gradle clean build -i --stacktrace
docker build -t ashutoshsahoo/spring-boot-kubernetes-mysql:6.2.0 . 
kubectl apply -f deployment/app-k8s.yaml

• Test application :

curl -X GET \
  http://localhost:31371/api/v1/pets \
  -H 'Accept: application/json' \
  -H 'Content-Type: application/json'
  

Response should be :

[
  {
    "name": "Puffball",
    "owner": "Diane",
    "species": "hamster",
    "sex": "f",
    "birth": "1999-03-30",
    "death": null
  }
]

Delete deployment, service, secret and pvc

kubectl delete -f deployment/app-k8s.yaml
kubectl delete -f deployment/mysql-deployment.yaml
kubectl delete -f deployment/secrets.yaml

Code Analysis

Set the Sonarqube URL and token in gradle.properties file.

 gradle clean build sonar --stacktrace

Reference

• Spring Boot
• Gradle Docker image build plugin
• OpenJDK Docker
• MySQL Docker