Re: When to use STCS/DTCS/LCS

+1 Jens, and there is a specific mailing list for developers ( http://cassandra.apache.org/#lists). But it looks like a great move, good luck Divya. C*heers, Alain 2015-04-09 12:44 GMT+02:00 Jens Rantil jens.ran...@tink.se: Divya, Please start a new thread for that. Or is your question

Re: When to use STCS/DTCS/LCS

I guess this give a good idea of when to use one or the other (STCS / LCS), did not hear of DTCS so far... http://www.datastax.com/dev/blog/when-to-use-leveled-compaction C*heers, Alain 2015-04-09 7:09 GMT+02:00 Ajay ajay.ga...@gmail.com: Hi, What are the guidelines on when to use

Re: Reading too many tombstones

Actually what happen is that STC as well as LCS mix old and fresh data during the compaction process. So all the fragments of the same row that you deleted (or reached the TTL of), are spread among multiple sstables. The point is that they need to be gathered all in the same compaction to be

Re: Restoring all cluster from snapshots

I think you just have to do a DESC KEYSPACE mykeyspace; from one node of the production cluster then copy the output and import it in your dev cluster using cqlsh -f output.cql. Take care at the start of the output you might want to change DC names, RF or strategy. Also, if you don't want to

Re: Restoring all cluster from snapshots

Hi, Not sure why this isn't working. Some thoughts, just in case: - Have you check the files rights / owner ? - Have you tried copying files after directory creation through your cqlsh -f schema step ? - Have you tried without setting tokens manually ? - Are you sure to put the right sstables at

Re: After Restart Nodes had lost data

Hi Jean, I had to reboot a node. I killed the cassandra process on that node. You should drain the node before killing java (or using any service stop command). This is not what causes the issue yet it will help you to keep consistence if you use counters, and make the reboot faster in any cases.

Re: Read Consistency

Btw, Hope you'll find the answers you could not ask in today online lesson ;-). C*heers 2015-06-23 20:22 GMT+02:00 Alain RODRIGUEZ arodr...@gmail.com: Hi, I do not agree with Scenario 1 result Arun, The 2 nodes don't have the data yet are available. IMHO what happens next i a slow read

Re: Read Consistency

Hi, I do not agree with Scenario 1 result Arun, The 2 nodes don't have the data yet are available. IMHO what happens next i a slow read since it will have to perform read repair and coordinator will send back the result and an 'OK' message.Consistency is not met when nor enough nodes were up.

Re: Inconsistent behavior during read

Excepted if the node failed to take the write and you have no Hinted Handoff (or for some reason they also failed). Have you tried at QUORUM or even ALL, this would force a synchronous read repair. You can also try to repair directly. Hope this will help, C*heers, Alain 2015-06-25 13:34

Re: Read is slower in 2.1.6 than 2.0.14?

: Yes, our clients didn't specify the port so they are using 9042 by default. On Thu, Jun 25, 2015 at 9:23 AM, Alain RODRIGUEZ arodr...@gmail.com wrote: Hi Zhiyan, 2 - RF 2 will improve overall performance, but not about the result 2.0.* vs 2.1.*. Same comment about adding 3 nodes. Yet

Re: Restore Snapshots

Hi Jean, Answers in line to be sure to be exhaustive: - how can I restore the data directory structure in order to copy my snapshots at the right position? -- making a script to do it and testing it I would say. basically under any table repo you have a snapshots/snapshot_name directory

Re: Read is slower in 2.1.6 than 2.0.14?

that hit rate grew slower than 2.0.14. for 4, we are querying 1 partition key each time. There are 5 rows on average for each partition key. We are using datastax java driver so I guess it is native protocol. We will try out 2.1.7 too. Thanks, Zhiyan On Wed, Jun 24, 2015 at 11:48 PM, Alain

Re: Restore Snapshots

MUCH ALAIN for your support. You really helped me a lot. On 25 Jun,2015, at 18:37, Alain RODRIGUEZ arodr...@gmail.com wrote: Hi Jean, Answers in line to be sure to be exhaustive: - how can I restore the data directory structure in order to copy my snapshots at the right position

Re: Adding Nodes With Inconsistent Data

It looks to me that can indeed happen theoretically (I might be wrong). However, - Hinted Handoff tends to remove this issue, if this is big worry, you might want to make sure HH are enabled and well tuned - Read Repairs (synchronous or not) might have mitigate things also, if you read fresh

Re: [MASSMAIL]Re: Any use-case about a migration from SQL Server to Cassandra?

I guess it is this one, enjoy it: https://labs.spotify.com/2015/06/23/user-database-switch/ :-) 2015-06-24 22:57 GMT+02:00 Marcos Ortiz mlor...@uci.cu: Where is the link, Carlos? On 24/06/15 07:18, Carlos Alonso wrote: This article from Spotify Labs is a really nice write up of migrating

Re: Read is slower in 2.1.6 than 2.0.14?

I am amazed to see that you don't have OOM with this setup... 1 - for performances and given Cassandra replication properties an I/O usage you might want to try with a Raid0. But I imagine this is tradeoff. 2 - A billion is quite a few and any of your nodes takes the full load. You might want to

Re: nodetool repair

Hi, This is not necessarily true. Repair will induce compactions only if you have entropy in your cluster. If not it will just read your data to compare all the replica of each piece of data (using indeed cpu and disk IO). If there is some data missing it will repair it. Though, due to merkle

Re: Mixing incremental repair with sequential

It is not possible to mix sequential repair and incremental repairs. I guess that is a system limitation, even if I am not sure of it (I don't have used C*2.1 yet) I would focus on tuning your repair by : - Monitoring performance / logs (see why the cluster hangs) - Use range repairs (as a

Re: Cassandra Metrics

Hi, +1 for SPM metrics. OpsCenter is also an option. Here is what I wrote about monitoring: http://planetcassandra.org/blog/interview/video-advertising-platform-teads-chose-cassandra-spm-and-opscenter-to-monitor-a-personalized-ad-experience/ C*heers Alain 2015-06-21 3:28 GMT+02:00 Otis

Re: Mixing incremental repair with sequential

, Alain RODRIGUEZ arodr...@gmail.com wrote: It is not possible to mix sequential repair and incremental repairs. I guess that is a system limitation, even if I am not sure of it (I don't have used C*2.1 yet) I would focus on tuning your repair by : - Monitoring performance / logs (see why

Re: Catastrophy Recovery.

Hi, it looks like your starting to use Cassandra. Welcome. I invite you to read from here as much as you can http://docs.datastax.com/en/cassandra/2.1/cassandra/gettingStartedCassandraIntro.html . When a node lose some data you have various anti entropy mechanism Hinted Handoff -- For writes

Re: Question regarding concurrent bootstrapping

Hi Jens, if you are going to dramatically change the number of nodes or for a lot of high movement in tokens you might want to consider DC switching - adding a DC, switching client, dropping old DC. You can use this also for a few other cases like using vnodes, changing their number or even the

Re: Seed Node OOM

Hi, Is your OOM on heap or on native memory ? Since 2.1 put a lot of things on native memory I would say that it is almost always bad to have 6 GB out of 8 for the heap (unless you have a very small data set), since in the 2 GB remaining you have to keep bloom filters, indexes and more + Page

Re: Nodetool ring and Replicas after 1.2 upgrade

Hi Michael, I barely can access internet right now and was not able to check outputs on my computer, yet first thing that come to my mind is that since 1.2.x (and vnodes) I use rather nodetool status instead. What is the nodetool status output ? Also did you try to specify the keyspace ? Since

Re: Minor compaction not triggered

Hi, From what I read there are some issue using DTCS. You should probably go to the last minor version. You should also give more context so people can help. Have you tried a simple restart ? Does it happen on all your nodes ? C*heers, Alain 2015-06-18 11:42 GMT+02:00 Jayapandian Ponraj

Re: Connection reset during repair service

Hi David, Edouard, Depending on your data model on event_data, you might want to consider upgrading to use DTCS (C* 2.0.11+). Basically if those tombstones are due to a a Constant TTL and this is a time series, it could be a real improvement. See:

Re: Connection reset during repair service

: Do you do a ton of random updates amd deletes? That would not be a good workload for DTCS. Where are all your tombstones coming from? On Jun 17, 2015 3:43 AM, Alain RODRIGUEZ arodr...@gmail.com wrote: Hi David, Edouard, Depending on your data model on event_data, you might want

Re: EC2snitch in AWS

By the way, if you need multiple DC on the same region, see dc-suffix in cassandra-rackdc.properties. C*heers, Alain 2015-05-29 11:34 GMT+02:00 Kaushal Shriyan kaushalshri...@gmail.com: Thanks Everyone. I will go through all the links and suggestions and ask here if I have further questions.

Re: Issue when node goes away?

a few nodes to the cluster of the new version, have it settle down, and then upgrade the rest? On Tue, Jun 30, 2015 at 11:58 AM, Alain RODRIGUEZ arodr...@gmail.com wrote: Would it matter that I'm mixing cassandra versions? From: http://docs.datastax.com/en/upgrade/doc/upgrade

Re: Error while adding a new node.

Just check the process owner to be sure (top, htop, ps, ...) http://docs.datastax.com/en/cassandra/2.0/cassandra/install/installRecommendSettings.html#reference_ds_sxl_gf3_2k__user-resource-limits C*heers, Alain 2015-07-01 7:33 GMT+02:00 Neha Trivedi nehajtriv...@gmail.com: Arun, I am

Re: Error while adding a new node.

getting the same error, but after a while. regards Neha On Wed, Jul 1, 2015 at 2:22 PM, Alain RODRIGUEZ arodr...@gmail.com wrote: Just check the process owner to be sure (top, htop, ps, ...) http://docs.datastax.com/en/cassandra/2.0/cassandra/install/installRecommendSettings.html

Re: Cassandra leap second

I think it is more a kernel / java version issue than a Cassandra version related issue. From Datastax: Leap Second on June 30, 2015 Required Actions: Ensure that you are running on kernel version 3.4 or higher and using JDK version 7u60 or higher. This should protect you from the livelock

Re: Experiencing Timeouts on one node

Hi, I am not sure about what is happening (I have never seen this error before). Yet from https://github.com/apache/cassandra/blob/cassandra-1.2/CHANGES.txt it looks like some bugs were fixed in late revision of 1.2.x. I would advice you upgrading to last 1.2.19 (It is an old and stable

Re: Issue when node goes away?

Hi David ? What does a nodetool describecluster output look like ? My guess is you might be having a schema version desynchronisation. If you see a node with different schema version you might want to try a nodetool resetlocal*schema* - Reset node's local *schema* and resync You asked for

Re: Stream failure while adding a new node

Hi David, Are you sure you ran the repair entirely (9 days + repair logs ok on opscenter server) before adding the 10th node ? This is important to avoid potential data loss ! Did you set auto_bootstrap to true on this 10th node ? C*heers, Alain 2015-06-29 14:54 GMT+02:00 David CHARBONNIER

Re: AWS multi-region DCs fail to rebuild

If all the streams are failing it might be due to your VPN tunnel linking the 2 DC or to some port issue, make sur this is ok (Cassandra uses port 7000 for internal communication by default). I am using this exact same setup and never had streaming issues, excepted during some big repairs. I

Re: Nodetool repair with Load times 5

Hi Jean, I might help, but I need to know what you have done recently (change the RF, Add remove node, cleanups, anything else as much as possible...) Also, could you please do the nodetool status *myks* for your keyspace(s) ? We will then be able to know the theoretical ownership of each node

Re: GossipingPropertyFileSnitch vs Ec2Snitch

Hi guys, I am also wondering about this kind of stuff, since we are going out of AWS and were using EC2Snitch. I felt free to write it here, since it looks linked to previous comments. @John, we have been using EC2Snitch for many years, and it just works fine ! Plus, we don't have to keep the

Re: Issue when node goes away?

. Would it matter that I'm mixing cassandra versions? (2.1.4 and 2.1.5)? On Tue, Jun 30, 2015 at 5:23 AM, Alain RODRIGUEZ arodr...@gmail.com wrote: Hi David ? What does a nodetool describecluster output look like ? My guess is you might be having a schema version desynchronisation. If you

Re: cassandra cluster loadbalancing

Hi Sara, I am not sure why you say that this is unbalanced, such small amounts of data are not relevant. It depends of too much factors (keys inserted, compaction that ran or are to run...) You should use nodetool status *myks* to see if your tokens are well distributed - column Owns (effective)

Re: Retrieve all the columnfamily / tables of thrift and CQL from the keyspace in cassandra

Hi I use hector -- This is a very bad idea imho, even more while using C* 2.1. Hector is not maintained for a while and it uses the thrift protocol that allow accessing to limited features with worst performances than native / cql. See

Re: Should maintenance repairs be run on system related keyspaces?

Hi Ken, As the system ks is local and repair is supposed to fix entropy, I would say no... And you now know how to find out the answer for other keyspace you include in system related keyspaces (If local, then no need, else it depends on the fact that some entropy is acceptable or not, but I

Re: Duplicating a cluster with different # of disks

:00 Alain RODRIGUEZ arodr...@gmail.com: Hi Gerard, You should probably add a new datacenter following this procedure : http://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_add_dc_to_cluster_t.html You will just have to make sure to configure all the nodes of the new nodes

Re: Duplicating a cluster with different # of disks

I agree with Jeff, those 2 solution should work well indeed to have distinct cluster (data will be fixed in time, not synchronised). It really depends on you but basically having hybride data storage structures is not an issue at all in both cases as it is something that you can set in the

Re: Duplicating a cluster with different # of disks

Hi Gerard, You should probably add a new datacenter following this procedure : http://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_add_dc_to_cluster_t.html You will just have to make sure to configure all the nodes of the new nodes to use mnt + mnt2 instead of mnt + mnt2 + mnt3.

Re: Compaction Error

Hi Kiran, Nodetool uses 7199 port to connect (JMX). Plus, you might want to precise what keyspace and table you want to compact. http://docs.datastax.com/en/cassandra/2.0/cassandra/tools/toolsNodetool_r.html http://docs.datastax.com/en/cassandra/2.0/cassandra/tools/toolsCompact.html C*heers,

Re: Using TTL in cassandra-stress

I don't know the stress tool that much, but I guess that if you are asking it might be no trivial way to do it. I imagine stress tool creates a table and fill it. You might want to do that once and then alter the table to set a TTL at table level. Once again, you might want to make sure the tool

Re: unsubscribe

>From http://cassandra.apache.org/#lists --> just email user-unsubscr...@cassandra.apache.org Alain 2015-10-14 14:29 GMT+02:00 Amila Paranawithana : > unsubscribe > > On Wed, Oct 14, 2015 at 5:57 PM, Numan Fatih YARCI > wrote: > >> unsubscribe >> >>

Re: Data Distribution in Table/Column Family

Hi, Did you try to run the following on all your nodes and compare ? du -sh /*whatever*/cassandra/data/* Of course if you have unequal snapshots sizes remove them in the above command (or directly remove them). This should answer (barely) your question about an eventual even distribution (/!\

Re: abnormal log after remove a node

Hi, I am facing the same issue on 2.0.16. Did you solve this ? How ? I plan to try a rolling restart and see if gossip state recover from this. C*heers, Alain 2015-06-19 11:40 GMT+02:00 曹志富 cao.zh...@gmail.com: I have a C* 2.1.5 with 24 nodes.A few days ago ,I have remove a node from this

Re: Network / GC / Latency spike

gt; > Could it be wide rows + read repair ? (Let's suppose the "read repair" > repairs the full row, and it may not be subject to stream throughput limit) > > Best Regards > Fabien > > 2015-08-31 15:56 GMT+02:00 Alain RODRIGUEZ <arodr...@gmail.com>: > >

Re: Rebuild new DC nodes against new DC?

Hi Bryan, I have no clear answer to you yet I can give you some insights, my understanding of this. First, I am not sure that nodetool will let you "rebuild" from the DC the node is in. Then this would only work properly (if it works) because you have 3 nodes and a RF of 2 or 3 and so all the

Re: Adding New Nodes/Data Center to an existing Cluster.

Hi Sachin, You are speaking about a repair, when the proper command to do this is "rebuild" ? Did you tried adding your DC this way: http://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_add_dc_to_cluster_t.html ? 2015-09-01 5:32 GMT+02:00 Neha Trivedi :

Re: cassandra scalability

gt;> echo HEAP_NEWSIZE="800M" >> $CONFIG/cassandra-env.sh >> service cassandra stop >> rm -rf /var/lib/cassandra/data/system/* >> service cassandra start >> >> >> >> 2015-09-07 16:30 GMT+02:00 Ryan Svihla <r..

Re: cassandra scalability

Hi Sara, Can you detail actions performed, like how you load data, what scaleup / scaledown are and precise if you let it decommission fully (streams finished, node removed from nodetool status) etc ? This would help us to help you :). Also, what happens if you query using "CONSISTENCY

Re: abnormal log after remove a node

t; > 2015-08-25 18:17 GMT+08:00 Alain RODRIGUEZ <arodr...@gmail.com>: > >> Hi, I am facing the same issue on 2.0.16. >> >> Did you solve this ? How ? >> >> I plan to try a rolling restart and see if gossip state recover from this. >> >> C*h

Re: Upgrade from 2.1.0 to 2.1.9

Hi Tony. Did you read doc on Datastax site --> http://docs.datastax.com/en/upgrade/doc/upgrade/cassandra/upgradeCassandraDetails.html ? This being a minor upgrade I guess clients should not break, but it is often advised to test things, just in case, even more if you never did any update. I

Re: Data Size on each node

Hi, Our migration to SSD (from m1.xl to I2.2xl on AWS) has been a big win. I mean we wen from 80 / 90 % disk utilisation to 20 % max. Basically, bottleneck are not disks performances anymore in our case. We get rid of one of our major issue that was disk contention. I highly recommend you to go

Re: Point upgrades

Hi Stan, Basically restarting a node that is not the one repairing will make repairs fail for the ranges being repaired and that your node is responsible or a replica of. Your repair will continue but will be incomplete (you will see a WARN in the logs off the top of my head). Restarting the node

Re: Network / GC / Latency spike

was triggered when reading a small > portion of a wide row and if it resulted in streaming the whole wide row, > it could explain a network burst. (But, on a second thought it make more > sense to only repair the small portion being read...) > > > > 2015-09-01 12:05 GMT+02:00

Re: Best strategy for hiring from OSS communities.

Hi Kevin, You can try --> https://twitter.com/Cassandra_Jobs Anyway, I saw your message and I imagine other people looking for a job right know did as well already. You can also try to spot people through Linkedin, a few companies contacted me that way too, it might work for you. Then you can

Re: Consistency level ONE and using withLocalDC

nodes in the remote DC. But it will only be used to indeed do a local operation as a fallback if the operation is not using a LOCAL_* consistency level. Sorry I have been so long answering you. --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache

Re: (Full) compaction does not delete (all) old files

rom 2.0.6 to 2.0.17. > then to 2.1.11. Glad to see you did not miss that. I pointed it out, just in case :-). Good luck with this all, C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http://www.thelastpickle.co

Re: Restoring Incremental Backups without using sstableloader

cleanup. But in most cases, all the data won't fit in one node, plus you might have sstable names identical you'll have to handle. Hope that helps, C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http

Re: (Full) compaction does not delete (all) old files

issue. C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http://www.thelastpickle.com 2016-05-17 0:06 GMT+01:00 Dongfeng Lu <dlu66...@yahoo.com>: > Forgive me if that has been answered somewhere, but I could not find a > concise or c

Re: Evict Tombstones with STCS

tter control on disk size and being able to use up to 70% - 80% of the disk, then LCS might be a good option, if it fits with your use case. C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http://www.thelastpickle.com 2016

Re: Upgredesstables doing 4K reads

des have hardware issues of some kind ? C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http://www.thelastpickle.com 2016-06-02 13:43 GMT+02:00 Jacek Luczak <difrost.ker...@gmail.com>: > Hi, > > I

Re: Duplicated key with an IN statement

as much as possible with SQL to avoid loosing people, so we might want to change this. Not sure if this behavior is intentional / known. Not even sure someone ever tried to do this kind of query actually :). Does anyone know about that ? Should we raise a ticket ? - Alain Rodriguez

Re: Any tips on how to track down why Cassandra won't cluster?

.) <-- probably your case - Ports (firewall, AWS rules...) <-- telnet might be useful here - Seeds being differents on the nodes <-- make sure that your seeds are the same on every node Hope this will be enough to get you out of this, C*heers, - Alain Rodriguez

Re: Clustering key values not distributed

no answer :-). Let us know how it goes. C*heers, ----- Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-02 8:55 GMT+00:00 Ralf Steppacher <ralf.viva...@gmail.com>: > I am trying to get the stress tool to generate random values for three &g

Re: About cassandra's reblance when adding one or more nodes into the existed cluster?

ssandra/2.1/cassandra/configuration/configCassandra_yaml_r.html#reference_ds_qfg_n1r_1k__streaming_socket_timeout_in_ms ). C*heers, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-01-27 2:12 GMT+01:00 土卜皿 <pengcz.n...@gmail.com>: > Hi Alain an

Re: why one of the new added nodes' bootstrap is very slow?

tml I would advise you to read documentation on datastax website, it will save you a lot of time and troubles imho. Even if I am glad to help. C*heers, ----- Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-01-27 14:11 GMT+01:00 土卜皿 <pengcz.n...@gmail.com>:

Re: Rename Keyspace offline

be useful to you. One last warning, it was written to be compatible with my environment, you might adjust a few things or improve the code to have anything you need as an option. Feel free to do whatever you want with this code. Anyway, you have the logic in there at least. C*heers, --

Re: why one of the new added nodes' bootstrap is very slow?

er or not and the environment / things you did, etc. Good luck C*heers, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-01-28 2:57 GMT+01:00 土卜皿 <pengcz.n...@gmail.com>: > Hi Alain, > Thank you very much! > > >> UJ 192.21

Re: Reenable data access after temporarily moving data out of data directory

Hi Jason, nodetool refresh should be ok. You can also restart the node. Both should work. C*heers, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-24 7:07 GMT+01:00 Jason Kania <jason.ka...@ymail.com>: > Hi, > > I encou

Re: Cassandra Data Audit

specific (AFAIK). C*heers, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-24 11:41 GMT+01:00 Raman Gugnani <raman.gugn...@snapdeal.com>: > Hi Alain, > > As per the document. Which column of the dse_audit.audit_log will hold > the pr

Re: Replacing disks

I wrote that a few days ago: http://thelastpickle.com/blog/2016/02/25/removing-a-disk-mapping-from-cassandra.html I believe this might help you. C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http <h

Re: Reenable data access after temporarily moving data out of data directory

ow what kind of error you have, what version of cassandra you use, what your hardware is, what parameters are set for JVM / GC (cassandra-env.sh), etc... Hope this is is clear and helpful. C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache

Re: Cassandra nodes reduce disks per node

For what it is worth, I finally wrote a blog post about this --> http://thelastpickle.com/blog/2016/02/25/removing-a-disk-mapping-from-cassandra.html If you are not done yet, every step is detailed in there. C*heers, --- Alain Rodriguez - al...@thelastpickle.com Fra

Re: Cassandra nodes reduce disks per node

You're welcome, if you have some feedback you can comment the blog post :-). C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http://www.thelastpickle.com 2016-02-25 12:28 GMT+01:00 Anishek Agarwal <anis...@gmail.

Re: Too many sstables with DateTieredCompactionStrategy

? 5. How do you run repairs (tool & command)? C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http://www.thelastpickle.com 2016-02-29 15:50 GMT+01:00 Noorul Islam Kamal Malmiyoda <noo...@noorul.com>: >

Re: Cassandra Data Audit

pen source version though. C*heers, ----- Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-24 6:36 GMT+01:00 Charulata Sharma (charshar) <chars...@cisco.com>: > To all Cassandra experts out there, > > Can you please let me kn

Re: Getting error while issuing Cassandra stress

Hi, The the exact command you ran (stress-tool with options) could be useful to help you on that. However, Im able to create keyspace, tables and insert data using cqlsh and > it is replicating fine to all the nodes. Having the schema might be useful too. Did you ran the cqlsh and the

Re: Getting error while issuing Cassandra stress

gt; >>>>>>> >>>>>>> <http://www.datastax.com/gartner-magic-quadrant-odbms> >>>>>>> >>>>>>> DataStax is the fastest, most scalable distributed database >>>>>>> technology, delivering Apache Cassan

Re: Getting error while issuing Cassandra stress

; telnet 10.41.55.18 7000 # connects > telnet 10.41.55.18 9160 # connects > But telnet to JMX port is not working > telnet 10.41.55.18 7199 # doesnt connect > Trying 10.41.55.18... > telnet: connect to address 10.41.55.18: Connection refused > > Could this be the reason? >

Re: About cassandra's reblance when adding one or more nodes into the existed cluster?

ill have to run *nodetool cleanup *on all the nodes which have had their range reduced (node impacted + replicas) which is also long and potentially heavy to. - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-01-26 5:19 GMT+01:00 土卜皿 <pengcz.n...@gmail.com

Re: How to make the new cassandra cluster balanced after adding one or more nodes?

Hi Dillon, I advise you to keep writing in the same thread as long as it is about the same issue, to avoid spreading information. I answered your first email :-). C*heers, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-01-26 6:50 GMT+01:00 土卜皿

Re: opscenter doesn't work with cassandra 3.0

, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-01-26 16:42 GMT+01:00 Otis Gospodnetić <otis.gospodne...@gmail.com>: > Hi Duyhai, > > SPM is not free, but there is a free plan, plus we have special pricing > for startups, non-profits, and education inst

Re: Getting error while issuing Cassandra stress

gt; Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com >>>>>>>> >>>>>>>> [image: linkedin.png] <https://www.linkedin.com/company/datastax> >>>>>>>> [image: >>>>>>>> facebook.png]

Re: Can't bootstrap a node

ers before connecting them as described in https://issues.apache.org/jira/browse/CASSANDRA-9956 ? Anything else that could be related (any schema changes during the bootstrap) ? C*heers, ----- Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-12 22:51 GMT+01:00 Bria

Re: Do I have to use repair -inc with the option -par forcely?

-inc ." So you should be able to remove -par. Not sure this will solve your issue though. Did you respect this process to migrate to incremental repairs? https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/opsRepairNodesMigration.html#opsRepairNodesMigration__ol_dxj_gp5_2s C*he

Re: Re : decommissioned nodes shows up in "nodetool describecluster" as UNREACHABLE in 2.1.12 version

which seems to be your case, it should be safe to use it in your case). I only used it to fix gossip status in the past or at some point when forcing a removenode was not working, followed by full repairs on remaining nodes. C*heers, - Alain Rodriguez France The Last Pickle http:/

Re: Debugging write timeouts on Cassandra 2.2.5

believe a: 'nodetool cfstats | grep -e 'Table:' -e 'Local'' should give you a rough idea of local latencies. Those are just things I would check, I have not a clue on what is happening here, hope this will help. C*heers, - Alain Rodriguez France The Last Pickle http

Re: Cassandra nodes reduce disks per node

knife (Chef), I hate to repeat ops, this is something you might want to consider. Hope this is useful, C*heers, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-18 8:28 GMT+01:00 Anishek Agarwal <anis...@gmail.com>: > Hey Branton, > > P

Re: How Cassandra reduce the size of stored data ?

sandra/configuration/configCassandra_yaml.html#configCassandra_yaml__commonProps-ph - for client / server communication --> http://docs.datastax.com/en/drivers/java/3.0/com/datastax/driver/core/ProtocolOptions.Compression.html C*heers, ----- Alain Rodriguez France The Last Pi

Re: Cassandra nodes reduce disks per node

e or if some things might be improved. C*heers, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-19 7:19 GMT+01:00 Branton Davis <branton.da...@spanning.com>: > Jan, thanks! That makes perfect sense to run a second time before > stopping ca

Re: Live upgrade 2.0 to 2.1 temporarily increases GC time causing timeouts and unavailability

are a lot better than thrift starting in C* 2.1. Drivers using native are also more modern allowing you to do very interesting stuff. Updating to native now that you are using 2.1 is something you might want to do soon enough :-). C*heers, - Alain Rodriguez France The Last Pickle http

Re: Increase compaction performance

Also, are you using incremental repairs (not sure about the available options in Spotify Reaper) what command did you run ? 2016-02-11 17:33 GMT+01:00 Alain RODRIGUEZ <arodr...@gmail.com>: > CPU load is fine, SSD disks below 30% utilization, no long GC pauses > > > >

Re: Increase compaction performance

hput X C*heers, ----- Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-11 16:55 GMT+01:00 Michał Łowicki <mlowi...@gmail.com>: > Hi, > > Using 2.1.12 across 3 DCs. Each DC has 8 nodes. Trying to run repair using > Cassandra Reaper but nod

Re: moving keyspaces to another disk while Cassandra is running

FWIW: http://thelastpickle.com/blog/2016/02/25/removing-a-disk-mapping-from-cassandra.html I know it is not exactly what you want, but I believe it might be useful. C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting

<    1   2   3   4   5   6   7   >