1. # sharding-jdbc 水平分库分表策略
    2. # 配置数据源，给数据源起别名
    3. # 水平分库需要配置多个数据库
    4. spring.shardingsphere.datasource.names=m1,f1,f2,f3,f4,f5
    5. spring.shardingsphere.sharding.binding-tables=flight_record
    7. # 一个实体类对应两张表，覆盖
    8. spring.main.allow-bean-definition-overriding=true
    10. ## 配置第一个数据源的具体内容，包含连接池，驱动，地址，用户名，密码 主数据源
    11. spring.shardingsphere.datasource.m1.type=com.alibaba.druid.pool.DruidDataSource
    12. spring.shardingsphere.datasource.m1.driver-class-name=com.mysql.cj.jdbc.Driver
    13. spring.shardingsphere.datasource.m1.url=jdbc:mysql://基础库:3306/库名?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
    14. spring.shardingsphere.datasource.m1.username=root
    15. spring.shardingsphere.datasource.m1.password=123456
    17. # 配置第二个数据源的具体内容，包含连接池，驱动，地址，用户名，密码
    18. spring.shardingsphere.datasource.f1.type=com.alibaba.druid.pool.DruidDataSource
    19. spring.shardingsphere.datasource.f1.driver-class-name=com.mysql.cj.jdbc.Driver
    20. spring.shardingsphere.datasource.f1.url=jdbc:mysql://数据库地址:3306/库名?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
    21. spring.shardingsphere.datasource.f1.username=root
    22. spring.shardingsphere.datasource.f1.password=123456
    24. # 配置第三个数据源的具体内容，包含连接池，驱动，地址，用户名，密码
    25. spring.shardingsphere.datasource.f2.type=com.alibaba.druid.pool.DruidDataSource
    26. spring.shardingsphere.datasource.f2.driver-class-name=com.mysql.cj.jdbc.Driver
    27. spring.shardingsphere.datasource.f2.url=jdbc:mysql://数据库地址:3306/库名?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
    28. spring.shardingsphere.datasource.f2.username=root
    29. spring.shardingsphere.datasource.f2.password=123456
    31. # 配置第三个数据源的具体内容，包含连接池，驱动，地址，用户名，密码
    32. spring.shardingsphere.datasource.f3.type=com.alibaba.druid.pool.DruidDataSource
    33. spring.shardingsphere.datasource.f3.driver-class-name=com.mysql.cj.jdbc.Driver
    34. spring.shardingsphere.datasource.f3.url=jdbc:mysql://数据库地址:3306/库名?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
    35. spring.shardingsphere.datasource.f3.username=root
    36. spring.shardingsphere.datasource.f3.password=123456
    38. # 配置第四个数据源的具体内容，包含连接池，驱动，地址，用户名，密码
    39. spring.shardingsphere.datasource.f4.type=com.alibaba.druid.pool.DruidDataSource
    40. spring.shardingsphere.datasource.f4.driver-class-name=com.mysql.cj.jdbc.Driver
    41. spring.shardingsphere.datasource.f4.url=jdbc:mysql://数据库地址:3306/库名?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
    42. spring.shardingsphere.datasource.f4.username=root
    43. spring.shardingsphere.datasource.f4.password=123456
    45. # 配置第五个数据源的具体内容，包含连接池，驱动，地址，用户名，密码
    46. spring.shardingsphere.datasource.f5.type=com.alibaba.druid.pool.DruidDataSource
    47. spring.shardingsphere.datasource.f5.driver-class-name=com.mysql.cj.jdbc.Driver
    48. spring.shardingsphere.datasource.f5.url=jdbc:mysql://数据库地址:3306/库名?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
    49. spring.shardingsphere.datasource.f5.username=root
    50. spring.shardingsphere.datasource.f5.password=123456
    53. # 指定数据库分布的情况和数据表分布的情况
    54. # m1 m2   flight_record  flight_record
    55. spring.shardingsphere.sharding.tables.flight_record.actual-data-nodes=f$->{1..5}.flight_record
    57. # 指定 flight_record 表里面主键 id 的生成策略 SNOWFLAKE
    58. spring.shardingsphere.sharding.tables.flight_record.key-generator.column=id
    59. spring.shardingsphere.sharding.tables.flight_record.key-generator.type=SNOWFLAKE
    61. # 指定分库策略    约定 analyse_id 值偶数添加到 m1 库，如果 tenant_id 是奇数添加到 m2 库
    62. # 默认写法（所有的表的tenant_id）
    63. spring.shardingsphere.sharding.tables.flight_record.database-strategy.inline.sharding-column=analyse_id
    64. spring.shardingsphere.sharding.tables.flight_record.database-strategy.inline.algorithm-expression=f$->{analyse_id % 5 + 1}
    66. #default-data-source-name: m1 #对于其他业务表设置默认数据源
    67. spring.shardingsphere.sharding.default-data-source-name=m1
    69. # 打开 sql 输出日志
    70. spring.shardingsphere.props.sql.show=true