MySQL Integration

Introduction

MySQL is the most-deployed open-source SQL database. Spring Boot integrates with it via the JDBC driver + Hibernate dialect — three lines of config and you're connected.

Informative example

# pom.xml
<dependency>
  <groupId>com.mysql</groupId>
  <artifactId>mysql-connector-j</artifactId>
  <scope>runtime</scope>
</dependency>

# application.yml
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/orders?useSSL=false&serverTimezone=UTC
    username: ${DB_USER}
    password: ${DB_PASS}
  jpa:
    hibernate:
      ddl-auto: validate
    properties:
      hibernate.dialect: org.hibernate.dialect.MySQLDialect

Best practices

• Use utf8mb4 charset — full Unicode (emojis included).
• Pin connection pool: spring.datasource.hikari.maximum-pool-size: 20.
• ddl-auto: validate in prod — schema is owned by Flyway/Liquibase, not Hibernate.