Shardingjdbc配置介绍#xff08;版本#xff1a;5.3.2#xff09;…

说明如果实现了docker部署mysql并完成主从复制的话再继续本篇文章主要说明springboot配置实现Shardingjdbc进行读写分离操作。

spring:datasource:driver-class-name:

org.apache.shardingsphere.driver.ShardingSphereDriverurl:

jdbc:shardingsphere:classpath:qiyu-db-sharding.yamlhikari:pool-name:

15idle-timeout:

shardingjdbc读写分离配置qiyu-db-sharding.yaml

com.zaxxer.hikari.HikariDataSourcedriver-class-name:

com.mysql.cj.jdbc.DriverjdbcUrl:

jdbc:mysql://192.168.1.128:8808/qiyu_live_user?useUnicodetruecharacterEncodingutf8username:

rootpassword:

com.zaxxer.hikari.HikariDataSourcedriver-class-name:

com.mysql.cj.jdbc.DriverjdbcUrl:

jdbc:mysql://192.168.1.128:8809/qiyu_live_user?useUnicodetruecharacterEncodingutf8username:

rootpassword:

!READWRITE_SPLITTINGdataSources:#读写分离配置user_ds:staticStrategy:writeDataSourceName:

user_masterreadDataSourceNames:-

user_slave0-

!SHARDINGtables:t_user:actualDataNodes:

user_ds.t_user_${(0..04).collect(){it.toString().padLeft(2,0)}}tableStrategy:standard:#指定用于分表的列名。

shardingColumn:

t_user-inline#定义分表算法shardingAlgorithms:t_user-inline:type:

INLINEprops:#根据user_id对5取模的结果将作为分表的后缀范围为00到04对应五个表并在左侧填充0。

algorithm-expression:

t_user_${(user_id

com.laoyang.provider.config;import

org.slf4j.Logger;

org.springframework.boot.ApplicationRunner;

import

org.springframework.context.annotation.Bean;

import

org.springframework.context.annotation.Configuration;import

import

ShardingjdbcDatasourceAutoConnectionconfig

{private

LoggerFactory.getLogger(ShardingjdbcDatasourceAutoConnectionconfig.class);Beanpublic

ApplicationRunner

{},dataSource);//手动触发下连接池的连接创建Connection

connection