search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.74k stars 6.68k forks source link

ShardingSphere rule model persistence #24236

Open vikiuvb opened 1 year ago

vikiuvb commented 1 year ago

Feature Request

Is your feature request related to a problem?

ShardingSphere is currently storing all the rule configuration under one node in repository. This may work fine for small projects with few tables. However for large projects, having hundreds of table, it might hit the limit of the underlying repository storage.

For an instance.

shardingsphere_rules

Describe the feature you would like.

A better model is to store the rules based on the rule type, and for the rules where there is a list of configurations (Ex: ShardingRule) is to store the configuration in its own node.

Example:

image

Pace2Car commented 1 year ago

Hi @zhaojinchao95, please help to check it, it looks like this work is in progress.

vikiuvb commented 1 year ago

@zhaojinchao95 Is this WIP?

zhaojinchao95 commented 1 year ago

@zhaojinchao95 Is this WIP?

Hi, thank you for your suggestion, you are right. And we will plan to redesign node structure, we can discuss it together.

strongduanmu commented 1 year ago

Good suggestion, let's consider this in our new proposal.