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 <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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: [email protected] > <mailto:[email protected]> > For additional commands, e-mail: [email protected] > <mailto:[email protected]> > > -- > Best Regards, > Kiran.M.K.
