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

是否可以增加分表规则 #130

Open
kunchong21 opened this issue Jun 21, 2017 · 0 comments
Open

是否可以增加分表规则 #130

kunchong21 opened this issue Jun 21, 2017 · 0 comments

Comments

@kunchong21
Copy link

kunchong21 commented Jun 21, 2017

**目前DBProxy线上使用的版本支持分表功能,分表策略目前为:hash。

原使用Atlas
.当通过Atlas执行(SELECT、DELETE、UPDATE、INSERT、REPLACE)操作时,Atlas会根据分表结果(id%100=k),定位到相应的子表(stu_k)。例如,执行select * from stu where id=110;,Atlas会自动从stu_10这张子表返回查询结果。但如果执行SQL语句(select * from stu;)时不带上id,则会提示执行stu 表不存在。
==============**=======
是否可以增加 Atlas 一样的分表规则 以方便切换 。。

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

No branches or pull requests

1 participant