new feature: new capability shared

[TennyZhuang]

Feature Description

• Some storage backends can be accessed by many processes and they are usually a service.
• Some storage backends can only be accessed by the current process and they are usually an embedded engine.

Maybe we can differentiate them by adding a new capability.

Problem and Solution

What's the best name for the capability?

• share_access: not good since some backends can be accessed from different threads but not different processes, such as dashboard.
• multi_processing_access: a little long

Additional Context

#5324 was blocked by the capability

Are you willing to contribute to the development of this feature?

• Yes, I am willing to contribute to the development of this feature.

[Xuanwo]

Further discussion took place at #5324.