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

demo: provide a command in 'cockroach demo' to persist the data #39505

Open
knz opened this issue Aug 10, 2019 · 3 comments
Open

demo: provide a command in 'cockroach demo' to persist the data #39505

knz opened this issue Aug 10, 2019 · 3 comments
Labels
A-cli-client CLI commands that pertain to using SQL features A-cli-server CLI commands that pertain to CockroachDB server processes A-demo C-wishlist A wishlist feature.

Comments

@knz
Copy link
Contributor

knz commented Aug 10, 2019

While experimenting with cockroach demo it's possible that a sequence of interactive commands has placed the data in an "interesting state" that wants further investigation, but the precise list of steps to arrive there is unclear.
It would be desirable to be able to issue a simple command that makes the cockroach demo persistent.

This is currently already possible using the following (more complex) sequence of steps:

  1. in the demo shell, use select address from crdb_internal.gossip_nodes to find the node address of the demo session
  2. in a separate shell start a new node with a persistent store with --join and the address given at 1
  3. decommission node 1 in this cluster that now has 2 nodes. This will move all the ranges from the demo session (in-memory store) to the persistent store.
  4. stop the demo session. Now the data directory for node created in step 2 has a perfect copy of the demo session. This is sufficient to reuse the data because the demo replication factor is 1.

It would be nice if these steps could be automated somehow.

Jira issue: CRDB-6344

@knz knz added A-cli C-wishlist A wishlist feature. labels Aug 10, 2019
@knz
Copy link
Contributor Author

knz commented Aug 10, 2019

cc @jordanlewis

@jordanlewis
Copy link
Member

Cool idea!

@jordanlewis jordanlewis changed the title cli: provide a command in 'cockroach demo' to persist the data demo: provide a command in 'cockroach demo' to persist the data Aug 23, 2019
@knz knz added A-cli-client CLI commands that pertain to using SQL features A-cli-server CLI commands that pertain to CockroachDB server processes and removed A-cli labels Mar 20, 2021
@github-actions
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-cli-client CLI commands that pertain to using SQL features A-cli-server CLI commands that pertain to CockroachDB server processes A-demo C-wishlist A wishlist feature.
Projects
None yet
Development

No branches or pull requests

3 participants