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>

Logo

北京人形旗下天工造物具身智能开源社区,聚焦具身天工与慧思开物两大平台

更多推荐