wavelet123 opened a new issue #10349:
URL: https://github.com/apache/shardingsphere/issues/10349
Hi Team,
We need to migrate one hooundred millions records into 1000 sharding tables.
Could you please advise how to recognize the source table in sharding proxy?
what I want to do is
insert into account_friend_012(sharding table) select * from
source.account_friend (source table)where id=1;
but with following configuration,I can only see the sharding table.please
advise.
dataSources:
ds_0:
url:
jdbc:mysql://1.1.1.1:3307/friends?serverTimezone=GMT%2B2&useSSL=false
username: shardingadmin
password: xxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 180000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
tables:
t_accountfriend:
actualDataNodes: ds_0.accountfriend_${0..999}
tableStrategy:
inline:
shardingColumn: FFirstAccountID
algorithmExpression: accountfriend_$->{FFirstAccountID % 1000}
defaultTableStrategy:
dataSources:
ds_0:
url:
jdbc:mysql://1.1.1.1:3307/friends?serverTimezone=GMT%2B2&useSSL=false
username: shardingadmin
password: xxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 180000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
tables:
t_accountfriend:
actualDataNodes: ds_0.accountfriend_${0..999}
tableStrategy:
inline:
shardingColumn: FFirstAccountID
algorithmExpression: accountfriend_$->{FFirstAccountID % 1000}
defaultTableStrategy:
none:
defaultDataSourceName: ds_0
thanks
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
