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

Investigate cockroach DB integration #98

Closed
bryanchriswhite opened this issue Sep 17, 2022 · 1 comment
Closed

Investigate cockroach DB integration #98

bryanchriswhite opened this issue Sep 17, 2022 · 1 comment
Labels
C-investigation Category: Tracking an investigation or PoC

Comments

@bryanchriswhite
Copy link

bryanchriswhite commented Sep 17, 2022

Background

As the graphql API service scales to meat demand, the DB will quickly become a performance bottleneck.

(see: CockroachDB quick start)
(see: CockroachDB comparison)

Acceptance Criteria

We've determined whether CockroachDB can be easily integrated by swapping out the postgres for it:
a. If not, then we've enumerated those pain points / issues
b. If so, then we have a working proof-of-concept

@bryanchriswhite bryanchriswhite added the C-investigation Category: Tracking an investigation or PoC label Sep 17, 2022
@bryanchriswhite bryanchriswhite added this to the DB Scalability milestone Nov 8, 2022
@manjeet-fetchai
Copy link

Findings:

  • We are able to integrate cockroachdb with N replicas and replace it with our existing postgres
  • The genesis import does fine correctly with cockroackdb
  • On node startup, we found a few "type errors" - need to debug that [will be a different task]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-investigation Category: Tracking an investigation or PoC
Projects
None yet
Development

No branches or pull requests

2 participants