[Feature] Consider support compute nodes consistency for DistSQL

apache / shardingsphere

Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.

Apache License 2.0

19.97k stars 6.75k forks source link

[Feature] Consider support compute nodes consistency for DistSQL #24366

Open zhaojinchao95 opened 1 year ago

zhaojinchao95 commented 1 year ago

Hi community,

Currently, create/alter/drop configuration is directly persisted to the governance center when we use Cluster mode. The metadata refresh is driven by governance center generated events, because of this process is asyn, so we don't know metadata are refresh completed. It may cause some unknown errors if DistSQL executes too fast or has dependencies. So, maybe we can add consistency feature to fix it.

If you are interested, welcome to design and complete it.

RaigorJiang commented 1 year ago

Seems like a complicated task, any initial thoughts for reference?