matrixorigin
[Feature Request]: Support publish/subscribe with tables
Is there an existing issue for the same feature request?
- [X] I have checked the existing issues.
Is your feature request related to a problem?
No response
Describe the feature you'd like
Currently MatrixOne supports publish and subscribe with databases between accounts.
https://docs.matrixorigin.cn/1.1.2/MatrixOne/Develop/Publish-Subscribe/pub-sub-overview/
In real world use cases, database could be too large for users, publish/subscribe a table could be more realistic.
Describe implementation you've considered
We should follow the current syntax of publication/subscription. The complete use cases are as following:
On publisher side as acc0: create publication pub1 table tb1 account acc1; //publish tb1 to acc1 create publication pub2 table tb1; //broadcast tb1 to all accounts
On subscriber side as acc2: create table db1.tb1 from acc0 publication pub1;
Show publications, and Show subscriptions statements should give these table sharing metadata.
The subscribed table should be read-only as subscribed database. No update/insert/delete could apply to this table. But dropping it is ok.
Documentation, Adoption, Use Case, Migration Strategy
No response
Additional information
No response
