| | |
| | | --- # 临时文件存储位置 避免临时文件被系统清理报错 |
| | | spring.servlet.multipart.location: /ruoyi/server/temp |
| | | |
| | | --- # 监控中心配置 |
| | | spring.boot.admin.client: |
| | | # 增加客户端开关 |
| | |
| | | # 动态数据源文档 https://www.kancloud.cn/tracy5546/dynamic-datasource/content |
| | | dynamic: |
| | | # 性能分析插件(有性能损耗 不建议生产环境使用) |
| | | p6spy: false |
| | | p6spy: true |
| | | # 设置默认的数据源或者数据源组,默认值即为 master |
| | | primary: master |
| | | # 严格模式 匹配不到数据源则报错 |
| | |
| | | driverClassName: com.mysql.cj.jdbc.Driver |
| | | # jdbc 所有参数配置参考 https://lionli.blog.csdn.net/article/details/122018562 |
| | | # rewriteBatchedStatements=true 批处理优化 大幅提升批量插入更新删除性能(对数据库有性能损耗 使用批量操作应考虑性能问题) |
| | | url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true |
| | | url: jdbc:mysql://123.207.71.245:13306/qysp?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true |
| | | username: root |
| | | password: root |
| | | password: 234#Wersdf! |
| | | # url: jdbc:mysql://80.36.32.175:3306/qysp?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true |
| | | # username: root |
| | | # password: 234#Wersdf! |
| | | # url: jdbc:mysql://51.9.57.211:3306/qysp?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true |
| | | # username: root |
| | | # password: 234#Wersdf! |
| | | # url: jdbc:mysql://172.35.50.34:3306/qysp?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true |
| | | # username: root |
| | | # password: 234#Wersdf! |
| | | # 从库数据源 |
| | | slave: |
| | | lazy: true |
| | |
| | | url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true |
| | | username: |
| | | password: |
| | | # oracle: |
| | | # type: ${spring.datasource.type} |
| | | # driverClassName: oracle.jdbc.OracleDriver |
| | | # url: jdbc:oracle:thin:@//localhost:1521/XE |
| | | # username: ROOT |
| | | # password: root |
| | | # hikari: |
| | | # connectionTestQuery: SELECT 1 FROM DUAL |
| | | # postgres: |
| | | # type: ${spring.datasource.type} |
| | | # driverClassName: org.postgresql.Driver |
| | | # url: jdbc:postgresql://localhost:5432/postgres?useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true |
| | | # username: root |
| | | # password: root |
| | | # sqlserver: |
| | | # type: ${spring.datasource.type} |
| | | # driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver |
| | | # url: jdbc:sqlserver://localhost:1433;DatabaseName=tempdb;SelectMethod=cursor;encrypt=false;rewriteBatchedStatements=true |
| | | # username: SA |
| | | # password: root |
| | | # oracle: |
| | | # type: ${spring.datasource.type} |
| | | # driverClassName: oracle.jdbc.OracleDriver |
| | | # url: jdbc:oracle:thin:@//localhost:1521/XE |
| | | # username: ROOT |
| | | # password: root |
| | | # hikari: |
| | | # connectionTestQuery: SELECT 1 FROM DUAL |
| | | # postgres: |
| | | # type: ${spring.datasource.type} |
| | | # driverClassName: org.postgresql.Driver |
| | | # url: jdbc:postgresql://localhost:5432/postgres?useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true |
| | | # username: root |
| | | # password: root |
| | | # sqlserver: |
| | | # type: ${spring.datasource.type} |
| | | # driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver |
| | | # url: jdbc:sqlserver://localhost:1433;DatabaseName=tempdb;SelectMethod=cursor;encrypt=false;rewriteBatchedStatements=true |
| | | # username: SA |
| | | # password: root |
| | | hikari: |
| | | # 最大连接池数量 |
| | | maxPoolSize: 20 |
| | |
| | | spring.data: |
| | | redis: |
| | | # 地址 |
| | | host: localhost |
| | | host: 162.14.79.111 |
| | | # 端口,默认为6379 |
| | | port: 6379 |
| | | port: 16379 |
| | | password: 234#Wersdf! |
| | | # 数据库索引 |
| | | database: 0 |
| | | # 密码(如没有密码请注释掉) |
| | |
| | | # redis key前缀 |
| | | keyPrefix: |
| | | # 线程池数量 |
| | | threads: 16 |
| | | threads: 4 |
| | | # Netty线程池数量 |
| | | nettyThreads: 32 |
| | | nettyThreads: 8 |
| | | # 单节点配置 |
| | | singleServerConfig: |
| | | # 客户端名称 |
| | | clientName: ${ruoyi.name} |
| | | # 最小空闲连接数 |
| | | connectionMinimumIdleSize: 32 |
| | | connectionMinimumIdleSize: 8 |
| | | # 连接池大小 |
| | | connectionPoolSize: 64 |
| | | connectionPoolSize: 32 |
| | | # 连接空闲超时,单位:毫秒 |
| | | idleConnectionTimeout: 10000 |
| | | # 命令等待超时,单位:毫秒 |
| | |
| | | #地域信息默认为 ap-guangzhou 如无特殊改变可不用设置 |
| | | territory: ap-guangzhou |
| | | |
| | | |
| | | --- # 三方授权 |
| | | justauth: |
| | | enabled: true |