Cassandra Replication Factor change from 2 to 3 for each data center

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

This is just basic question to ask..but it is worth to ask.

We changed Replication factor from 2 to 3 in our production cluster. We have 2 
data centers.

Does nodetool repair -dcpar from single node in one data center is sufficient 
for the whole replication to take effect? Please confirm.

Do I need to run it from each node?

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.

Any Cassandra Backup and Restore tool like Cassandra Reaper?

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Any Cassandra Backup and Restore tool like Cassandra Reaper for Repairs?

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.

Datastax pricing

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

We want to consider the enterprise datastax solution. currently we are using 
opensource solution. What would be the pricin per node?

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.

RE: Best JMX Monitor to graphite ?

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

We are using collectd-fast-jmx

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.


From: Tobias Eriksson [mailto:tobias.eriks...@qvantel.com]
Sent: Wednesday, November 29, 2017 1:19 PM
To: User 
Subject: Best JMX Monitor to graphite ?

Hi
 I would like to monitor my Cassandra cluster looking at the JMX beans and 
transfer stats to Graphite.
I have done some googling and some suggest using jmxtrans, and some has moved 
on to GenericJMX
What would you suggest ?
-Tobias


--
Tobias Eriksson
Chief Architect Research – CTO Office
Qvantel Sweden AB
Tel; +46 768 832453
e-mail; tobias.eriks...@qvantel.com

RE: Reaper 1.0

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Jon,

I built a docker image and deployed stage environment for testing. I started 
process as java –jar way.

Where do the logs generate?

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: Jon Haddad [mailto:jonathan.had...@gmail.com] On Behalf Of Jon Haddad
Sent: Wednesday, November 15, 2017 9:23 AM
To: user <user@cassandra.apache.org>
Subject: Re: Reaper 1.0

Apache 2 Licensed, just like Cassandra.  
https://github.com/thelastpickle/cassandra-reaper/blob/master/LICENSE.txt

Feel free to modify, put in prod, fork or improve.

Unfortunately I had to re-upload the Getting Started video, we had accidentally 
uploaded a first cut.  Correctly link is here: 
https://www.youtube.com/watch?v=0dub29BgwPI

Jon


On Nov 15, 2017, at 9:14 AM, Harika Vangapelli -T (hvangape - AKRAYA INC at 
Cisco) <hvang...@cisco.com<mailto:hvang...@cisco.com>> wrote:

Open source, free to use in production? Any License constraints, Please let me 
know.

I experimented with it yesterday, really liked it.





Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com<http://cisco.com/>


Think before you print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: Jon Haddad [mailto:jonathan.had...@gmail.com] On Behalf Of Jon Haddad
Sent: Tuesday, November 14, 2017 2:18 PM
To: user <user@cassandra.apache.org<mailto:user@cassandra.apache.org>>
Subject: Reaper 1.0

We’re excited to announce the release of the 1.0 version of Reaper for Apache 
Cassandra!  We’ve made a lot of improvements to the flexibility of managing 
repairs and simplified the UI based on feedback we’ve received.

We’ve written a blog post discussing the changes in detail here: 
http://thelastpickle.com/blog/2017/11/14/reaper-10-announcement.html

We also have a new YouTube video to help folks get up and running quickly: 
https://www.youtube.com/watch?v=YKJRRFa22T4

The reaper site has all the docs should you have any questions: 
http://cassandra-reaper.io/

Thanks all,
Jon

RE: Reaper 1.0

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Open source, free to use in production? Any License constraints, Please let me 
know.

I experimented with it yesterday, really liked it.

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.


From: Jon Haddad [mailto:jonathan.had...@gmail.com] On Behalf Of Jon Haddad
Sent: Tuesday, November 14, 2017 2:18 PM
To: user 
Subject: Reaper 1.0

We’re excited to announce the release of the 1.0 version of Reaper for Apache 
Cassandra!  We’ve made a lot of improvements to the flexibility of managing 
repairs and simplified the UI based on feedback we’ve received.

We’ve written a blog post discussing the changes in detail here: 
http://thelastpickle.com/blog/2017/11/14/reaper-10-announcement.html

