You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Ron Siemens <rs...@greatergood.com> on 2013/05/09 01:03:47 UTC
Backup and restore between different node-sized clusters
I have a 3-node cluster in production and a single-node development cluster. I tested snapshotting a column family from the 3-node production cluster, grouping the files together, and restoring onto my single node development system. That worked fine. Can I go the other direction? It's not easy for me to test in that direction: I'll get the chance at some point but would like to hear if you've done this.
If I just put the snapshot from the single node cluster on one of the nodes from the 3-node cluster, and do a JMX loadNewSSTables on that node, will the data load correctly into the 3-nodes? Or is something more complex involved?
FYI, I'm following the instructions below, but only doing per column family backup and restore.
http://www.datastax.com/docs/1.2/operations/backup_restore
Thanks,
Ron
Re: Backup and restore between different node-sized clusters
Posted by aaron morton <aa...@thelastpickle.com>.
Special case if you have 3 nodes and RF 3 you can copy the files to each node and use nodetool refresh.
Cheers
-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 9/05/2013, at 11:20 AM, Jonathan Ellis <jb...@gmail.com> wrote:
> You want to use sstableloader when the cluster sizes are different; it
> will stream things to the right places in the new one.
>
> On Wed, May 8, 2013 at 6:03 PM, Ron Siemens <rs...@greatergood.com> wrote:
>>
>> I have a 3-node cluster in production and a single-node development cluster. I tested snapshotting a column family from the 3-node production cluster, grouping the files together, and restoring onto my single node development system. That worked fine. Can I go the other direction? It's not easy for me to test in that direction: I'll get the chance at some point but would like to hear if you've done this.
>>
>> If I just put the snapshot from the single node cluster on one of the nodes from the 3-node cluster, and do a JMX loadNewSSTables on that node, will the data load correctly into the 3-nodes? Or is something more complex involved?
>>
>> FYI, I'm following the instructions below, but only doing per column family backup and restore.
>>
>> http://www.datastax.com/docs/1.2/operations/backup_restore
>>
>> Thanks,
>> Ron
>>
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder, http://www.datastax.com
> @spyced
Re: Backup and restore between different node-sized clusters
Posted by Jonathan Ellis <jb...@gmail.com>.
You want to use sstableloader when the cluster sizes are different; it
will stream things to the right places in the new one.
On Wed, May 8, 2013 at 6:03 PM, Ron Siemens <rs...@greatergood.com> wrote:
>
> I have a 3-node cluster in production and a single-node development cluster. I tested snapshotting a column family from the 3-node production cluster, grouping the files together, and restoring onto my single node development system. That worked fine. Can I go the other direction? It's not easy for me to test in that direction: I'll get the chance at some point but would like to hear if you've done this.
>
> If I just put the snapshot from the single node cluster on one of the nodes from the 3-node cluster, and do a JMX loadNewSSTables on that node, will the data load correctly into the 3-nodes? Or is something more complex involved?
>
> FYI, I'm following the instructions below, but only doing per column family backup and restore.
>
> http://www.datastax.com/docs/1.2/operations/backup_restore
>
> Thanks,
> Ron
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder, http://www.datastax.com
@spyced