citusdata / citusdata/citus

Add template schemas for easier distributed schema management

Open
#7,356 4 comments 0 reactions 0 assignees View on GitHub
feature schema-based-sharding
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.