123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121 |
- platomix:
- etl:
- enabled: false
- flinkHome: /Users/wookvn/Documents/working/flink-1.15.4
- flinkVersion: 1.15.4
- flinkWebInterfaceUrls:
- - http://localhost:8081
- flinkResourceProvider: STANDALONE
- seatunnelHome: /Users/wookvn/Documents/working/apache-seatunnel-2.3.2
- seatunnelVersion: 2.3.2
- tempWorkspace: /Users/wookvn/Downloads/upload/test
- clusterCredentialPath: /Users/wookvn/Documents/working/hadoop-3.2.4/etc/hadoop
- preview-redis:
- host: 121.204.253.223
- port: 6379
- auth: ltbiydhao5
- database: 4
- sftp:
- host: 121.204.253.223
- port: 22
- user: root
- password: kk30@123
- uploadDir: /opt/bigdata/upload
- dsy: #数据同步的datax环境
- dataxHome: /opt/bigdata/datax
- dataxExecHome: /opt/bigdata/datax_data
- sshServers:
- - ip: 121.204.249.37
- user: root
- password: 993fNeaQ
-
- xxl:
- job:
- enabled: false
- ### xxl-job, access token
- accessToken: platomix_token
- admin:
- addresses: http://127.0.0.1:8191/xxl-job-admin
- # addresses: http://windata.platomix.net/xxl-job-admin
- executor:
- ### xxl-job executor address
- appname: platomix-etl
- groupid: 9 #对应appname的id值
- # ip: ''
- port: 6971
- ### xxl-job log retention days
- logretentiondays: 30
- ### xxl-job log path
- logpath: /data/applogs/xxl-job/jobhandler
- mybatis-plus:
- configuration:
- log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
-
- spring:
- cloud.discovery.client.simple:
- # 配置bi服务「bi-service」的ip和端口
- instances:
- system-service:
- - host: 39.99.245.43 #地址
- port: 6161 #端口
- datasource:
- dynamic:
- druid:
- #初始化大小,最小,最大
- initial-size: 0
- min-idle: 1
- max-active: 1
- #获取连接时最大等待时间,单位毫秒。配置了maxWait之后,缺省启用公平锁,
- max-wait: 60000
-
- #执行查询的超时时间【单位:秒,最终应用到Statement对象的超时】
- query-timeout: 10
- #一个事务的超时时间
- #transaction-query-timeout: 20
-
- #申请连接时执行validationQuery检测连接是否有效,做了这个配置会降低性能。
- test-on-borrow: false
- #归还连接时执行validationQuery检测连接是否有效,做了这个配置会降低性能
- test-on-return: false
- #设置从连接池获取连接时是否检查连接有效性,true时,如果连接空闲时间超过minEvictableIdleTimeMillis进行检查,否则不检查;false时,不检查
- test-while-idle: false
-
- #检查连接的方式和超时时间
- validation-query: "select 1"
- validation-query-timeout: 2000
-
- #配置间隔多久启动一次DestroyThread,对连接池内的连接才进行一次检测,单位是毫秒。
- #检测时: 1.如果连接空闲并且超过minIdle以外的连接,如果空闲时间超过minEvictableIdleTimeMillis设置的值则直接物理关闭。
- # 2.在minIdle以内的不处理。
- time-between-eviction-runs-millis: 60000
- #配置一个连接在池中最小生存的时间
- min-evictable-idle-time-millis: 180000
-
- #是否超时关闭连接 默认为false 【若为true 就算数据库恢复连接,也无法连接上】
- #break-after-acquire-failure: false
- #connection-error-retry-attempts: 1
- #time-between-connect-error-millis: 500
-
- #打开KeepAlive之后的效果
- #1>初始化连接池时会填充到minIdle数量。
- #2>连接池中的minIdle数量以内的连接,空闲时间超过minEvictableIdleTimeMillis,则会执行keepAlive操作。
- #3>当网络断开等原因产生的由ExceptionSorter检测出来的死连接被清除后,自动补充连接到minIdle数量。
- #连接池中的minIdle数量以内的连接,空闲时间超过minEvictableIdleTimeMillis,则会执行keepAlive操作
- #每次检查强制验证连接有效性 https://github.com/alibaba/druid/wiki/KeepAlive_cn
- #keepAlive: true
- #2次keepAlive操作的时间间隔
- #keep-alive-between-time-millis: 50000
- filters: slf4j
- primary: master #设置默认的数据源或者数据源组,默认值即为master
- datasource:
- master:
- driver-class-name: com.mysql.cj.jdbc.Driver
- url: jdbc:mysql://39.103.207.159:3306/digital_operation?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&allowPublicKeyRetrieval=true
- username: digital
- password: Dgb6inMBYtsMT#rS
- # url: jdbc:mysql://121.204.249.37:3306/digital_operation?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&allowPublicKeyRetrieval=true
- # username: root
- # password: Platomix@mysql123
- apimngr:
- insertUrl: http://121.204.252.205:8081/api/apimngr/insertNoAuth
|