faisalferoz / embedded-mysql-spring-boot

Start an embedded MySQL before the `DataSource` is loaded

Embedded MySQL Spring Boot Starter

What It Is

It is an embedded MySQL for instead H2/Sqlite etc.

Before use,Please OPEN https://github.com/liuyuyu/embedded-mysql-spring-boot/blob/master/embedded-mysql-demo/README.md

Usage

add dependency in pom.xml

<dependency>
  <groupId>io.github.liuyuyu</groupId>
  <artifactId>embedded-mysql-spring-boot-starter</artifactId>
  <version>0.0.1</version>
</dependency>

application.properties

# Enable MySQL
spring.datasource.embedded.mysql.enable=true

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3333/test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2b8&nullNamePatternMatchesAll=true
# username. Always correct!
spring.datasource.username=test_user
# password. Always correct!
spring.datasource.password=

# MySQL port
spring.datasource.embedded.mysql.port=3333
# DML v1_1_function.sql,v1_2_init_data.sql
spring.datasource.embedded.mysql.script-locations=classpath:/sql/*.sql
# MySQL Version
spring.datasource.embedded.mysql.version=v5_6_21

Run XXXSpringApplication.java Console will output log like this first time

2019-04-19 19:54:11.110  INFO 14499 --- [           main] com.wix.mysql.EmbeddedMysql              : Preparing EmbeddedMysql version 'Version 5.6.21'...
Download Version 5.6.21:OS_X:B64 START
Download Version 5.6.21:OS_X:B64 DownloadSize: 173770339
Download Version 5.6.21:OS_X:B64 0%
Download Version 5.6.21:OS_X:B64 5%
...........
Download Version 5.6.21:OS_X:B64 100%
Download Version 5.6.21:OS_X:B64 downloaded with 747kb/s
Download Version 5.6.21:OS_X:B64 DONE
Extract /Users/liuyuyu/.embedmysql/MySQL-5.6/mysql-5.6.21-osx10.9-x86_64.tar.gz START
...........
Extract /Users/liuyuyu/.embedmysql/MySQL-5.6/mysql-5.6.21-osx10.9-x86_64.tar.gz DONE
2019-04-19 19:58:05.062  INFO 14499 --- [           main] com.wix.mysql.MysqldExecutable           : Preparing mysqld for startup
2019-04-19 19:58:08.772  INFO 14499 --- [           main] com.wix.mysql.MysqldExecutable           : Starting MysqldProcess
2019-04-19 19:58:09.369  INFO 14499 --- [           main] d.f.embed.process.runtime.Executable     : start com.wix.mysql.config.MysqldConfig@122635ef

enjoy it Luck Dog!

MySQL Version

spring.datasource.embedded.mysql.version

v5_5_40
v5_5_50
v5_5_51
v5_5_52
v5_5_latest
v5_6_21
v5_6_22
v5_6_23
v5_6_24
v5_6_31
v5_6_32
v5_6_33
v5_6_34
v5_6_35
v5_6_36
v5_6_latest
v5_7_10
v5_7_13
v5_7_14
v5_7_15
v5_7_16
v5_7_17
v5_7_18
v5_7_19
v5_7_latest

MySQL Installer Folder

If the download address is https://cdn.mysql.com//archives/mysql-5.6/mysql-5.6.21-winx64.zip, the installation directory is ~/.embedmysql/MySQL-5.6/mysql-5.6.21-winx64.zip, you can download the zip file yourself and extract it to the corresponding directory.