I have to copy whole key space which has many tables, some tables are 30 GB. Copy is going to take more and also load is shooting up.
I have a 4 node source cluster and 4 node cluster target cluster. My question is do need to execute below command from all the nodes of source cluster ? /bin/sstableloader -d node1,node2,node3,node4 ‘path to folder’ Thanks, > On Sep 26, 2018, at 3:43 PM, Kiran mk <coolkiran2...@gmail.com> wrote: > > Please do try COPY TO commas to dump the data with csv or any other delimited > format to dump. Then try Run COPY FROM on target cluster after copying the > exported file. > > Best Regards, > Kiran.M.K > > > On Thu, 27 Sep 2018 at 4:05 AM, rajasekhar kommineni <rajaco...@gmail.com > <mailto:rajaco...@gmail.com>> wrote: > Hi All, > > I have a requirement to copy table data from cluster to another cluster, I > used both sstableloader and copy snapshot, run nodetool refresh command. In > both cases the count of records in new cluster is less than original cluster. > I used select count(*) table name to count the records. > > Any body have clue on how this works. > > Thanks, > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > <mailto:user-unsubscr...@cassandra.apache.org> > For additional commands, e-mail: user-h...@cassandra.apache.org > <mailto:user-h...@cassandra.apache.org> > > -- > Best Regards, > Kiran.M.K.