Java - Spring + MySQL

Spring is a framework for Java, ideal for web applications as it is optimized to run multiple services in parallel and securely in a RESTful manner. It is also compatible with other Java frameworks.

MySQL is a widely used open-source relational database management system that allows storing, organizing, and retrieving data efficiently. Developed by Oracle, MySQL offers high speed and reliability, facilitating data management through SQL queries. Its scalability, support for multiple platforms, and ability to integrate with numerous programming languages make it a popular choice for web and enterprise applications. MySQL is highly customizable and has an active developer community that contributes to its continuous improvement.

Project structure

text

.
├── app
│   ├── pom.xml
│   ├── src
│   │   └── main
│   │       ├── java
│   │       │   └── com
│   │       │       └── company
│   │       │           └── project
│   │       │               ├── Application.java
│   │       │               ├── configuration
│   │       │               │   └── DockerSecretsProcessor.java
│   │       │               ├── controllers
│   │       │               │   └── HomeController.java
│   │       │               ├── entity
│   │       │               │   └── Greeting.java
│   │       │               └── repository
│   │       │                   └── GreetingRepository.java
│   │       └── resources
│   │           ├── application.properties
│   │           ├── data.sql
│   │           ├── META-INF
│   │           │   └── spring.factories
│   │           └── schema.sql
│   └── target
│       └── classes
│           ├── application.properties
│           ├── com
│           │   └── company
│           │       └── project
│           │           ├── Application.class
│           │           ├── configuration
│           │           │   └── DockerSecretsProcessor.class
│           │           ├── controllers
│           │           │   └── HomeController.class
│           │           ├── entity
│           │           │   └── Greeting.class
│           │           └── repository
│           │               └── GreetingRepository.class
│           ├── data.sql
│           ├── META-INF
│           │   └── spring.factories
│           └── schema.sql
├── app.Dockerfile
├── compose.yaml
├── nginx
│   └── default.conf
├── backup
│   └── backup-runner.sh
├── .env
└── .env.example

Application deployment:

We navigate to the directory that contains the files needed to build the container:

cd /root/stack/python/nextjs

And bring the application up:

text

docker compose up -d

Useful commands:

View running containers:

text

docker compose ps

Stop and remove the application:

text

docker compose down

Rebuild the application after making code changes:

text

docker compose up -d --build