若依spring cloud 配置clickhouse
·
nacos配置:
datasource:
druid:
stat-view-servlet:
enabled: true
loginUsername: admin
loginPassword: 123456
dynamic:
druid:
initial-size: 5
min-idle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
maxPoolPreparedStatementPerConnectionSize: 20
filters: stat,slf4j
connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
primary: master
datasource:
# 主库数据源
master:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
username: root
password: root
# 从库数据源
clickhouse:
username: default
password: 'test@12345'
url: jdbc:clickhouse://localhost:8123/trust-cloud?max_query_size=100000000000000000
driver-class-name: com.clickhouse.jdbc.ClickHouseDriver
druid: # 以下是独立参数,每个库可以重新设置
initial-size: 5
max-active: 30
min-idle: 5
max-wait: 120000
min-evictable-idle-time-millis: 600000
max-evictable-idle-time-millis: 600000
time-between-eviction-runs-millis: 60000
validation-query: select 1
validation-query-timeout: -1
test-on-borrow: false
test-on-return: false
test-while-idle: true
pool-prepared-statements: true
share-prepared-statements: true
POM文件新增clickhose连接依赖:
<dependency>
<groupId>com.clickhouse</groupId>
<artifactId>clickhouse-jdbc</artifactId>
<version>0.3.2-patch11</version>
</dependency>
更多推荐
所有评论(0)