We also have a new YouTube video to help folks get up and running quickly: 
https://www.youtube.com/watch?v=YKJRRFa22T4

The reaper site has all the docs should you have any questions: 
http://cassandra-reaper.io/

Thanks all,
Jon

RE: Stable Cassandra 3.x version for production

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

We are using version 3.7 in prod.

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.


From: shini gupta [mailto:gupta.sh...@gmail.com]
Sent: Tuesday, November 7, 2017 2:30 AM
To: user@cassandra.apache.org
Subject: Fwd: Stable Cassandra 3.x version for production



Hi

Which version of Cassandra 3.x is stable and production-ready?

Regards

Spark aggregation jobs throwing Exceptions

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

We are using Spark-cassandra-connector to connect to Cassandra for aggregation 
jobs for writes with batch size of 1000. We are seeing exception as
All host(s) tried for query failed (tried: 00.00.00.00:9042 
(com.datastax.driver.core.exceptions.DriverException: Timeout while trying to 
acquire available connection (you may want to increase the driver number of 
per-host connections)))

We have a cluster of 6 nodes in one data center.And Spark Cassandra connector 
is always connecting to only one node.

We saw live threads on Cassandra cluster whenever thread counter (tc) is close 
to peaktc we are seeing the above exceptions. In Cassandra thread dump we saw 
lot of Parked threads.

"SharedPool-Worker-131" #1800 daemon prio=5 os_prio=0 tid=0x7f2d35539ab0 
nid=0xe6d waiting on condition [0x7f2d23e86000]
   java.lang.Thread.State: WAITING (parking)
   at sun.misc.Unsafe.park(Native Method)
   at 
java.util.concurrent.locks.LockSupport.park(LockSupport.java:304)
   at 
org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:85)
   at java.lang.Thread.run(Thread.java:745)

"SharedPool-Worker-129" #1791 daemon prio=5 os_prio=0 tid=0x7f2d346d24f0 
nid=0xe6c waiting on condition [0x7f2d23ec7000]
   java.lang.Thread.State: WAITING (parking)
   at sun.misc.Unsafe.park(Native Method)
   at 
java.util.concurrent.locks.LockSupport.park(LockSupport.java:304)
   at 
org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:85)
   at java.lang.Thread.run(Thread.java:745)

"SharedPool-Worker-132" #1799 daemon prio=5 os_prio=0 tid=0x7f2d343b0230 
nid=0xe6b waiting on condition [0x7f2c82fef000]
   java.lang.Thread.State: WAITING (parking)
   at sun.misc.Unsafe.park(Native Method)
   at 
java.util.concurrent.locks.LockSupport.park(LockSupport.java:304)
   at 
org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:85)
   at java.lang.Thread.run(Thread.java:745)

"SharedPool-Worker-133" #1798 daemon prio=5 os_prio=0 tid=0x7f2d3567de90 
nid=0xe6a waiting on condition [0x7f2c8c661000]
   java.lang.Thread.State: WAITING (parking)
   at sun.misc.Unsafe.park(Native Method)
   at 
java.util.concurrent.locks.LockSupport.park(LockSupport.java:304)
   at 
org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:85)
   at java.lang.Thread.run(Thread.java:745)

I looked at SEPWorker.run method and I observed  the below code is getting 
executed.

// if stop was signalled, go to sleep (don't try self-assign; being put to 
sleep is rare, so let's obey it
// whenever we receive it - though we don't apply this 
constraint to producers, who may reschedule us before
// we go to sleep)
if (stop())
while (isStopped())
LockSupport.park();



