Ticket 04: Set Up MySQL Database with Docker

[markcdev101]

Description: Set up a MySQL database in Docker for local development. Configure Spring Boot to connect to MySQL.

Spring Boot Concepts:

• Spring Data JPA (Java Persistence API): Database integration
• External Configuration: Using application.yml

Guide:

• Set up a MySQL Docker container using docker-compose.yml. Here’s an example Docker Compose configuration:
• Configure Spring Boot in the application.yml to connect to the MySQL instance:
• Run the MySQL container and verify the connection from the Spring Boot app by checking the logs or querying the database.

Acceptance Criteria:

• [x] - Docker container running MySQL.
• [x] - Spring Boot successfully connects to the MySQL database.
• [ ] - Initial test query (e.g., fetching recipes) confirms database functionality.

[markcdev101]

Set up a MySQL Docker container using docker-compose.yml. Here’s an example Docker Compose configuration: Step by Step Completed:

1. Added docker-compose.yml to the root directory
2. then run this command - docker-compose up -d
3. then run this command to check if the container is running - docker ps

[markcdev101]

Configure Spring Boot in the application.yml to connect to the MySQL instance: Step by Step Completed:

1. Add application.yaml to include information about the MySQL DB
2. Add MySQL Driver dependency
3. Verify connection by running the following commands mvn spring-boot:run
4. Checks the logs for the following: HikariPool-1 - Starting... HikariPool-1 - Start completed.

[markcdev101]

Run the MySQL container and verify the connection from the Spring Boot app by checking the logs or querying the database.

Initial test shows that endpoints are working as expected.