| | |
|---|
| | | port: 8235 |
|---|
| | | spring: |
|---|
| | | datasource: |
|---|
| | | # url: jdbc:mysql://127.0.0.1:6306/8.4?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&serverTimezone=Europe/Paris&useLegacyDatetimeCode=false |
|---|
| | | url: jdbc:mysql://127.0.0.1:6306/trading_order_md?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&serverTimezone=Europe/Paris&useLegacyDatetimeCode=false |
|---|
| | | username: trading_order_md |
|---|
| | | password: 7M78MKDmA5mk7h7b |
|---|
| | | # url: jdbc:mysql://127.0.0.1:6306/8.4?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&serverTimezone=Asia/Tokyo&useLegacyDatetimeCode=false |
|---|
| | | url: jdbc:mysql://127.0.0.1:3306/trading_order?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&serverTimezone=Asia/Tokyo&useLegacyDatetimeCode=false |
|---|
| | | username: trading_order |
|---|
| | | password: dhG2xEAnkx3Xs6mt |
|---|
| | | driver-class-name: com.mysql.cj.jdbc.Driver |
|---|
| | | type: com.zaxxer.hikari.HikariDataSource |
|---|
| | | hikari: |
|---|
| | | minimum-idle: 0 |
|---|
| | | maximum-pool-size: 20 |
|---|
| | | idle-timeout: 25000 |
|---|
| | | minimum-idle: 10 # 最小空闲连接数，建议与max-pool-size差距不要太大（避免频繁创建/销毁连接） |
|---|
| | | maximum-pool-size: 100 # 提高最大连接数（根据数据库能承受的并发连接数调整，需与DBA确认） |
|---|
| | | idle-timeout: 60000 # 空闲连接超时时间（1分钟），超过后释放 |
|---|
| | | auto-commit: true |
|---|
| | | connection-test-query: SELECT 1 |
|---|
| | | max-lifetime: 1800000 # 连接最大存活时间（30分钟），避免长期占用导致的僵死连接 |
|---|
| | | connection-timeout: 30000 # 延长连接获取超时时间（30秒，避免因短暂峰值误报） |
|---|
| | | connection-test-query: SELECT 1 # 连接校验SQL（检测连接是否有效，MySQL示例，其他数据库需调整） |
|---|
| | | validation-timeout: 5000 # 连接校验超时时间（5秒） |
|---|
| | | jpa: |
|---|
| | | properties: |
|---|
| | | hibernate: |
|---|
| | | jdbc: |
|---|
| | | time_zone: Europe/Paris |
|---|
| | | time_zone: Asia/Tokyo |
|---|
| | | jackson: |
|---|
| | | time-zone: Europe/Paris |
|---|
| | | time-zone: Asia/Tokyo |
|---|
| | | cache: |
|---|
| | | type: redis |
|---|
| | | redis: |
|---|
| | |
|---|
| | | maxIdle: 20 |
|---|
| | | maxTotal: 50 |
|---|
| | | host: 127.0.0.1 |
|---|
| | | port: 6380 |
|---|
| | | port: 6379 |
|---|