[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.

RE: server connection in authenticator

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Horia,

By just changing Authenticator and Authorizer in cassandra.yaml and adding 
custom libraries in /usr/share/cassandra/  you can plugin to custom 
authentication

sed -ri \
   -e 's/^(authenticator:).*/\1 
'com.cassandra.LdapCassandraAuthenticator'/' \
   -e 's/^(authorizer:).*/\1 
'com.cassandra.LdapCassandraAuthorizer'/' \
   "cassandra.yaml"

Copy custom jars > /usr/share/cassandra/
 


Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel: 
Cisco Systems, Inc.



United States
cisco.com


Think before you print.
This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click here for Company Registration Information.


-Original Message-
From: Horia Mocioi [mailto:horia.moc...@ericsson.com] 
Sent: Wednesday, October 25, 2017 3:38 AM
To: user@cassandra.apache.org
Subject: server connection in authenticator

Hello guys,

We are building up an authenticator using certificates. So far we came up with 
a solution, but implies changing some files in Cassandra code base in order to 
have the connection in the new Authenticator.

So, here are my questions:
* how are you guys doing this?
* is it possible to obtain the connection on the Authenticator without changing 
other files in the Cassandra code base, in that sense just creating a new 
Authenticator and set it up in cassandra.yaml?

Regards,
Horia

Calculate tokens from date range

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

We have data in tables with partitioning key as 'Timestamp' and we are in need 
of running repairs for last 3 months data because full repair is taking lot of 
time.
We are migrating data from Cassandra version 2 to 3.

Please guide us with your best suggestions.

Thanks

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.

RE: Rebalance a cassandra cluster

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Check with nodetool repair.

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.


From: Akshit Jain [mailto:akshit13...@iiitd.ac.in]
Sent: Tuesday, September 12, 2017 9:47 PM
To: user@cassandra.apache.org
Subject: Rebalance a cassandra cluster

Hi,
Can a cassandra cluster be unbalanced in terms of data?
If yes then how to rebalance a cassandra cluster.

Historical data movement to other cluster

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Is there a way to move past 3 months data from one cassandra cluster to other 
cluster?

Thanks,
Harika
[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.

RE: Cassandra Data migration from 2.2.3 to 3.7

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Jeff,  what is the meaning of this line you mentioned in below email..
‘making sure you dont overwrite any sstables with the same name’

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: Jeff Jirsa [mailto:jji...@gmail.com]
Sent: Tuesday, August 1, 2017 5:13 PM
To: cassandra <user@cassandra.apache.org>
Subject: Re: Cassandra Data migration from 2.2.3 to 3.7

Roughly that approach should work, modulo copying data in/out to the right 
paths, and making sure you dont overwrite any sstables with the same name.

(You dont need to refresh after the upgradesstables unless you've got 2 3.7 
clusters, and you may need to refresh before the upgradesstables if the 3.7 
cluster in step 3 is already running)


On Tue, Aug 1, 2017 at 3:44 PM, Harika Vangapelli -T (hvangape - AKRAYA INC at 
Cisco) <hvang...@cisco.com<mailto:hvang...@cisco.com>> wrote:
Jeff, I tried the below steps for just 3 rows of data, It looks to be working. 
But Confirm me this is right approach.

1.   Taking snapshot (using nodetool snapshot) in the existing cluster (2.2 
cluster)

2.   Bring the snapshot to new cluster and copy in keyspce/table (2.2->3.7)

3.   Nodetool upgrade sstbales on new cluster (3.7)

4.   Use noedtool refresh --   (3.7)
Does this approach work?

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com<http://cisco.com>


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: Jeff Jirsa [mailto:jji...@gmail.com<mailto:jji...@gmail.com>]
Sent: Tuesday, August 1, 2017 3:36 PM

To: user@cassandra.apache.org<mailto:user@cassandra.apache.org>
Subject: Re: Cassandra Data migration from 2.2.3 to 3.7

You can't stream across versions, so you either need to use the native protocol 
(do writes with the normal INSERT operations) or you have to get to the right 
sstable version

That means one of the three of these:

- export to CSV (copy to/copy from, or Brian Hess' Cassandra-loader on github)
- export to CSV and use CQLSSTableWriter to generate sstables you can bulk load
- create a minimal cluster, load the sstables in, and run upgradesstables to 
rev the version and then stop that cluster and stream them into the new cluster


--
Jeff Jirsa


On Aug 1, 2017, at 3:30 PM, Harika Vangapelli -T (hvangape - AKRAYA INC at 
Cisco) <hvang...@cisco.com<mailto:hvang...@cisco.com>> wrote:
Jeff, Thanks for initial pointer. I want to add some more information to it.

This is to migrate from one cluster (2.2 version) to 3.7 . The client who is in 
2.2 cluster they don’t need down time.

So How the data is migrated to new cluster without down time with different 
versions?

Thanks,
Harika





Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com<http://cisco.com>


Think before you print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: Jeff Jirsa [mailto:jji...@gmail.com]
Sent: Tuesday, August 1, 2017 2:48 PM
To: user@cassandra.apache.org<mailto:user@cassandra.apache.org>
Su

RE: Cassandra Data migration from 2.2.3 to 3.7

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Jeff, I tried the below steps for just 3 rows of data, It looks to be working. 
But Confirm me this is right approach.

1.   Taking snapshot (using nodetool snapshot) in the existing cluster (2.2 
cluster)

2.   Bring the snapshot to new cluster and copy in keyspce/table (2.2->3.7)

3.   Nodetool upgrade sstbales on new cluster (3.7)

4.   Use noedtool refresh --   (3.7)
Does this approach work?

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: Jeff Jirsa [mailto:jji...@gmail.com]
Sent: Tuesday, August 1, 2017 3:36 PM
To: user@cassandra.apache.org
Subject: Re: Cassandra Data migration from 2.2.3 to 3.7

You can't stream across versions, so you either need to use the native protocol 
(do writes with the normal INSERT operations) or you have to get to the right 
sstable version

That means one of the three of these:

- export to CSV (copy to/copy from, or Brian Hess' Cassandra-loader on github)
- export to CSV and use CQLSSTableWriter to generate sstables you can bulk load
- create a minimal cluster, load the sstables in, and run upgradesstables to 
rev the version and then stop that cluster and stream them into the new cluster


--
Jeff Jirsa


On Aug 1, 2017, at 3:30 PM, Harika Vangapelli -T (hvangape - AKRAYA INC at 
Cisco) <hvang...@cisco.com<mailto:hvang...@cisco.com>> wrote:
Jeff, Thanks for initial pointer. I want to add some more information to it.

This is to migrate from one cluster (2.2 version) to 3.7 . The client who is in 
2.2 cluster they don’t need down time.

So How the data is migrated to new cluster without down time with different 
versions?

Thanks,
Harika





Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com<http://cisco.com>


Think before you print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: Jeff Jirsa [mailto:jji...@gmail.com]
Sent: Tuesday, August 1, 2017 2:48 PM
To: user@cassandra.apache.org<mailto:user@cassandra.apache.org>
Subject: Re: Cassandra Data migration from 2.2.3 to 3.7

If you upgrade in place:

Stop each node one at a time
Swap binaries
Start each node
Run upgradesstables when all nodes are bounced

If you want to take data from 2.2 and put it into a 3.x cluster, you'll need to 
run upgradesstables on it offline somehow (like clone that 2.2 cluster/schema 
and run it offline with 3.x upgradesstables), then sstableloader it into place

Note that 3.7 is probably not the version you want - 3.11 is probably much more 
stable and solves some serious bugs (or 3.0.14 if you don't need features from 
3.7 ). The one exception to this would be if you're using a 3.7 lts branch 
(like instaclustr had at one point - and may still have).


--
Jeff Jirsa


On Aug 1, 2017, at 2:24 PM, Harika Vangapelli -T (hvangape - AKRAYA INC at 
Cisco) <hvang...@cisco.com<mailto:hvang...@cisco.com>> wrote:
Please help me understand data migration path from 2.2.3 to 3.7.


1.   Tried to take snapshot and load the snapshot using sstableloader; but 
it is throwing Streaming Exception.
Please advise.

Thanks,
Harika






Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com<http://cisco.com>


Think before you print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.

RE: Cassandra Data migration from 2.2.3 to 3.7

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Jeff, Thanks for initial pointer. I want to add some more information to it.

This is to migrate from one cluster (2.2 version) to 3.7 . The client who is in 
2.2 cluster they don’t need down time.

So How the data is migrated to new cluster without down time with different 
versions?

Thanks,
Harika

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: Jeff Jirsa [mailto:jji...@gmail.com]
Sent: Tuesday, August 1, 2017 2:48 PM
To: user@cassandra.apache.org
Subject: Re: Cassandra Data migration from 2.2.3 to 3.7

If you upgrade in place:

Stop each node one at a time
Swap binaries
Start each node
Run upgradesstables when all nodes are bounced

If you want to take data from 2.2 and put it into a 3.x cluster, you'll need to 
run upgradesstables on it offline somehow (like clone that 2.2 cluster/schema 
and run it offline with 3.x upgradesstables), then sstableloader it into place

Note that 3.7 is probably not the version you want - 3.11 is probably much more 
stable and solves some serious bugs (or 3.0.14 if you don't need features from 
3.7 ). The one exception to this would be if you're using a 3.7 lts branch 
(like instaclustr had at one point - and may still have).


--
Jeff Jirsa


On Aug 1, 2017, at 2:24 PM, Harika Vangapelli -T (hvangape - AKRAYA INC at 
Cisco) <hvang...@cisco.com<mailto:hvang...@cisco.com>> wrote:
Please help me understand data migration path from 2.2.3 to 3.7.


1.   Tried to take snapshot and load the snapshot using sstableloader; but 
it is throwing Streaming Exception.
Please advise.

Thanks,
Harika






Harika Vangapelli
Engineer - IT
hvang...@cisco.com<mailto:hvang...@cisco.com>
Tel:

Cisco Systems, Inc.



United States
cisco.com<http://cisco.com>


Think before you print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.

Cassandra Data migration from 2.2.3 to 3.7

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

Please help me understand data migration path from 2.2.3 to 3.7.


1.   Tried to take snapshot and load the snapshot using sstableloader; but 
it is throwing Streaming Exception.
Please advise.

Thanks,
Harika


[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.

Cassandra Node keep going down

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

We are using Cassandra 3.x version..

Recently, our production database is going through some instability issues. One 
of our node is keep going down from every 2 days up to a few of times a day. 
The node is down due to JVM out of memory. According to my investigation, I 
suspect that this might be related to the writing and/or running compaction of 
the large partitions for some of our large data tables. Here's might be what 
had happened
1. The node went OOM due to unable to de-serialize or compacting some large 
partitions under some condition due to memory constrains.
2. Once we re-started it, which was usually a few hours later, the other nodes 
in the cluster were trying to perform the hinted handoff to the down node to 
patch the missing data. From now on, the down node would have to handle handoff 
plus the normal data load, which made it even busier.
3. The node was not able to complete the handoff and went down again.
4. This went again and again.

This was not the first time we're seeing this issue. The last time, we fixed 
the issue by manually stopping some of aggregation jobs for a whole night to 
allow the node to complete the handoff. We're not too sure about the root cause 
yet, and we don't have explanation why this happens only to one node. I 
investigated the issue and found two related JIRAs of Cassandra
https://issues.apache.org/jira/browse/CASSANDRA-8269 and
https://issues.apache.org/jira/browse/CASSANDRA-8723

Both JIRA mentioned that this might only be the case with Cassandra 2.x.

Thanks,

Harika


[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.

Question on configuring Apache Cassandra with LDAP

[Harika Vangapelli -T (hvangape - AKRAYA INC at Cisco)]

I am trying to configure Cassnadra with LDAP , and I am trying to write code 
and want to extend the functionality of 
org.apache.cassandra.auth.PasswordAuthenticator and override authenticate 
method but As PlainTextSaslAuthenticator innerclass has a private scope not 
able to use method overriding.

Please let us know what is the best way to implement LDAP security with Apache 
Cassandra (or) a work around for this.

Thanks,
Harika

[http://wwwin.cisco.com/c/dam/cec/organizations/gmcc/services-tools/signaturetool/images/logo/logo_gradient.png]



Harika Vangapelli
Engineer - IT
hvang...@cisco.com
Tel:

Cisco Systems, Inc.



United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.
Please click 
here for 
Company Registration Information.