oidc:
|
enabled: true
|
clientId: xp-robotaxi
|
clientSecret: SlfCibLrXbfXYBMx
|
grant_type: client_credentials
|
url: https://ldap.deploy-test.xiaopeng.com/oidc/token
|
stsTokenUrl: https://authhub.deploy-test.xiaopeng.com/api/sts/get_token
|
stsPolicyName: XpRobotaxiSTAGINGOss
|
aliOssUrl: https://oss-cn-hangzhou.aliyuncs.com
|
aliOssRegin: cn-hangzhou
|
aliOssBucket: xp-robotaxi
|
aliOssObjectPrefix: staging/
|
aliOssUrlPublic: https://oss-cn-hangzhou.aliyuncs.com
|
fileWaterMarkUrl:
|
|
spring:
|
config:
|
activate:
|
on-profile: local
|
autoconfigure:
|
exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
|
token:
|
secret: iymGhx1XkAAHrex2Zf4ASbiD9P2ksTam
|
|
# 以下为本地数据库/中间件配置，后续迁移至 Nacos
|
redis:
|
database: 99
|
host: r-bp1ip8die60uuo3ovypd.redis.rds.aliyuncs.com
|
password: syAktm2x9uDusoF_
|
port: 6379
|
data:
|
mongodb:
|
host: dds-bp1f4a38f3cccad4-pub.mongodb.rds.aliyuncs.com
|
port: 3717
|
database: xp_robotaxi
|
username: xp_robotaxi
|
password: hDXSBe_hs0d5KxUf
|
shardingsphere:
|
datasource:
|
names: xp0
|
xp0:
|
type: com.alibaba.druid.pool.DruidDataSource
|
driver-class-name: com.mysql.cj.jdbc.Driver
|
url: jdbc:mysql://pc-bp1o444934f546768po.rwlb.rds.aliyuncs.com:3306/xp_robotaxi?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
|
username: xp_robotaxi
|
password: PrcZ3f_Hjp0uTcaX
|
druid:
|
# 连接池初始化时创建的连接数。
|
# 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。
|
initial-size: 10
|
# 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。
|
min-idle: 10
|
# 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。
|
max-active: 100
|
# 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。
|
max-wait: 60000
|
# 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。
|
time-between-eviction-runs-millis: 60000
|
# 连接在被清理前的最小空闲时间。单位为毫秒。
|
min-evictable-idle-time-millis: 300000
|
# 用于验证连接有效性的 SQL 查询语句。
|
validation-query: SELECT 1
|
# 如果为真，则连接空闲时会被定期测试有效性。
|
test-while-idle: true
|
# 如果为真，在获取连接前进行有效性测试。
|
test-on-borrow: false
|
# 如果为真，在归还连接时进行有效性测试。
|
test-on-return: false
|
# 是否开启 PreparedStatement 缓存。
|
pool-prepared-statements: true
|
# 单个连接上缓存的 PreparedStatement 最大数量。
|
max-pool-prepared-statement-per-connection-size: 20
|
# 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。
|
filters: stat,wall,log4j
|
# 连接属性，例如配置日志级别或慢 SQL 阈值。
|
connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
|
# 是否自动回收超时连接
|
remove-abandoned: true
|
# 超时时间，单位秒
|
remove-abandoned-timeout: 1800
|
# 是否记录被遗弃的连接
|
log-abandoned: true
|
# StatViewServlet配置，访问监控页面
|
stat-view-servlet:
|
enabled: true
|
url-pattern: /druid/*
|
login-username: admin
|
login-password: admin
|
reset-enable: false
|
# 防火墙配置
|
wall:
|
config:
|
multi-statement-allow: false
|
rules:
|
sharding:
|
tables:
|
xp_charging_record:
|
actual-data-nodes: xp0.xp_charging_record_$->{0..9}
|
table-strategy:
|
standard:
|
sharding-column: vehicle_id
|
sharding-algorithm-name: xp-charging-record-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_clock_in:
|
actual-data-nodes: xp0.xp_clock_in_$->{0..9}
|
table-strategy:
|
standard:
|
sharding-column: app_user_id
|
sharding-algorithm-name: xp-clock-in-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_task:
|
actual-data-nodes: xp0.xp_task_$->{0..19}
|
table-strategy:
|
standard:
|
sharding-column: vehicle_id
|
sharding-algorithm-name: xp-task-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_task_handle_detail:
|
actual-data-nodes: xp0.xp_task_handle_detail_$->{0..19}
|
table-strategy:
|
standard:
|
sharding-column: task_id
|
sharding-algorithm-name: xp-task-handle-detail-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_task_handle_detail_routine:
|
actual-data-nodes: xp0.xp_task_handle_detail_routine_$->{0..19}
|
table-strategy:
|
standard:
|
sharding-column: task_id
|
sharding-algorithm-name: xp-task-handle-detail-routine-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_vehicle_detection:
|
actual-data-nodes: xp0.xp_vehicle_detection_$->{0..9}
|
table-strategy:
|
standard:
|
sharding-column: vehicle_id
|
sharding-algorithm-name: xp-vehicle-detection-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_vehicle_preparation:
|
actual-data-nodes: xp0.xp_vehicle_preparation_$->{0..9}
|
table-strategy:
|
standard:
|
sharding-column: vehicle_id
|
sharding-algorithm-name: xp-vehicle-preparation-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_vehicle_repair:
|
actual-data-nodes: xp0.xp_vehicle_repair_$->{0..9}
|
table-strategy:
|
standard:
|
sharding-column: vehicle_id
|
sharding-algorithm-name: xp-vehicle-repair-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_work_order:
|
actual-data-nodes: xp0.xp_work_order_$->{0..9}
|
table-strategy:
|
standard:
|
sharding-column: feedback_user_phone
|
sharding-algorithm-name: xp-work-order-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
xp_work_order_log:
|
actual-data-nodes: xp0.xp_work_order_log_$->{0..19}
|
table-strategy:
|
standard:
|
sharding-column: work_order_id
|
sharding-algorithm-name: xp-work-order-log-inline
|
key-generate-strategy:
|
column: id
|
key-generator-name: snowflake
|
sharding-algorithms:
|
xp-charging-record-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_charging_record_${vehicle_id % 20}
|
xp-clock-in-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_clock_in_${app_user_id % 10}
|
xp-task-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_task_${vehicle_id % 20}
|
xp-task-handle-detail-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_task_handle_detail_${task_id % 20}
|
xp-task-handle-detail-routine-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_task_handle_detail_routine_${task_id % 20}
|
xp-vehicle-detection-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_vehicle_detection_${vehicle_id % 10}
|
xp-vehicle-preparation-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_vehicle_preparation_${vehicle_id % 10}
|
xp-vehicle-repair-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_vehicle_repair_${vehicle_id % 10}
|
xp-work-order-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_work_order_${feedback_user_phone % 10}
|
xp-work-order-log-inline:
|
type: INLINE
|
props:
|
algorithm-expression: xp_work_order_log_${work_order_id % 20}
|
key-generators:
|
snowflake:
|
type: SNOWFLAKE
|
single-table:
|
default-data-source-name: xp0
|
props:
|
sql-show: true
|
sql-simple: true
|
|
seata:
|
enabled: false
|
application-id: ${spring.application.name}
|
tx-service-group: seata_tx_group #此处配置自定义的seata事务分组名称
|
enable-auto-data-source-proxy: false #关闭数据库代理
|
service:
|
vgroup-mapping:
|
seata_tx_group: default
|
data-source-proxy-mode: AT
|
config:
|
type: nacos
|
nacos:
|
# 开发环境
|
server-addr: 192.168.110.80:8848
|
namespace: 88de3938-82f9-4cab-97cf-6173202703e0
|
group: DEFAULT_GROUP
|
data-id: seata-server.properties
|
username: nacos
|
password: nacos
|
# 生产环境
|
# server-addr: 192.168.0.137:8848,192.168.0.123:8848
|
# namespace: c6cf40b5-44e8-43f9-be61-8d10fa830e2a
|
# group: DEFAULT_GROUP
|
# data-id: seata-server.properties
|
# username: nacos
|
# password: nacos
|
# registry:
|
# type: nacos
|
# nacos:
|
# application: seata-server
|
# # 开发环境
|
# server-addr: 192.168.110.80:8848
|
# namespace: 88de3938-82f9-4cab-97cf-6173202703e0
|
# group: DEFAULT_GROUP
|
# username: nacos
|
# password: nacos
|
# # 生产环境
|
# # server-addr: 192.168.0.137:8848,192.168.0.123:8848
|
# # namespace: c6cf40b5-44e8-43f9-be61-8d10fa830e2a
|
# # group: DEFAULT_GROUP
|
# # username: nacos
|
# # password: nacos
|
# cloud:
|
# nacos:
|
# discovery:
|
# # 开发环境
|
# server-addr: 192.168.110.80:8848
|
# namespace: 88de3938-82f9-4cab-97cf-6173202703e0
|
# group: DEFAULT_GROUP
|
# application: seata-server #Nacos 中 Seata 名称
|
# username: nacos
|
# password: nacos
|
# # 生产环境
|
# # server-addr: 192.168.0.137:8848,192.168.0.123:8848
|
# # namespace: c6cf40b5-44e8-43f9-be61-8d10fa830e2a
|
# # group: DEFAULT_GROUP
|
# # application: seata-server #Nacos 中 Seata 名称
|
# # username: nacos
|
# # password: nacos
|
# sentinel:
|
# transport:
|
# dashboard: 192.168.0.137:8080 # Sentinel控制台地址
|
# eager: true
|
# datasource:
|
# driver-class-name: com.mysql.cj.jdbc.Driver
|
# url: jdbc:mysql://pc-bp1o444934f546768po.rwlb.rds.aliyuncs.com:3306/xp_robotaxi?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
|
# username: xp_robotaxi
|
# password: PrcZ3f_Hjp0uTcaX
|
