com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

CommunicationsException, druid version 1.1.10, jdbcUrl : jdbc:mysql://ip:port/rd_assembling?serverTimezone=UTC&
useLegacyDatetimeCode=false&characterEncoding=UTF-8&useSSL=false, testWhileIdle true, idle millis 9947, minIdle 0, poolingCount 0,
 timeBetweenEvictionRunsMillis 60000, lastValidIdleMillis 9947, driver com.mysql.cj.jdbc.Driver, 
exceptionSorter com.alibaba.druid.pool.vendor.MySqlExceptionSorter

解决方案：

mysql 配置

spring.datasource.druid.test-on-borrow=true
spring.datasource.druid.test-while-idle=true



这个配置加上 &autoReconnect=true
spring.datasource.url

如果使用集群

org.quartz.dataSource.qzDS.URL 
后面也加上&autoReconnect=true