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

feat(strategy): Pisanix supports horizontal sharding strategy #257

Open
wbtlb opened this issue Aug 11, 2022 · 2 comments
Open

feat(strategy): Pisanix supports horizontal sharding strategy #257

wbtlb opened this issue Aug 11, 2022 · 2 comments
Assignees
Labels
app:pisa-proxy Pisa-Proxy related changes in:strategy Strategy related changes
Milestone

Comments

@wbtlb
Copy link
Contributor

wbtlb commented Aug 11, 2022

Development Task

Our goal is to support simple sharding features as follows:

  1. Key-based table sharding feature.
  2. horizontal sharding strategy.
  • query planner
  • SQL rewrit
  • SQL execute
  • Resultset merge
  1. Aggregate function
  • count()
  • sum()
  • max()
  • min()
  • last_insert_id()
  1. simple node order by,group by,limit
  2. sharding with =, IN, BETWEEN AND, >, <, >=, <=
  3. Simple node trasaction
  4. set/charset
  5. config line expression
  6. sharding config

Background

Pisanix will support sharding in v0.3.0.

Implement

Description

@wbtlb wbtlb added app:pisa-proxy Pisa-Proxy related changes in:strategy Strategy related changes labels Aug 11, 2022
@wbtlb wbtlb added this to the v0.3.0 milestone Aug 11, 2022
@wbtlb wbtlb changed the title feat(strategy): Pisanix supports sharding strategy feat(strategy): Pisanix supports horizontal sharding strategy Aug 11, 2022
@mlycore
Copy link
Member

mlycore commented Aug 12, 2022

This could be divided into three parts of operators, including equal, in and between.

@wbtlb
Copy link
Contributor Author

wbtlb commented Aug 12, 2022

This could be divided into three parts of operators, including equal, in and between.

Hi, mlycore

I will divide the task, and there will be different issue to describe the design of this feature.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
app:pisa-proxy Pisa-Proxy related changes in:strategy Strategy related changes
Projects
None yet
Development

No branches or pull requests

3 participants