You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "jainanuj07 (via GitHub)" <gi...@apache.org> on 2025/02/27 19:20:39 UTC

[I] Automatic Data rebalancing by adding new data node [shardingsphere]

jainanuj07 opened a new issue, #34813:
URL: https://github.com/apache/shardingsphere/issues/34813

   I have set up ShardingSphere-Proxy with two data sources and defined a sharding rule using the MOD function on the ID column. After adding a new data source, I noticed that new data is being distributed across the updated nodes, but the existing data remains on the original instances.
   
   Does ShardingSphere support automatic rebalancing when a new data source is added?


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

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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "jainanuj07 (via GitHub)" <gi...@apache.org>.
jainanuj07 commented on issue #34813:
URL: https://github.com/apache/shardingsphere/issues/34813#issuecomment-2701259590

   @terrymanu can you pls help.  


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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #34813:
URL: https://github.com/apache/shardingsphere/issues/34813#issuecomment-2754233343

   You may use telephone or email to contact them. https://www.sphere-ex.cn/about/


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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #34813:
URL: https://github.com/apache/shardingsphere/issues/34813#issuecomment-2773919838

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #34813:
URL: https://github.com/apache/shardingsphere/issues/34813#issuecomment-2709415849

   The SphereEx enterprise version include this feature:
   https://www.sphere-ex.cn/comparison/
   
   ShardingSphere currently remains focused on managing database traffic and has no immediate plans to expand its product feature scope.


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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #34813:
URL: https://github.com/apache/shardingsphere/issues/34813#issuecomment-2734920759

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "jainanuj07 (via GitHub)" <gi...@apache.org>.
jainanuj07 commented on issue #34813:
URL: https://github.com/apache/shardingsphere/issues/34813#issuecomment-2714428098

   @terrymanu how can I use  https://www.sphere-ex.cn/comparison/ . i tried to reach out the team for the product demo but did not get any response. 


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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "jainanuj07 (via GitHub)" <gi...@apache.org>.
jainanuj07 commented on issue #34813:
URL: https://github.com/apache/shardingsphere/issues/34813#issuecomment-2703466778

   Version : 5.5.2
   
   data:
     config-sharding.yaml: |
       databaseName: api-beta-test
       dataSources:
         ds_0:
           url: 
           username: <username>
           password: <password>
         ds_1:
           url: 
           username: <username>
           password: <password>
       rules:
         - !SHARDING
           tables:
             payments:
               actualDataNodes: ds_0.payments_0, ds_1.payments_1
               tableStrategy:
                 standard:
                   shardingColumn: merchant_id
                   shardingAlgorithmName: payments_table_algorithm
               keyGenerateStrategy:
                 column: id
                 keyGeneratorName: snowflake
           defaultDatabaseStrategy:
             standard:
               shardingColumn: merchant_id
               shardingAlgorithmName: database_sharding_algorithm
           defaultTableStrategy:
             none: {}
           shardingAlgorithms:
             database_sharding_algorithm:
               type: INLINE
               props:
                 algorithm-expression: ds_${Math.abs(merchant_id.hashCode()) % 2 }
             payments_table_algorithm:
               type: INLINE
               props:
                 algorithm-expression: payments_${Math.abs(merchant_id.hashCode()) % 2}
           keyGenerators:
             snowflake:
               type: SNOWFLAKE
   
   
   This is my current config and now I want to add one more datasource and shard the data for some merchants to new data source. 
   
   So I will add and change the hash mod algo. This is my new Config. 
   
   data:
     config-sharding.yaml: |
       databaseName: api-beta-test
       dataSources:
         ds_0:
           url: 
           username: <username>
           password: <password>
         ds_1:
           url: 
           username: <username>
           password: <password>
        ds_2:
           url: 
           username: <username>
           password: <password>
         rules:
         - !SHARDING
           tables:
             payments:
               actualDataNodes: ds_0.payments_0, ds_1.payments_1,ds_2.payments_2
               tableStrategy:
                 standard:
                   shardingColumn: merchant_id
                   shardingAlgorithmName: payments_table_algorithm
               keyGenerateStrategy:
                 column: id
                 keyGeneratorName: snowflake
           defaultDatabaseStrategy:
             standard:
               shardingColumn: merchant_id
               shardingAlgorithmName: database_sharding_algorithm
           defaultTableStrategy:
             none: {}
           shardingAlgorithms:
             database_sharding_algorithm:
               type: INLINE
               props:
                 algorithm-expression: ds_${Math.abs(merchant_id.hashCode()) % 3 }
             payments_table_algorithm:
               type: INLINE
               props:
                 algorithm-expression: payments_${Math.abs(merchant_id.hashCode()) % 3}
           keyGenerators:
             snowflake:
               type: SNOWFLAKE


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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #34813:
URL: https://github.com/apache/shardingsphere/issues/34813#issuecomment-2703202818

   What is the version and config


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


Re: [I] Automatic Data rebalancing by adding new data node [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #34813: Automatic Data rebalancing  by adding new data node
URL: https://github.com/apache/shardingsphere/issues/34813


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