Re: Rollback Cassandra after 1 node upgrade

2020-09-04 Thread Aakash Pandhi
How much data to restore and repair on that node? Sincerely, Aakash Pandhi On Friday, September 4, 2020, 11:08:56 PM CDT, manish khandelwal wrote: 3.11.2 to 2.1.16 On Sat, Sep 5, 2020 at 9:27 AM Surbhi Gupta wrote: Hi Manish, Please provide both versions. Thanks Surbhi On Fri

Re: Cassandra Delete vs Update

2020-05-23 Thread Aakash Pandhi
emove whole partition for records_by_date table if that's what you want.  Regards, Aakash Pandhi On Saturday, May 23, 2020, 09:09:48 AM CDT, Laxmikant Upadhyay wrote: Hi All,I have a query regarding Cassandra data modelling:  I have created two tables: 1. CREATE TABLE ks.recor

Re: Issues, understanding how CQL works

2020-04-22 Thread Aakash Pandhi
imposes on file size. But if you are selecting 1 or 2 columns it should be fine I assume.  Here is syntax CAPTURE | | | | CAPTURE Appends query results to a file. | | | Sincerely, Aakash Pandhi On Wednesday, April 22, 2020, 08:38:38 AM CDT, Durity, Sean R wrote: I thought

Repair and NodeSync

2020-04-02 Thread Aakash Pandhi
Hi All,  I am reviewing our data sync procedures to improve so need your input on NodeSync.  Are there any cons of implementing NodeSync over Repair? Is NodeSync a future direction for cluster wide data sync?  Thank You,Aakash

Re: Handling Long running Cassandra Rebuild Process

2020-03-28 Thread Aakash Pandhi
related with stream and send notification to yourself. Sincerely, Aakash Pandhi On Friday, March 27, 2020, 11:54:41 PM CDT, Jai Bheemsen Rao Dhanwada wrote: netstats only gives the active streams, for example if the rebuild fails because of a network issue or something there is no trace

Re: Hints replays very slow in one DC

2020-02-26 Thread Aakash Pandhi
You may find throttle rate of hinted handoff on node and adjust if needed.  nodetool gethintedhandoffthrottlekb and you may also set by nodetool sethintedhandoffthrottlekb I would also check disk stats where hints are stored either by sar or iostat.  Sincerely, Aakash Pandhi On Wednesday

Re: Mechanism to Bulk Export from Cassandra on daily Basis

2020-02-19 Thread Aakash Pandhi
John, copy is not recommended for than 2 millions rows, so copy is ruled out in your case for those 30 tables you mentioned. Sincerely, Aakash Pandhi On Wednesday, February 19, 2020, 02:26:15 PM CST, Amanda Moran wrote: HI there- DataStax recently released their bulkloader into

Re: Mechanism to Bulk Export from Cassandra on daily Basis

2020-02-19 Thread Aakash Pandhi
John, Greetings,  Requirement is to just export data from table and stage it somewhere? OR export it and load them in another cluster/table? sstableloader is a utility which can help you as it is designed for bulk loading.   Sincerely, Aakash Pandhi On Wednesday, February 19, 2020, 10:13