wuzeyu
2024-08-23 783636b8af8b5309ad1e6f1598aed7df10bebb63
pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
@@ -5,16 +5,21 @@
            #name: ym
            type: com.alibaba.druid.pool.DruidDataSource
            driverClassName: com.mysql.cj.jdbc.Driver
            url: jdbc:mysql://192.168.91.73:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
#            url: jdbc:mysql://192.168.40.166:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
            url: jdbc:mysql://8.130.130.233:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
            #url: jdbc:mysql://8.140.179.55:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
#            url: jdbc:mysql://127.0.0.1:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
            username: root
            password: dysql,;.abc!@#
            druid:
                # 数据源名称:当存在多个数据源时,设置名字可以很方便的来进行区分,默认自动生成名称,格式是:"DataSource-" + System.identityHashCode(this)
                name: druid-mysql-ym
                #配置初始化大小、最小、最大
                initialSize: 1
                minIdle: 1
                initialSize: 10
                minIdle: 10
                maxActive: 100
                #配置获取连接等待超时的时间,单位是毫秒
                maxWait: 6000
                # 获取连接时最大等待时间,单位毫秒。配置了maxWait之后,缺省启用公平锁,并发效率会有所下降,如果需要可以通过配置useUnfairLock属性为true使用非公平锁
                maxWait: 60000
                #配置间隔多久进行一次检测,检测需要关闭的空闲连接,单位毫秒。 默认是60s,太长可能会导致无法及时检测到连接中断
                timeBetweenEvictionRunsMillis: 60000
                #配置一个连接在连接池中的最小生存时间、最大生存时间,超过最大生存时间会被移除,单位毫秒。
@@ -42,7 +47,8 @@
                maxPoolPreparedStatementPerConnectionSize: 20
                #属性类型是字符串,通过别名的方式配置扩展插件,常用的插件有:
                #监控统计用的filter:stat,日志用的filter:log4j,防御sql注入的filter:wall
                filters: stat,wall,config
                #filters: stat,wall,config
                filters: wall,config
                webStatFilter:
                    # 添加过滤规则
                    urlPattern: /*
@@ -59,5 +65,6 @@
                        # 是否可以重置数据
                        resetEnable: false
                        # 开启druid监控页面
                        enabled: true
                        #enabled: true
                        enabled: false