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

www: Migrate userdb to cockroachdb #820

Closed
lukebp opened this issue Apr 25, 2019 · 0 comments · Fixed by #856
Closed

www: Migrate userdb to cockroachdb #820

lukebp opened this issue Apr 25, 2019 · 0 comments · Fixed by #856
Assignees
Labels
enhancement The issue enhances an existing feature.

Comments

@lukebp
Copy link
Member

lukebp commented Apr 25, 2019

We currently use LocalDB to store user data. LocalDB does not support concurrent connections. Part of scaling politeiawww is being able to run multiple politeiawww instances. In order to do this we need to use a database that supports concurrent connections. We use CockroachDB for everything else so it makes sense to migrate the userdb over to CockroachDB.

#689 took a crack at this a while back, but a lot of things have changed since then.

When we migrate the user data over to CockroachDB we also need to change how it is stored. The public user fields (userID, username, pukeys) should be queryable fields and everything else should be stored as an encrypted blob.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement The issue enhances an existing feature.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant