citusdata / citusdata/citus

Create databases during shard creation

Open
#210 2 comments 0 reactions 0 assignees View on GitHub
feature research
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

**Issue by [jberkus](https://github.com/jberkus)**
_Thursday Dec 04, 2014 at 22:34 GMT_
_Originally opened as https://github.com/citusdata/pg_shard/issues/3_

---

Currently the user has to manually create databases on each worker to match the master. Since we require that the database names match anyways, and there are no real options here, we should just have master_create_worker_shards create the databases on workers if they don't already exist. Probably we should do this by connecting to the "postgres" database first, which would then require some extra error handling.

Contributor guide

Open the contributing guide

Research direction

Start at the master_create_worker_shards entry point and trace how it connects to workers. The issue proposes connecting to the postgres database first and creating the matching worker database when absent; done means shard creation no longer requires manual database setup on each worker, with the extra connection errors handled.

Written by the indexing model from the issue text.

Assessment

Tech stack
c, postgresql
Domain
databases, distributed-systems
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.