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.

Sign up for GitHub

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

Jump to bottom

[YSQL] Pick transaction id such that its leader is local to transaction coordinator #2889

Closed
ndeodhar opened this issue Nov 8, 2019 · 1 comment
Closed

[YSQL] Pick transaction id such that its leader is local to transaction coordinator #2889

ndeodhar opened this issue Nov 8, 2019 · 1 comment
Assignees
@spolitov
Labels
area/docdb YugabyteDB core features area/ysql Yugabyte SQL (YSQL)
Milestone
v2.1

Comments

@ndeodhar
Copy link
Contributor

ndeodhar commented Nov 8, 2019 •
edited by kmuthukk
Loading

In case of

BEGIN;
INSERT ...
...
COMMIT;

pick a "transaction status id" that sits on a tablet on the yb-tserver that's on the same node as the PG proxy layer that's handling the client request. This will make sure the commit step doesn't have an extra hop to a non-local leader.
@ndeodhar ndeodhar added area/ysql Yugabyte SQL (YSQL) area/docdb YugabyteDB core features labels Nov 8, 2019
@ndeodhar ndeodhar added this to the v2.1 milestone Nov 8, 2019
@kmuthukk kmuthukk changed the title [YSQL] Make transaction coordinator local to tablet leader for write [YSQL] Pick transaction id such its transaction status record's leader is local to transaction coordinator Nov 12, 2019
@ndeodhar ndeodhar assigned ndeodhar and unassigned nocaway Nov 15, 2019
@bmatican bmatican assigned spolitov and unassigned ndeodhar Nov 15, 2019
@spolitov
Copy link
Contributor

Implemented as a side effect of 877a3e0

@kmuthukk kmuthukk changed the title [YSQL] Pick transaction id such its transaction status record's leader is local to transaction coordinator [YSQL] Pick transaction id such that its leader is local to transaction coordinator Nov 24, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@spolitov spolitov

Labels
area/docdb YugabyteDB core features area/ysql Yugabyte SQL (YSQL)
Projects
None yet
Milestone
v2.1
Development

No branches or pull requests
3 participants
@spolitov @ndeodhar @nocaway