cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Boxenhorn (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-2636) Import/Export of Schema Migrations
Date Wed, 11 May 2011 15:35:47 GMT
Import/Export of Schema Migrations

                 Key: CASSANDRA-2636
             Project: Cassandra
          Issue Type: Improvement
            Reporter: David Boxenhorn

My use case is like this: I have a development cluster, a staging cluster and a production
cluster. When I finish a set of migrations on the development cluster, I want to apply them
to the staging cluster, and eventually the production cluster. I don't want to do it by hand,
because it's a painful and error-prone process. What I would like to do is export the last
N migrations from the development cluster as a text file, with exactly the same format as
the original text commands, and import them to the staging and production clusters. 

I think the best place to do this might be the CLI, since you would probably want to view
your migrations before exporting them. Something like this:

show migrations N;                                   Shows the last N migrations.
export migrations N <fileName>    Exports the last N migrations to file fileName.
import migrations <fileName>                    Imports migrations from fileName.

The import process would apply the migrations one at a time giving you feedback like, "applying
migration: update column family...". If a migration fails, the process should give an appropriate
message and stop. 

This message is automatically generated by JIRA.
For more information on JIRA, see:

View raw message