Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

关于分库分表可扩容部分的建议 #276

Open
602122993 opened this issue Sep 26, 2022 · 10 comments
Open

关于分库分表可扩容部分的建议 #276

602122993 opened this issue Sep 26, 2022 · 10 comments
Labels
enhancement New feature or request

Comments

@602122993
Copy link

在如何设计一个可以动态扩容缩容的分库分表方案中,直接简单粗暴的份32*32的方式明显不符合当前面试情况,而且也不太支持所谓的动态扩容所容,建议可以新增一个方案利用hash+range的方式,进行动态扩容缩容。

@yanglbme
Copy link
Member

感谢建议,会考虑新增

@doocs doocs deleted a comment Sep 27, 2022
@yanglbme yanglbme added the enhancement New feature or request label Sep 28, 2022
@1725636955
Copy link

在如何设计一个可以动态扩容缩容的分库分表方案中,直接简单粗暴的份32*32的方式明显不符合当前面试情况,而且也不太支持所谓的动态扩容所容,建议可以新增一个方案利用hash+range的方式,进行动态扩容缩容。

具体方案,老哥有文档链接吗或者可以简单描述下吗?我想学习下

@doocs doocs deleted a comment from yongroot Dec 18, 2023
@iyuzhang
Copy link

在如何设计一个可以动态扩容缩容的分库分表方案中,直接简单粗暴的份32*32的方式明显不符合当前面试情况,而且也不太支持所谓的动态扩容所容,建议可以新增一个方案利用hash+range的方式,进行动态扩容缩容。

具体方案,老哥有文档链接吗或者可以简单描述下吗?我想学习下

我理解其实就是映射分组的思路,原先的id在固定在某个值A以下,id<A的放入原先分库分表内,id>=A的,另起一套分库。唯一需要注意的点是先分组,再hash,若ID本身就是线性增长的,用不用hash都无所谓。

@yongroot
Copy link

yongroot commented Oct 22, 2024 via email

@xiaopan1916
Copy link

xiaopan1916 commented Oct 22, 2024 via email

@lujocom
Copy link

lujocom commented Oct 22, 2024 via email

@zhFuture
Copy link

zhFuture commented Oct 22, 2024 via email

@kevin0016
Copy link

kevin0016 commented Oct 22, 2024 via email

@onions1111
Copy link

onions1111 commented Oct 22, 2024 via email

@tigerlee0209
Copy link

tigerlee0209 commented Oct 22, 2024 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

13 participants