liujie
2026-06-09 c96fbe6b0aeb413a17c429133ee6d81d138144b9
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
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_rt_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: xp_rt_order
        password: JLZtAI_BL4Lv5mbE
        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
          validation-query: SELECT 1
          test-while-idle: true
          test-on-borrow: false
          test-on-return: false
          pool-prepared-statements: true
          max-pool-prepared-statement-per-connection-size: 20
          filters: stat,wall,log4j
          connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
          remove-abandoned: true
          remove-abandoned-timeout: 1800
          log-abandoned: true
          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_order:
            actual-data-nodes: xp0.xp_order_${0..19}
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp-order-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_cancel:
            actual-data-nodes: xp0.xp_order_cancel_${0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp-order-cancel-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_detail:
            actual-data-nodes: xp0.xp_order_detail_${0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp-order-detail-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_evaluate:
            actual-data-nodes: xp0.xp_order_evaluate_${0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp-order-evaluate-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_payment:
            actual-data-nodes: xp0.xp_order_payment_${0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp-order-payment-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_reassign:
            actual-data-nodes: xp0.xp_order_reassign_${0..9}
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp-order-reassign-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          xp-order-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_${app_user_id % 20}
          xp-order-cancel-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_cancel_${order_id % 20}
          xp-order-detail-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_detail_${order_id % 20}
          xp-order-evaluate-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_evaluate_${order_id % 20}
          xp-order-payment-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_payment_${order_id % 20}
          xp-order-reassign-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_reassign_${task_id % 10}
        key-generators:
          snowflake:
            type: SNOWFLAKE
 
ministry:
  transport:
    company-id: 4401XPQCB67N
    platform: XPQCB67N
    key: gEhROt7lg4DEBanR
    url: https://wycapi.jtj.gz.gov.cn/api/app/common/binapi
    address-code: 440106
    fare-type: AA01
    depart-city-default: 440100
    dest-city-default: 440100
    protocol-version: V2.0
    driver-license-id: 440106199001010011
    driver-phone: 13900139000
    vehicle-cert-no: 穗交运管许可440100000001
    driver-name: 张三
    driver-id-no: 440106199001010011
    driver-cert-no: 穗网约字440100000001
 
map:
  api-key: 66ae577f63898dae3016d599fda57221
  urls:
    route-price: https://tsapi.amap.com/v1/route/price
    route-query: https://tsapi.amap.com/v1/route/query/routeid
    reverse-geocode: https://restapi.amap.com/v3/geocode/regeo
 
holiday:
  api:
    url: https://publicapi.xiaoai.me/holiday/day?date=
      single-table:
        default-data-source-name: xp0
    props:
      sql-show: true
      sql-simple: true
 
seata:
  enabled: false
 
robotaxi:
  appId: xp_robotaxi_api