turbohl/mark-shell

mark-shell

java-shell-sql

##hikari

全部数据源名称

sharding.jdbc.datasource.names=ds-master,ds-slave-0

主写数据源配置，使用阿里druid

sharding.jdbc.datasource.ds-master.type=com.zaxxer.hikari.HikariDataSource sharding.jdbc.datasource.ds-master.driverClassName=com.mysql.jdbc.Driver sharding.jdbc.datasource.ds-master.jdbcUrl=jdbc:mysql://bj-cdb-ihnudix4.sql.tencentcdb.com:61704/mark_dev?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true sharding.jdbc.datasource.ds-master.username=zhishi_dev sharding.jdbc.datasource.ds-master.password=Zhishiquan123$ sharding.jdbc.datasource.ds-master.initial-size=1 sharding.jdbc.datasource.ds-master.min-idle=1 sharding.jdbc.datasource.ds-master.max-active=20 sharding.jdbc.datasource.ds-master.max-wait=60000 sharding.jdbc.datasource.ds-master.time-between-eviction-runs-millis=60000 sharding.jdbc.datasource.ds-master.min-evictable-idle-time-millis=300000 sharding.jdbc.datasource.ds-master.validation-query=SELECT 'x' sharding.jdbc.datasource.ds-master.test-while-idle=true sharding.jdbc.datasource.ds-master.test-on-borrow=false sharding.jdbc.datasource.ds-master.test-on-return=false sharding.jdbc.datasource.ds-master.pool-prepared-statements=true sharding.jdbc.datasource.ds-master.max-pool-prepared-statement-per-connection-size=20 sharding.jdbc.datasource.ds-master.filters=stat,wall,log4j

从读数据源

sharding.jdbc.datasource.ds-slave-0.type=com.zaxxer.hikari.HikariDataSource sharding.jdbc.datasource.ds-slave-0.driverClassName=com.mysql.jdbc.Driver sharding.jdbc.datasource.ds-slave-0.jdbcUrl=jdbc:mysql://bj-cdb-ihnudix4.sql.tencentcdb.com:61704/mark_dev?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true sharding.jdbc.datasource.ds-slave-0.username=zhishi_dev sharding.jdbc.datasource.ds-slave-0.password=Zhishiquan123$ sharding.jdbc.datasource.ds-slave-0.initial-size=1 sharding.jdbc.datasource.ds-slave-0.min-idle=1 sharding.jdbc.datasource.ds-slave-0.max-active=20 sharding.jdbc.datasource.ds-slave-0.max-wait=60000 sharding.jdbc.datasource.ds-slave-0.time-between-eviction-runs-millis=60000 sharding.jdbc.datasource.ds-slave-0.min-evictable-idle-time-millis=300000 sharding.jdbc.datasource.ds-slave-0.validation-query=SELECT 'x' sharding.jdbc.datasource.ds-slave-0.test-while-idle=true sharding.jdbc.datasource.ds-slave-0.test-on-borrow=false sharding.jdbc.datasource.ds-slave-0.test-on-return=false sharding.jdbc.datasource.ds-slave-0.pool-prepared-statements=true sharding.jdbc.datasource.ds-slave-0.max-pool-prepared-statement-per-connection-size=20 sharding.jdbc.datasource.ds-slave-0.filters=stat,wall,log4j

读写分离规则

sharding.jdbc.config.sharding.master-slave-rules.ds_ms.master-data-source-name=ds-master sharding.jdbc.config.sharding.master-slave-rules.ds_ms.slave-data-source-names=ds-slave-0 spring.main.allow-bean-definition-overriding=true

druid

全部数据源名称

sharding.jdbc.datasource.names=ds-master,ds-slave-0

主写数据源配置，使用阿里druid

sharding.jdbc.datasource.ds-master.type=com.alibaba.druid.pool.DruidDataSource sharding.jdbc.datasource.ds-master.driverClassName=com.mysql.cj.jdbc.Driver sharding.jdbc.datasource.ds-master.url=jdbc:mysql://bj-cdb-gnavayr0.sql.tencentcdb.com:62975/common_dev?useUnicode=true&characterEncoding=utf8 sharding.jdbc.datasource.ds-master.username=dev sharding.jdbc.datasource.ds-master.password=zhihuo1234%^&* sharding.jdbc.datasource.ds-master.initial-size=1 sharding.jdbc.datasource.ds-master.min-idle=1 sharding.jdbc.datasource.ds-master.max-active=20 sharding.jdbc.datasource.ds-master.max-wait=60000 sharding.jdbc.datasource.ds-master.time-between-eviction-runs-millis=60000 sharding.jdbc.datasource.ds-master.min-evictable-idle-time-millis=300000 sharding.jdbc.datasource.ds-master.validation-query=SELECT 'x' sharding.jdbc.datasource.ds-master.test-while-idle=true sharding.jdbc.datasource.ds-master.test-on-borrow=false sharding.jdbc.datasource.ds-master.test-on-return=false sharding.jdbc.datasource.ds-master.pool-prepared-statements=true sharding.jdbc.datasource.ds-master.max-pool-prepared-statement-per-connection-size=20 sharding.jdbc.datasource.ds-master.filters=stat,wall,log4j

从读数据源

sharding.jdbc.datasource.ds-slave-0.type=com.alibaba.druid.pool.DruidDataSource sharding.jdbc.datasource.ds-slave-0.driverClassName=com.mysql.cj.jdbc.Driver sharding.jdbc.datasource.ds-slave-0.url=jdbc:mysql://bj-cdb-gnavayr0.sql.tencentcdb.com:62975/common_dev?useUnicode=true&characterEncoding=utf8 sharding.jdbc.datasource.ds-slave-0.username=dev sharding.jdbc.datasource.ds-slave-0.password=zhihuo1234%^&* sharding.jdbc.datasource.ds-slave-0.initial-size=1 sharding.jdbc.datasource.ds-slave-0.min-idle=1 sharding.jdbc.datasource.ds-slave-0.max-active=20 sharding.jdbc.datasource.ds-slave-0.max-wait=60000 sharding.jdbc.datasource.ds-slave-0.time-between-eviction-runs-millis=60000 sharding.jdbc.datasource.ds-slave-0.min-evictable-idle-time-millis=300000 sharding.jdbc.datasource.ds-slave-0.validation-query=SELECT 'x' sharding.jdbc.datasource.ds-slave-0.test-while-idle=true sharding.jdbc.datasource.ds-slave-0.test-on-borrow=false sharding.jdbc.datasource.ds-slave-0.test-on-return=false sharding.jdbc.datasource.ds-slave-0.pool-prepared-statements=true sharding.jdbc.datasource.ds-slave-0.max-pool-prepared-statement-per-connection-size=20 sharding.jdbc.datasource.ds-slave-0.filters=stat,wall,log4j

读写分离规则

sharding.jdbc.config.sharding.master-slave-rules.ds_ms.master-data-source-name=ds-master sharding.jdbc.config.sharding.master-slave-rules.ds_ms.slave-data-source-names=ds-slave-0

spring.main.allow-bean-definition-overriding=true

io.shardingsphere sharding-jdbc-spring-boot-starter 3.0.0 org.springframework spring-jdbc com.alibaba druid-spring-boot-starter 1.1.10