CharacterEncodingFilter pattern>/*pattern> JAVAEE 课程系列 ————————————————————————————— 40 更多 Java –大数据 –前端 –python ss> HiddenHttpMethodFilter pattern>/*pattern> contextCo springDispatcherServlet pattern>/pattern> JAVAEE 课程系列 ————————————————————————————— 41 更多 Java

Attributes: Name DataType Description mod int Sharding count logic‐name‐prefix String Prefix pattern of sharding data sources or tables Hash Modulo Sharding Algorithm Type: HASH_MOD Attributes: wer S t r i n g Shard datetime begin bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss da tet ime ‐up per S t r i n g Shard datetime end bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss s har din g‐s eco nds l o n Interval Sharding Algorithm This algorithm actively ignores the time zone information of datetime-pattern. This means that when datetime-lower, datetime-upper and the incoming shard key contain time zone

the log configuration. Procedure 1. Create file conf/logback.xml Customize the logger level and pattern, etc. according to your needs. > It is recommended to make modifications based on the configuration class="ch.qos.logback.core.ConsoleAppender"> <pattern>[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{36} - %msg%npattern> 9.2. ShardingSphere-Proxy 397 Apache ShardingSphere wer S t r i n g Shard datetime begin bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss da tet ime ‐up per S t r i n g Shard datetime end bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss s har din g‐s eco nds l o n

ShardingSphere document Procedure 1. Create file conf/logback.xml Customize the logger level and pattern, etc. according to your needs. > It is recommended to make modifications based on the configuration class="ch.qos.logback.core.ConsoleAppender"> <pattern>[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{36} - %msg%npattern> pattern: yyyy‐MM‐dd HH:mm:ss da tet ime ‐up per S t r i n g Shard datetime end bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss s har din g‐s eco nds l o n

wer S t r i n g Shard datetime begin bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss da tet ime ‐up per S t r i n g Shard datetime end bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss s har din g‐s eco nds l o n a T y p e * Description • D e f a u l t V a l u e * date time ‐pat tern S t r i n g Timestamp pattern of sharding value, must can be trans‐ formed to Java Lo‐ calDateTime. For example: yyyy‐MM‐dd sharding lower boundary, pattern is defined datetime-pattern • da teti me‐u pper (?) S t r i n g Datetime sharding upper boundary, pattern is defined datetime-pattern N o w sha rdin g‐su ffix

wer S t r i n g Shard datetime begin bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss da tet ime ‐up per S t r i n g Shard datetime end bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss s har din g‐s eco nds l o n Interval Sharding Algorithm This algorithm actively ignores the time zone information of datetime-pattern. This means that when datetime-lower, datetime-upper and the incoming shard key contain time zone carry the time zone information of the system and convert it into the string format of datetime-pattern, and then proceed to the next sharding. Type: INTERVAL Attributes: 4.3. Common Configuration

date time‐lower S tring Shard datetime begin boundary, pattern: yyyy‐MM‐dd HH:mm:ss date time‐upper S tring Shard datetime end boundary, pattern: yyyy‐MM‐dd HH:mm:ss shardi ng‐seconds long Max seconds Timestamp pattern of sharding value, must can be transformed to Java LocalDateTime. For example: yyyy‐ MM‐dd HH:mm:ss • da tetime ‐lower S t r i n g Datetime sharding lower boundary, pattern is defined datetime-pattern • da tetime ‐upper (?) S t r i n g Datetime sharding upper boundary, pattern is defined datetime-pattern N o w shard ing‐su ffix‐p at‐ tern S t r i n g Suffix pattern of sharding

date time‐lower S tring Shard datetime begin boundary, pattern: yyyy‐MM‐dd HH:mm:ss date time‐upper S tring Shard datetime end boundary, pattern: yyyy‐MM‐dd HH:mm:ss shardi ng‐seconds long Max seconds Timestamp pattern of sharding value, must can be transformed to Java LocalDateTime. For example: yyyy‐ MM‐dd HH:mm:ss • da tetime ‐lower S t r i n g Datetime sharding lower boundary, pattern is defined datetime-pattern • da tetime ‐upper (?) S t r i n g Datetime sharding upper boundary, pattern is defined datetime-pattern N o w shard ing‐su ffix‐p at‐ tern S t r i n g Suffix pattern of sharding

wer S t r i n g Shard datetime begin bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss da tet ime ‐up per S t r i n g Shard datetime end bound‐ ary, pattern: yyyy‐MM‐dd HH:mm:ss s har din g‐s eco nds l o n Timestamp pattern of sharding value, must can be transformed to Java LocalDateTime. For example: yyyy‐ MM‐dd HH:mm:ss • da tetime ‐lower S t r i n g Datetime sharding lower boundary, pattern is defined datetime-pattern • da tetime ‐upper (?) S t r i n g Datetime sharding upper boundary, pattern is defined datetime-pattern N o w shard ing‐su ffix‐p at‐ tern S t r i n g Suffix pattern of sharding

conf 目录下的 logback.xml 提供的日志配置。 下面将介绍如何自定义日志配置。 操作步骤 1. 新建 conf/logback.xml 根据需求自定义 logger 级别、pattern 等。> 建议在配置示例的基础上进行修改 2. 查看日志 ShardingSphere‐Proxy 启动后，日志将输出到 logs 目录下，选择目标日志文件进行查看。 配置示例 <pattern>[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{36} - %msg%npattern> pattern 的 时 区 信 息。 这 意 味 着 当 datetime-lower, datetime-upper 和传入的分片键含有时区信息时，不会因为时区不一致而发生时区转换。当 传入的分片键为 java.time.Instant 时存在特例处理，其会携带上系统的时区信息后转化为 datetime-pattern 的字符串格式，再进行下一步分片。