zalando / zalando/postgres-operator
Question: Is it possible to have multiple databases master spilo running on multiple node so that we can have multiple write operation?
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 5.2k
- Forks
- 1.1k
- Avg merge
- 2d 16h
- Merged PRs (30d)
- 3
Description
I have created 3 databases on Postgres running on 3 node cluster. I know that write operation is allowed only on the node which has spilo-role master.
But I wanted to run 3 databases masters on 3 different nodes where each database has a different master node and the rest as a replica. I wanted to know if it's possible and if yes then what do I need to change? I think in this way bottleneck of writing data simultaneously when the master is one node for each DB will be overcome.
eg.
Database | Master Node | Replica Node
DB1 | node1 | node2 , node3
DB2 | node2 | node1 , node3
DB1 | node3 | node1 , node2
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The issue names no files, tests, or entry points. Start by reviewing how the operator manages Spilo roles and PostgreSQL cluster topology, then determine whether separate database masters across nodes are supported and what configuration or design changes would be required; document the feasibility and clear completion criteria.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- kubernetes, postgresql
- Domain
- databases, distributed-systems, infrastructure
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 15/100