Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Plan bidirectional metadata sync #27

Closed
jasonmp85 opened this issue Dec 9, 2014 · 1 comment · Fixed by #103
Closed

Plan bidirectional metadata sync #27

jasonmp85 opened this issue Dec 9, 2014 · 1 comment · Fixed by #103
Assignees
Milestone

Comments

@jasonmp85
Copy link
Collaborator

Citus and pg_shard should be able to sync distribution metadata back and forth without any user intervention. Determine what approaches could meet this need.

@ozgune
Copy link
Contributor

ozgune commented Jan 5, 2015

A quick note that could make things easier.

Citus' Select logic doesn't change a shard's (or shard placement's) metadata. So if a table is created and owned by pg_shard, we'll only need to support uni-directional metadata sync from pg_shard to CitusDB. If a table is owned by CitusDB, it's still an open question if a user would want to insert data into it through pg_shard.

Citus' Select doesn't need to change metadata because it recognizes failures in one of two ways:

  1. The user updates the membership list in pg_worker_list.conf, and then sends PostgreSQL a SIGHUP. Citus won't send Select queries to nodes that aren't in the membership list.
  2. If the shard placement is marked as inactive, Citus won't send a query to it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants