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