pisanix icon indicating copy to clipboard operation
pisanix copied to clipboard

feat(strategy): Pisanix supports horizontal sharding strategy

Open wbtlb opened this issue 2 years ago • 2 comments

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 avatar Aug 11 '22 07:08 wbtlb

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

mlycore avatar Aug 12 '22 07:08 mlycore

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.

wbtlb avatar Aug 12 '22 10:08 wbtlb