123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149 |
- spring:
- datasource:
- druid:
- master:
- driver-class-name: com.mysql.cj.jdbc.Driver
- url: jdbc:mysql://123.60.19.203:5006/hitch-sb-demo?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true&removeAbandoned=true&removeAbandonedTimeout=60&logAbandoned=true
- username: root
- password: mysql?MYSQLmoniu123
- #url: jdbc:mysql://localhost:3306/hitch-sb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
- #username: root
- #password: 123456
- filters: wall,stat
- filter:
- stat:
- log-slow-sql: true
- #慢sql
- slow-sql-millis: 1000
- #初始化大小、最小、最大
- initial-size: 1
- max-active: 50
- max-pool-prepared-statement-per-connection-size: 20
- #获取连接等待超时的时间
- max-wait: 60000
- #一个连接在池中最小生存的时间,单位是毫秒
- min-evictable-idle-time-millis: 300000
- min-idle: 5
- #打开PSCache,并且指定每个连接上PSCache的大小
- #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
- pool-prepared-statements: false
- test-on-borrow: true
- test-on-return: true
- test-while-idle: true
- #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
- time-between-eviction-runs-millis: 60000
- validation-query: SELECT 'x'
- slave:
- driver-class-name: com.mysql.cj.jdbc.Driver
- url: jdbc:mysql://123.60.19.203:5006/hitch-sb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
- username: root
- password: mysql?MYSQLmoniu123
- #url: jdbc:mysql://localhost:3306/hitch-sb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
- #username: root
- #password: 123456
- filters: wall,stat
- filter:
- stat:
- log-slow-sql: true
- #慢sql
- slow-sql-millis: 1000
- #初始化大小、最小、最大
- initial-size: 1
- max-active: 50
- max-pool-prepared-statement-per-connection-size: 20
- #获取连接等待超时的时间
- max-wait: 60000
- #一个连接在池中最小生存的时间,单位是毫秒
- min-evictable-idle-time-millis: 300000
- min-idle: 5
- #打开PSCache,并且指定每个连接上PSCache的大小
- #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
- pool-prepared-statements: false
- test-on-borrow: true
- test-on-return: true
- test-while-idle: true
- #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
- time-between-eviction-runs-millis: 60000
- validation-query: SELECT 'x'
- qykh:
- driver-class-name: com.mysql.cj.jdbc.Driver
- url: jdbc:mysql://139.159.196.89:33306/qykh?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&allowMultiQueries=true
- username: qykh
- password: qykh@CQDWJS@!123
- filters: wall,stat
- filter:
- stat:
- log-slow-sql: true
- #慢sql
- slow-sql-millis: 1000
- #初始化大小、最小、最大
- initial-size: 1
- max-active: 50
- max-pool-prepared-statement-per-connection-size: 20
- #获取连接等待超时的时间
- max-wait: 60000
- #一个连接在池中最小生存的时间,单位是毫秒
- min-evictable-idle-time-millis: 300000
- min-idle: 5
- #打开PSCache,并且指定每个连接上PSCache的大小
- #如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。分库分表较多的数据库,建议配置为false。
- pool-prepared-statements: false
- test-on-borrow: true
- test-on-return: true
- test-while-idle: true
- #间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
- time-between-eviction-runs-millis: 60000
- validation-query: SELECT 'x'
- stat-view-servlet:
- login-password: platform8888
- login-username: root
- stat-view-servlet:
- login-password: platform8888
- login-username: root
- jpa:
- properties:
- hibernate:
- temp:
- use_jdbc_metadata_defaults: false
- dialect: org.hibernate.dialect.MySQLDialect
- # mybaits配置 tk
- mybatis:
- mapper-locations: classpath:mapper/**/*.xml
- configuration:
- map-underscore-to-camel-case: true
- call-setters-on-nulls: true
- jdbc-type-for-null: NULL
- # mybaits配置 tk
- mapper:
- mappers:
- - com.platform.dao.config.MyMapper
- not-empty: false
- identity: MYSQL
- data:
- aspect:
- method:
- names: get,select
- quartz:
- datasource:
- quartzDataSource:
- driver: ${spring.datasource.druid.master.driver-class-name}
- url: ${spring.datasource.druid.master.url}
- user: ${spring.datasource.druid.master.username}
- password: ${spring.datasource.druid.master.password}
- maxConnections: 5
- validationQuery: select 0
- connection-provider:
- class: com.platform.dao.quartz.DruidConnectionProvider
- logging:
- level:
- com.platform.dao.mapper: DEBUG
- org.activiti: DEBUG
- influx:
- url: http://localhost:8086
- token: qEMI2lHel0NPscN32WgmZtuymxmYZZZv67hHeRGA2_VJ_gd5sHH_QTyZ34T_ThhcbwFaqx4Qs9Q5BQBNpfMLkg==
|