请问sharding-proxy 只分库 不分表的配置如何配啊,如下两个表,test是分库分表的,配置正常,test_year是只分库不分表的,一直报错
schemaName: sharding_db_new
dataSources:
ds_0:
url: jdbc:mysql://10.1.50.194:3306/testdatabase_2021?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_1:
url: jdbc:mysql://10.1.50.194:3306/testdatabase_2022?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_2:
url: jdbc:mysql://10.1.50.194:3306/testdatabase_2023?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_3:
url: jdbc:mysql://10.1.50.194:3306/testdatabase_2024?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
rules:
- !SHARDING
tables:
test:
actualDataNodes: ds_$->{0..3}.test_$->{1..2}
tableStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: test_inline
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
test_year:
actualDataNodes: ds_$->{0..3}.test_year
tableStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: test_year_inline
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
bindingTables:
- test,test_year
defaultDatabaseStrategy:
standard:
shardingColumn: create_date
shardingAlgorithmName: database_inline
defaultTableStrategy:
none:
shardingAlgorithms:
database_inline:
type: INLINE
props:
algorithm-expression: ds_$->{create_date % 2021}
test_inline:
type: INLINE
props:
algorithm-expression: test_$->{id % 3}
test_year_inline:
type: INLINE
props:
algorithm-expression: test_year
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
表结构是一样的:
create table test_1
(`id` int(11) DEFAULT NULL
,`name` varchar(20) DEFAULT NULL
,`create_date1` varchar(20) DEFAULT NULL
, `create_date` int(11) DEFAULT NULL);
create table test_year
(`id` int(11) DEFAULT NULL
,`name` varchar(20) DEFAULT NULL
,`create_date1` varchar(20) DEFAULT NULL
, `create_date` int(11) DEFAULT NULL);