奇数表

SpringBootsharding分库分表使⽤及配置

SpringBootsharding分库分表使⽤及配置

官⽅提供配置⽅式有哪些？

JAVA配置

YAML配置

SpringBoot配置

Spring命名空间配置

⽆论哪种⽅式最后底层都包装成JAVA代码⽅式配置，今天主要以SpringBoot-sharding⾃动状态开始玩！

了解分库分表策略场景

StandardShardingStrategy标准分⽚

1.只⽀持单个字段进⾏分⽚分库，⾃定义必须实现PreciShardingAlgorithm处理=和in分⽚，RangeShardingAlgorithm⾮必需，遇到BETWEENAND分⽚如

果不配置,会全表路由

ComplexShardingStrategy复合分⽚⽀持多分⽚

1.需要实现ComplexKeysShardingAlgorithm接⼝，⽀持in、=、和BETWEENAND场景

InlineShardingStrategy表达式分⽚只⽀持单⽚

表达式分⽚策略。使⽤Groovy的Inline表达式

HintShardingStrategyHint分⽚

1.需要实现HintShardingAlgorithm接⼝⾃定义逻辑分⽚

NoneShardingStrategy不分⽚

配置数据源

1.数据源Mysql配置主从同步，所以配置时加了读写分离数据源配置。

spring:

application:

name:sharding-mysql

shardingsphere:

datasource:#数据源配置

##数据库逻辑名称声明

names:u0,u1,u0-slave,u1-slave

u0:

type:DataSource

driver-class-name:#

jdbc-url:jdbc:mysql://0.0.0.0:3306/demo0?uUnicode=true&characterEncoding=UTF-8&rverTimezone=Asia/Shanghai

urname:backup

password:backup

u0-slave:

type:DataSource

driver-class-name:

jdbc-url:jdbc:mysql://0.0.0.0:3307/demo0?uUnicode=true&characterEncoding=UTF-8&rverTimezone=Asia/Shanghai

urname:root

password:root

u1:

type:DataSource

driver-class-name:

jdbc-url:jdbc:mysql://0.0.0.0:3306/demo1?uUnicode=true&characterEncoding=UTF-8&rverTimezone=Asia/Shanghai

urname:backup

password:backup

u1-slave:

type:DataSource

driver-class-name:#

jdbc-url:jdbc:mysql://0.0.0.0:3307/demo1?uUnicode=true&characterEncoding=UTF-8&rverTimezone=Asia/Shanghai

urname:root

password:root

配置读写分离（项⽬不需要可忽略）

⚠