Hi English discussion is required here. Please translate the question.
Sheng Wu Apache Skywalking, ShardingSphere, Zipkin > 在 2019年6月20日，下午12:16，余杰 <[email protected]> 写道： > > 现在系统1个数据源master，连接另一个系统的32个库（iss）。 > 一个业务逻辑中，先查询master、31个库（iss），再插入master。 > 查询可以找到数据源，但是插入找不到数据源。 > 我这配置有问题？官网文档没有这种例子。 > > > sharding.jdbc.datasource.names = > master0,wms0,iss0,iss1,iss2,iss3,iss4,iss5,iss6,iss7,iss8,iss9,iss10,iss11,iss12,iss13,iss14,iss15,iss16,iss17,iss18,iss19,iss20,iss21,iss22,iss23,iss24,iss25,iss26,iss27,iss28,iss29,iss30,iss31 > sharding.jdbc.datasource.master0.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.master0.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.master0.url = > jdbc:mysql://10.79.1.15:33007/fas?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.master0.username = root > sharding.jdbc.datasource.master0.password = 123456 > > > #sharding.default-data-source-name = master0 > > > # 最大连接池数量 > sharding.jdbc.datasource.master0.maxActive = 200 > # 初始化时建立物理连接的个数 > sharding.jdbc.datasource.master0.initialSize = 100 > # 最小连接池数量 > sharding.jdbc.datasource.master0.minIdle = 100 > # 获取连接时最大等待时间，单位毫秒 > sharding.jdbc.datasource.master0.maxWait = 60000 > # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 > sharding.jdbc.datasource.master0.timeBetweenEvictionRunsMillis = 60000 > # 连接保持空闲而不被驱逐的最小时间 > sharding.jdbc.datasource.master0.minEvictableIdleTimeMillis = 300000 > # 用来检测连接是否有效的sql，要求是一个查询语句 > sharding.jdbc.datasource.master0.validationQuery = SELECT 1 FROM DUAL > # > 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效。 > sharding.jdbc.datasource.master0.testWhileIdle = true > # 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 > sharding.jdbc.datasource.master0.testOnBorrow = false > # 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 > sharding.jdbc.datasource.master0.testOnReturn = false > # > 是否缓存preparedStatement，也就是PSCache。PSCache对支持游标的数据库性能提升巨大，比如说oracle。在mysql下建议关闭。 > sharding.jdbc.datasource.master0.poolPreparedStatements = false > # 要启用PSCache，必须配置大于0，当大于0时，poolPreparedStatements自动触发修改为true。 > sharding.jdbc.datasource.master0.maxPoolPreparedStatementPerConnectionSize = > 50 > > > ## wms > sharding.jdbc.datasource.wms0.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.wms0.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.wms0.url = > jdbc:mysql://10.4.6.92:3306/newerp?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.wms0.username = wms_select > sharding.jdbc.datasource.wms0.password = oserfYh5 > > > > > ## iss > sharding.jdbc.datasource.iss0.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss0.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss0.url = > jdbc:mysql://10.4.4.43:3307/iss_0?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss0.username = iss_select > sharding.jdbc.datasource.iss0.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss1.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss1.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss1.url = > jdbc:mysql://10.4.4.43:3307/iss_1?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss1.username = iss_select > sharding.jdbc.datasource.iss1.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss2.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss2.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss2.url = > jdbc:mysql://10.4.4.43:3307/iss_2?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss2.username = iss_select > sharding.jdbc.datasource.iss2.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss3.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss3.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss3.url = > jdbc:mysql://10.4.4.43:3307/iss_3?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss3.username = iss_select > sharding.jdbc.datasource.iss3.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss4.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss4.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss4.url = > jdbc:mysql://10.4.4.43:3307/iss_4?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss4.username = iss_select > sharding.jdbc.datasource.iss4.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss5.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss5.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss5.url = > jdbc:mysql://10.4.4.43:3307/iss_5?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss5.username = iss_select > sharding.jdbc.datasource.iss5.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss6.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss6.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss6.url = > jdbc:mysql://10.4.4.43:3307/iss_6?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss6.username = iss_select > sharding.jdbc.datasource.iss6.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss7.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss7.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss7.url = > jdbc:mysql://10.4.4.43:3307/iss_7?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss7.username = iss_select > sharding.jdbc.datasource.iss7.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss8.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss8.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss8.url = > jdbc:mysql://10.4.4.43:3307/iss_8?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss8.username = iss_select > sharding.jdbc.datasource.iss8.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss9.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss9.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss9.url = > jdbc:mysql://10.4.4.43:3307/iss_9?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss9.username = iss_select > sharding.jdbc.datasource.iss9.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss10.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss10.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss10.url = > jdbc:mysql://10.4.4.43:3307/iss_10?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss10.username = iss_select > sharding.jdbc.datasource.iss10.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss11.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss11.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss11.url = > jdbc:mysql://10.4.4.43:3307/iss_11?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss11.username = iss_select > sharding.jdbc.datasource.iss11.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss12.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss12.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss12.url = > jdbc:mysql://10.4.4.43:3307/iss_12?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss12.username = iss_select > sharding.jdbc.datasource.iss12.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss13.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss13.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss13.url = > jdbc:mysql://10.4.4.43:3307/iss_13?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss13.username = iss_select > sharding.jdbc.datasource.iss13.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss14.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss14.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss14.url = > jdbc:mysql://10.4.4.43:3307/iss_14?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss14.username = iss_select > sharding.jdbc.datasource.iss14.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss15.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss15.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss15.url = > jdbc:mysql://10.4.4.43:3307/iss_15?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss15.username = iss_select > sharding.jdbc.datasource.iss15.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss16.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss16.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss16.url = > jdbc:mysql://10.4.4.43:3307/iss_16?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss16.username = iss_select > sharding.jdbc.datasource.iss16.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss17.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss17.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss17.url = > jdbc:mysql://10.4.4.43:3307/iss_17?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss17.username = iss_select > sharding.jdbc.datasource.iss17.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss18.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss18.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss18.url = > jdbc:mysql://10.4.4.43:3307/iss_18?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss18.username = iss_select > sharding.jdbc.datasource.iss18.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss19.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss19.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss19.url = > jdbc:mysql://10.4.4.43:3307/iss_19?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss19.username = iss_select > sharding.jdbc.datasource.iss19.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss20.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss20.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss20.url = > jdbc:mysql://10.4.4.43:3307/iss_20?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss20.username = iss_select > sharding.jdbc.datasource.iss20.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss21.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss21.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss21.url = > jdbc:mysql://10.4.4.43:3307/iss_21?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss21.username = iss_select > sharding.jdbc.datasource.iss21.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss22.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss22.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss22.url = > jdbc:mysql://10.4.4.43:3307/iss_22?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss22.username = iss_select > sharding.jdbc.datasource.iss22.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss23.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss23.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss23.url = > jdbc:mysql://10.4.4.43:3307/iss_23?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss23.username = iss_select > sharding.jdbc.datasource.iss23.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss24.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss24.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss24.url = > jdbc:mysql://10.4.4.43:3307/iss_24?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss24.username = iss_select > sharding.jdbc.datasource.iss24.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss25.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss25.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss25.url = > jdbc:mysql://10.4.4.43:3307/iss_25?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss25.username = iss_select > sharding.jdbc.datasource.iss25.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss26.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss26.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss26.url = > jdbc:mysql://10.4.4.43:3307/iss_26?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss26.username = iss_select > sharding.jdbc.datasource.iss26.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss27.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss27.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss27.url = > jdbc:mysql://10.4.4.43:3307/iss_27?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss27.username = iss_select > sharding.jdbc.datasource.iss27.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss28.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss28.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss28.url = > jdbc:mysql://10.4.4.43:3307/iss_28?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss28.username = iss_select > sharding.jdbc.datasource.iss28.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss29.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss29.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss29.url = > jdbc:mysql://10.4.4.43:3307/iss_29?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss29.username = iss_select > sharding.jdbc.datasource.iss29.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss30.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss30.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss30.url = > jdbc:mysql://10.4.4.43:3307/iss_30?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss30.username = iss_select > sharding.jdbc.datasource.iss30.password = BVoyMWAdpCM= > > > sharding.jdbc.datasource.iss31.type = com.alibaba.druid.pool.DruidDataSource > sharding.jdbc.datasource.iss31.driver-class-name = com.mysql.jdbc.Driver > sharding.jdbc.datasource.iss31.url = > jdbc:mysql://10.4.4.43:3307/iss_31?useUnicode=true&characterEncoding=utf-8&useSSL=false > sharding.jdbc.datasource.iss31.username = iss_select > sharding.jdbc.datasource.iss31.password = BVoyMWAdpCM= > > > # iss根据sku分库 > sharding.jdbc.config.sharding.tables.stock_info.actual-data-nodes = > iss$->{0..31}.stock_info > sharding.jdbc.config.sharding.tables.stock_info.database-strategy.standard.sharding-column > = sku > sharding.jdbc.config.sharding.tables.stock_info.database-strategy.standard.precise-algorithm-class-name > = com.hqyg.fas.common.sharding.third.IssSkuPreciseShardingAlgorithm > > > #spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column > = id > #spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression > = master0 > > > > > # cb_stock_batch_inout 根据sku分表 > sharding.jdbc.config.sharding.tables.cb_stock_batch_inout.actual-data-nodes = > master0.cb_stock_batch_inout_$->{0..127} > sharding.jdbc.config.sharding.tables.cb_stock_batch_inout.table-strategy.standard.sharding-column > = sku > sharding.jdbc.config.sharding.tables.cb_stock_batch_inout.table-strategy.standard.precise-algorithm-class-name > = com.hqyg.fas.common.sharding.SkuPreciseShardingAlgorithm > # cb_stock_batch_inout_time 根据operation_time按月分表 > sharding.jdbc.config.sharding.tables.cb_stock_batch_inout_time.actual-data-nodes > = > master0.cb_stock_batch_inout_time_$->{2019}$->{['05','06','07','08','09','10','11','12']} > sharding.jdbc.config.sharding.tables.cb_stock_batch_inout_time.table-strategy.standard.sharding-column > = operation_time > sharding.jdbc.config.sharding.tables.cb_stock_batch_inout_time.table-strategy.standard.precise-algorithm-class-name > = com.hqyg.fas.common.sharding.DateTimePreciseShardingAlgorithm > # cb_track 根据batch_no分表 > sharding.jdbc.config.sharding.tables.cb_track.actual-data-nodes = > master0.cb_track_$->{0..127} > sharding.jdbc.config.sharding.tables.cb_track.table-strategy.standard.sharding-column > = batch_no > sharding.jdbc.config.sharding.tables.cb_track.table-strategy.standard.precise-algorithm-class-name > = com.hqyg.fas.common.sharding.BatchNOPreciseShardingAlgorithm > # cb_psi 根据ym分表 > sharding.jdbc.config.sharding.tables.cb_psi.actual-data-nodes = > master0.cb_psi_$->{2019}$->{['05','06','07','08','09','10','11','12']} > sharding.jdbc.config.sharding.tables.cb_psi.table-strategy.standard.sharding-column > = ym > sharding.jdbc.config.sharding.tables.cb_psi.table-strategy.standard.precise-algorithm-class-name > = com.hqyg.fas.common.sharding.YMPreciseShardingAlgorithm > # cb_psi_detail 根据ym分表 > sharding.jdbc.config.sharding.tables.cb_psi_detail.actual-data-nodes = > master0.cb_psi_detail_$->{2019}$->{['05','06','07','08','09','10','11','12']} > sharding.jdbc.config.sharding.tables.cb_psi_detail.table-strategy.standard.sharding-column > = ym > sharding.jdbc.config.sharding.tables.cb_psi_detail.table-strategy.standard.precise-algorithm-class-name > = com.hqyg.fas.common.sharding.YMPreciseShardingAlgorithm > #是否开启SQL显示，默认值: false > sharding.jdbc.config.props.sql.show = false > > > #sharding.jdbc.config.sharding.master-slave-rules.master0.master-data-source-name > = master0 > #sharding.jdbc.config.sharding.master-slave-rules.master0.slave-data-source-names > = > iss0,iss1,iss2,iss3,iss4,iss5,iss6,iss7,iss8,iss9,iss10,iss11,iss12,iss13,iss14,iss15,iss16,iss17,iss18,iss19,iss20,iss21,iss22,iss23,iss24,iss25,iss26,iss27,iss28,iss29,iss30,iss31 > > > #mybatis config > mybatis.type-aliases-package = com.hqyg.fas.job.**.entity > mybatis.mapper-locations = classpath*:mybatis/mapper/**/*Mapper.xml > pagehelper.helperDialect = mysql > pagehelper.reasonable = false > pagehelper.supportMethodsArguments = true > pagehelper.params = count=countSql > > > > > > >
