您好:我现在需要通过shardingsphere-jdbc-core-spring-boot-starter:5.1.1实现读写分离,但是我遇到的问题如下: 场景介绍: 现在项目有两台Mysql数据库,数据库关系为主备关系,每台数据库包含了多个逻辑库,为了缓解主库的压力,需要将部分查询负载到备库,因此选择使用shardingsphere-jdbc的读写分离功能。 问题: 由于我的mysql包含多个逻辑库: ynemos_online、ynemos_test、ynemos_demo,在使用mybatis-plus查询时报错: org.apache.shardingsphere.infra.exception. Schema 'ynemos_online' doesn't exist. org.apache.shardingsphere.infra.exception. Schema 'ynemos_test' doesn't exist. 该问题需如何解决
mybatis-plus的Tablename 如下: 我的配置如下(数据源链接未指定逻辑库): # Shardingsphere配置 spring.datasource.driver-class-name = com.mysql.cj.jdbc.Driver spring.shardingsphere.datasource.names = master,slave spring.shardingsphere.mode.type = Memory # 主库数据源配置 spring.shardingsphere.datasource.master.type = com.zaxxer.hikari.HikariDataSource spring.shardingsphere.datasource.master.driver-class-name = com.mysql.jdbc.Driver spring.shardingsphere.datasource.master.jdbc-url = jdbc:mysql://address=(protocol=tcp)(host=10.173.101.245)(port=22306)?allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true spring.shardingsphere.datasource.master.username = root spring.shardingsphere.datasource.master.password = root # 从库数据源配置 spring.shardingsphere.datasource.slave.type = com.zaxxer.hikari.HikariDataSource spring.shardingsphere.datasource.slave.driver-class-name = com.mysql.jdbc.Driver spring.shardingsphere.datasource.slave.jdbc-url = jdbc:mysql://address=(protocol=tcp)(host=10.173.101.244)(port=22306)?allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true spring.shardingsphere.datasource.slave.username = root spring.shardingsphere.datasource.slave.password = root spring.shardingsphere.enabled = true spring.shardingsphere.rules.readwrite-splitting.data-sources.master-slave.type = Static spring.shardingsphere.rules.readwrite-splitting.data-sources.master-slave.props.auto-aware-data-source-name = master # 写数据源名称 spring.shardingsphere.rules.readwrite-splitting.data-sources.master-slave.props.write-data-source-name = master # 读数据源名称,多个从数据源用逗号分隔 spring.shardingsphere.rules.readwrite-splitting.data-sources.master-slave.props.read-data-source-names = slave # 数据库发现逻辑数据源名称 spring.shardingsphere.rules.readwrite-splitting.data-sources.master-slave.dynamic-strategy.write-data-source-query-enabled = true spring.shardingsphere.props.sql-show = true chenj...@ultrapower.com.cn