zjh20241202-3

zjh

2024-12-03 06ef175a1e9f72b3863757319b2f6ff76c5a2f05

 ltkj-admin/src/main/resources/application-druid.yml

@@ -6,20 +6,36 @@
    druid:
      # 主库数据源
      master:
        #url: jdbc:mysql://192.168.0.101:3306/mydb?serverTimezone=UTC
        #url: jdbc:mysql://47.109.86.30:3306/ltkj_tj1.0?serverTimezone=GMT%2B8
        url: jdbc:mysql://101.42.27.146:3306/ltkj_tj1.0?serverTimezone=GMT%2B8
        #url: jdbc:mysql://192.168.0.101:3306/mydb?serverTimezone=GMT%2B8
#        url: jdbc:mysql://localhost:3306/ltkj_tj1.0?serverTimezone=GMT%2B8
#        url: jdbc:mysql://localhost:3306/ltkj_tj2.0?serverTimezone=GMT%2B8
        username: root
        #password: Root_ltkj123
        password: Root_ltkj123
      # 从库数据源
      slave:
      slavepacs:
        # 从数据源开关/默认关闭
        enabled: false
        url:
        username:
        password:
#        enabled: true
#        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
#        url: jdbc:sqlserver://192.168.0.111:1433;DatabaseName=Testlg
#        username: sa
#        password: admin123
      # 从库数据源
      slavehis:
        # 从数据源开关/默认关闭
#        enabled: true
#        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
#        url: jdbc:sqlserver://192.168.0.111:1433;DatabaseName=Testlg
#        username: sa
#        password: admin123
      # 从库数据源
      slavelis:
        # 从数据源开关/默认关闭
#        enabled: true
#        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
#        url: jdbc:sqlserver://192.168.0.111:1433;DatabaseName=Testlg
#        username: sa
#        password: admin123
      # 初始连接数
      initialSize: 5
      # 最小连接池数量
@@ -35,7 +51,7 @@
      # 配置一个连接在池中最大生存的时间，单位是毫秒
      maxEvictableIdleTimeMillis: 900000
      # 配置检测连接是否有效
      validationQuery: SELECT 1 FROM DUAL
      validationQuery: SELECT 1
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false