You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/05/15 05:12:52 UTC

[GitHub] [shardingsphere] wavelet123 opened a new issue #10349: data migration config

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:
users@infra.apache.org

[GitHub] [shardingsphere] wavelet123 commented on issue #10349: data migration config

Posted by GitBox <gi...@apache.org>.
wavelet123 commented on issue #10349:
URL: https://github.com/apache/shardingsphere/issues/10349#issuecomment-841605710


   I mean how to config to check the other no-sharding tables in one datasource 


-- 
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:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #10349: data migration config

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10349:
URL: https://github.com/apache/shardingsphere/issues/10349#issuecomment-842045156


   Hi  @wavelet123 ,
   
   `Check non-sharding` tables?  Does that mean to show  `non-sharding` tables in  Proxy?
   If you use 5.0.0-alpha, all non-sharding tables will be present by executing `show tables` SQL, even though they do not show up in your yaml configuration. 


-- 
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:
users@infra.apache.org

[GitHub] [shardingsphere] wavelet123 edited a comment on issue #10349: data migration config

Posted by GitBox <gi...@apache.org>.
wavelet123 edited a comment on issue #10349:
URL: https://github.com/apache/shardingsphere/issues/10349#issuecomment-841605710


   I mean how to config to check the other none-sharding tables in one datasource 


-- 
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:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #10349: data migration config

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10349:
URL: https://github.com/apache/shardingsphere/issues/10349#issuecomment-842045156


   Hi  @wavelet123 ,
   
   `Check non-sharding` tables?  Does that mean to show  `non-sharding` tables in  Proxy?
   If you use 5.0.0-alpha, all non-sharding tables will be present by executing `show tables` SQL, even though they do not show up in your yaml configuration. 


-- 
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:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu closed issue #10349: data migration config

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #10349:
URL: https://github.com/apache/shardingsphere/issues/10349


   


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org