Add template schemas for easier distributed schema management
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Has there been any thought into how Citus could manage multiple schemas with the same table structure? There could be a master template schema and then a Citus command that would create new schemas based on this template. Citus would then monitor this template schema for table structure changes that would then be automatically replicated to all the schemas that were created using this template.
It would be similar to how the row based sharding works now where you only need to manage a single table structure and Citus replicates that to all the shard tables.
We currently are using separate databases (a few hundred) for each enterprise SAAS customer and having each customer as their own schema would be an improvement, but having an easy and reliable way to replicate schema changes would really make a compelling case.
Contributor guide
Assessment
This issue has not been assessed yet.