shardingJDBC分表

发布时间 2023-07-14 09:21:48作者: Gowell
spring: 
 shardingsphere:
    datasource:
      names: ds-0
      ds-0:
        connectionTimeout: 500000 #连接超时时间
        type: com.zaxxer.hikari.HikariDataSource
        jdbcUrl: 
        username: 
        password:
        driver-class-name: com.mysql.cj.jdbc.Driver
    props:
      sql-show: true
    sharding:
    rules:
      sharding:
        tables:
          tm_bus_passenger_his:
       actualDataNodes: ds-0.tm_bus_passenger_his_$->{com.tiamaes.cloud.tmpass.config.ActualDataNodesInit.getDayActualDataNodes()}
            table-strategy:
              standard:
                sharding-algorithm-name: timeDayTableShardingAlgorithm
                sharding-column: create_time

以上是yml配置