springboot整合mysql5.7_Springboot整合Bboss实现mysql数据同步至ES

1.pom.xml

org.springframework.boot

spring-boot-starter-web

org.springframework.boot

spring-boot-devtools

runtime

true

org.projectlombok

lombok

true

org.springframework.boot

spring-boot-starter-test

test

org.junit.vintage

junit-vintage-engine

junit

junit

4.12

com.bbossgroups.plugins

bboss-elasticsearch-rest-jdbc

6.0.2

com.bbossgroups.plugins

bboss-elasticsearch-spring-boot-starter

6.0.2

org.xerial

sqlite-jdbc

3.23.1

compile

mysql

mysql-connector-java

5.1.40

2.application.properties

##ES集群配置，支持x-pack和searchguard

#spring.elasticsearch.bboss.elasticUser=elastic

#spring.elasticsearch.bboss.elasticPassword=changeme

spring.elasticsearch.bboss.elasticsearch.rest.hostNames=192.168.1.224:9200

#spring.elasticsearch.bboss.elasticsearch.rest.hostNames=10.180.211.27:9280,10.180.211.27:9281,10.180.211.27:9282

##https配置，添加https://协议头

#spring.elasticsearch.bboss.default.elasticsearch.rest.hostNames=https://10.180.211.27:9280,https://10.180.211.27:9281,https://10.180.211.27:9282

spring.elasticsearch.bboss.elasticsearch.dateFormat=yyyy.MM.dd

spring.elasticsearch.bboss.elasticsearch.timeZone=Asia/Shanghai

#在控制台输出脚本调试开关showTemplate,false关闭，true打开，同时log4j至少是info级别

spring.elasticsearch.bboss.elasticsearch.showTemplate=true

spring.elasticsearch.bboss.elasticsearch.discoverHost=false

# dsl配置文件热加载扫描时间间隔，毫秒为单位，默认5秒扫描一次，<= 0时关闭扫描机制

spring.elasticsearch.bboss.dslfile.refreshInterval = -1

#设置slice scroll查询对应的线程数和等待队列数

spring.elasticsearch.bboss.elasticsearch.sliceScrollThreadCount=100

spring.elasticsearch.bboss.elasticsearch.sliceScrollThreadQueue=100

spring.elasticsearch.bboss.elasticsearch.sliceScrollBlockedWaitTimeout=0

#设置scroll查询对应的线程数和等待队列数

spring.elasticsearch.bboss.elasticsearch.scrollThreadCount=200

spring.elasticsearch.bboss.elasticsearch.scrollThreadQueue=200

spring.elasticsearch.bboss.elasticsearch.scrollBlockedWaitTimeout=0

##es client http连接池配置

spring.elasticsearch.bboss.http.timeoutConnection = 5000

spring.elasticsearch.bboss.http.timeoutSocket = 5000

spring.elasticsearch.bboss.http.connectionRequestTimeout=5000

spring.elasticsearch.bboss.http.retryTime = 1

spring.elasti