Re: AWS ephemeral instances + backup

We have some tooling that does that kind of thing using S3 rather than attached EBS but a similar principle. There is a bit of an overview here: https://www.instaclustr.com/advanced-node-replace/ It's become a pretty core part of our ops toolbox since we introduced it. Cheers Ben --- *Ben

Re: Aws instance stop and star with ebs

The logs between first start and handshaking should give you a clue but my first guess would be replaying commit logs. Cheers Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr> <https://twitter.com/inst

Re: Cassandra-stress testing

any useful response from the community. Cheers Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclustr> Read our latest t

Re: Cassandra-stress testing

://www.instaclustr.com/certified-apache-cassandra/ Cheers Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclustr> Read our latest technica

Re: high write latency on a single table

Is the size of the data in your “state” column variable? The higher write latencies at the 95%+ could line up with large volumes of data for particular rows in that column (the one column not in both tables)? Cheers Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.

Re: CL=LQ, RF=3: Can a Write be Lost If Two Nodes ACK'ing it Die

and the two nodes dieing (although it’s very likely there will be three replicas from the start if the cluster is in a healthy state at the time of the write). Cheers Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr&

Re: CL=LQ, RF=3: Can a Write be Lost If Two Nodes ACK'ing it Die

or many not have made its way to the third node by the time the first two replicas are lost. If there is a replica on the third node it can be recovered to the other two nodes by either rebuild (actually replace) or repair. Cheers Ben --- *Ben Slater**Chief Product Officer* <ht

Re: CL=LQ, RF=3: Can a Write be Lost If Two Nodes ACK'ing it Die

In scenario 2, if the row has been written to node 3 it will be replaced on the other nodes via rebuild or repair. --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr> <https://twitter.com/inst

Re: different query result after a rerun of the same query

monitor the dropped mutations metrics. Cheers Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclustr> Read our latest t

Re: different query result after a rerun of the same query

, changes in topology without following proper procedure, etc. Cheers Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclu

Re: different query result after a rerun of the same query

inserted (relative to your attempt to query it)? Cheers Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclustr> Read our lat

Re: A cluster (RF=3) not recovering after two nodes are stopped

Ben --- *Ben Slater**Chief Product Officer* <https://www.instaclustr.com/platform/> <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclustr> Read our latest technical blog posts here <https

Re: A cluster (RF=3) not recovering after two nodes are stopped

Is it possible that stress is overloading node 1 so it’s not recovering state properly when node 2 comes up? Have you tried running with a lower load (say 2 or 3 threads)? Cheers Ben --- *Ben Slater* *Chief Product Officer* <https://www.facebook.com/instaclustr> <https://tw

Re: ***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

Maybe stabledump can help you? https://cassandra.apache.org/doc/4.0/tools/sstable/sstabledump.html --- *Ben Slater* *Chief Product Officer* <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclustr> Read our lat

Re: ***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

Not in the logs but I think you should be able to use the WRITETIME function to view via CQL (see https://cassandra.apache.org/doc/latest/cql/dml.html#select) Cheers Ben --- *Ben Slater* *Chief Product Officer* <https://www.facebook.com/instaclustr> <https://twitter.com/instaclust

Re: How to read the Index.db file

They don’t do exactly what you want but depending on why you are trying to get this info you might find our sstable-tools useful: https://github.com/instaclustr/cassandra-sstable-tools --- *Ben Slater* *Chief Product Officer* <https://www.facebook.com/instaclustr> <https://tw

Re: Authenticate cassandra-stress with cqlshrc

Yep, cassandra-stress doesn’t attempt to use the cqlshrc file. Seems to me it could be convenient so might make a nice contribution to the project. Cheers Ben --- *Ben Slater* *Chief Product Officer* <https://www.facebook.com/instaclustr> <https://twitter.com/instaclust

Re: Authenticate cassandra-stress with cqlshrc

(in which case I don’t think there is one but stress has a hell of a lot of options so I could be wrong). Cheers Ben --- *Ben Slater* *Chief Product Officer* <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclustr>

Re: Cassandra single unreachable node causing total cluster outage

In what way does the cluster become unstable (ie more specifically what are the symptoms)? My first thought would be the loss of the node causing the other nodes to become overloaded but that doesn’t seem to fit with your point 2. Cheers Ben --- *Ben Slater* *Chief Product Officer* <ht

Re: [EXTERNAL] Is Apache Cassandra supports Data at rest

of a destructive nature, which may be contained in this attachment > and shall not be liable for direct, indirect, consequential or special > damages in connection with this e-mail message or its attachment. > -- *Ben Slater* *Chief Product Officer <https://www.instaclustr.com/>*

Re: Multiple cluster for a single application

ts to table X would go to cluster Y >>> 2. shard data at loader level by some business logic grouping of data, >>> for example all rows with some column starting with X would go to cluster Y >>> >>> I would appreciate sharing your experiences working with big clusters, >>> pr

Re: [ANNOUNCE] StratIO's Lucene plugin fork

wledge about the plugin we'd be grateful for any > assistance! > > You can find our fork here: > https://github.com/instaclustr/cassandra-lucene-index > At the moment, the only difference is that there is a 3.11.3 branch which > just has some minor changes to dependencies to bett

Re: cold vs hot data

ils sent to PDF e-mail accounts will be archived and may > be scanned by us and/or by external service providers to detect and prevent > threats to our systems, investigate illegal or inappropriate behavior, > and/or eliminate unsolicited promotional e-mails (“spam”). If you have any > concerns

Re: Secure data

tore in kms >>> or vault. If any of you already configured please direct me to >>> documentation for it. >>> >> > > -- > Jon Haddad > http://www.rustyrazorblade.com > twitter: rustyrazorblade > -- *Ben Slater* *Chief Product Officer <https://www

Re: Re: [EXTERNAL] full text search on some text columns

> Date : Wed, 01 Aug 2018 08:16:06 +0430 > Subject : Re: [EXTERNAL] full text search on some text columns > Forwarded message > > Maybe this plugin could do the job: > https://github.com/Stratio/cassandra-lucene-index > > On Tue, 31 Jul 2018 at 2

Re: Timeout for only one keyspace in cluster

D crc_check_chance = 1.0 >> >> AND dclocal_read_repair_chance = 0.1 >> >> AND default_time_to_live = 0 >> >> AND gc_grace_seconds = 864000 >> >> AND max_index_interval = 2048 >> >> AND memtable_flush_period_in_ms = 0

Re: Certified Cassandra for Enterprise use

: > Is there any third party who provides security patches/releases for Apache > cassandra > > For Enterprise use is there any third party who provides certified Apache > cassandra packages ?? > > Thanks > Pranay > -- *Ben Slater* *Chief Product Officer <https://

Re: Interesting Results - Cassandra Benchmarks over Time Series Data for IoT Use Case I

results > and how we can possibly improve this and share widely. > [1] Cassandra Benchmarks over Time Series Data for IoT Use Case > <https://sites.google.com/an10.io/timeseries-results> >https://sites.google.com/an10.io/timeseries-results > > > -- > Regards, > Arbab Khal

Re: Basic Copy vs Snapshot for backup

gt; *Virus Warning:* Although the company has taken reasonable precautions to > ensure no viruses are present in this email. The company cannot accept > responsibility for any loss or damage arising from the use of this email or > attachment." > -- *Ben Slater* *Chief Product Officer <

Re: Does Cassandra supports ACID txn

add/remove into/from tables hotels_by_poi/poi_by_hotel. So, here my >> assumption is these operations would need to be atomic( and may be >> supporting other ACID properties) . How these kind of operations/usecases >> being handled in Cassandra/NoSQL world? >> >> Appreciate

Re: read repair with consistency one

r consistency ONE read repair is >> not performed. Does it mean that in my case read repair does not work at >> all? Is there any way to enable read repair across DCs and stay will >> consistency ONE for reads? >> >> >> #1 https://www.datastax.com/dev/blog/com

Re: Does Cassandra supports ACID txn

’s >>> either done or not done. In case of timeout you won’t have a way to >>> know if it worked or not. >>> >>> There is no way to rollback a statement/batch, the only way is to send >>> an update to modify the partition to its previous state. >&

Re: Cassandra client tuning

??! > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > ---- On Sun, 18 Mar 2018 13:14:54 +0330 *Ben Slater > <ben.sla...@instaclustr.com <ben.sla...@instaclustr.com>>* wrote > > When you say batch was worth than async in terms of throughput ar

Re: Cassandra client tuning

executeAsync in case of throughput but much less > CPU usage at client side. > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > On Sun, 18 Mar 2018 12:46:02 +0330 *Ben Slater > <ben.sla...@instaclustr.com <ben.sla...@instaclustr.com>>* wrote &g

Re: Cassandra client tuning

keys and > i can't use createSStable mechanism. Is there any tuning which i'm missing > in client side, cause the server side is already tuned with datastax > recomendations. > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > -- *Ben Slater* *Chief Product

Re: cassandra spark-connector-sqlcontext too many tasks

enario and only a few KBs > for javaFunctions scenario > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > > -- *Ben Slater* *Chief Product Officer <https://www.instaclustr.com/>* <https://www.facebook.com/instaclustr> <https://twitter.com/instac

Re: Amazon Time Sync Service + ntpd vs chrony

ps? > > > > Thanks, > > Kyrill > > > > > --------- > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > > --

Re: backup/restore cassandra data

tes...@zoho.com> wrote: > Would it be possible to copy/paste Cassandra data directory from one of > nodes (which Its OS partition corrupted) and use it in a fresh Cassandra > node? I've used rf=1 so that's my only chance! > > Sent using Zoho Mail <https://www.zoho.com/mail/

Re: One time major deletion/purge vs periodic deletion

requently > (run the job weekly??) > > > > Some estimates on the number of deletes performed would be…upto 80-90K > rows purged in 3 months vs 10K deletes every week ?? > > > > Thanks, > > Charu > > > > -- > > Jens Rantil > Backend Developer

Re: Cassandra/Spark failing to process large table

why my replicas were not in sync before? > > Thanks, > Faraz > > On Sun, Mar 4, 2018 at 9:46 AM, Ben Slater <ben.sla...@instaclustr.com> > wrote: > >> Both CQLSH and the Spark Cassandra query at consistent level ONE >> (LOCAL_ONE for Spark connector) by defau

Re: Cassandra/Spark failing to process large table

Executor.java:1142) >> ~[na:1.8.0_131] >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> [na:1.8.0_131] >> at java.lang.Thread.run(Thread.java:748) [na:1.8.0_131] >> >> *Versions:* >> >>

Re: Cassandra Needs to Grow Up by Version Five!

we all >>> remember fondly. >>> > >> >>> > > >>> > >Let’s keep some perspective. Most of us came to Cassandra from rdbms >>> > worlds where we were building solutions out of a bunch of master/slave >>> > MySQL / Postgres type

Re: Meltdown/Spectre Linux patch - Performance impact on Cassandra?

the named > addressee or an authorized designee, you may not copy or use it, or > disclose it to anyone else. If you received it in error please notify us > immediately and then destroy it. Dynatrace Austria GmbH (registration > number FN 91482h) is a company registered in Linz whose regist

Re: How quickly we can bootstrap

ow quickly we can scale is another thing to consider. > > > > > > > > > -- > *C*heers,* > *Anshu V* > > > -- *Ben Slater* *Chief Product Officer <https://www.instaclustr.com/>* <https://www.facebook.com/instaclustr> <https://twitter.com/

Re: Creating a copy of a C* cluster

s? > > Thanks in advance > > Robert > > > - > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > -- *Ben Slater

Re: Cassandra UNREACHABLE node

eMessages(IncomingTcpConnection.java:178) > ~[apache-cassandra-3.9.0.jar:3.9.0] > at > org.apache.cassandra.net.IncomingTcpConnection.run(IncomingTcpConnection.java:92) > ~[apache-cassandra-3.9.0.jar:3.9.0] > No error in /var/log/cassandra/debug.php on 10.0.0.12 > > Remembe

Re: Manual Repairs

abase Administrator > > *mfurl...@ancestry.com <mfurl...@ancestry.com>* > M: 801-859-7427 <(801)%20859-7427> > > O: 801-705-7115 <(801)%20705-7115> > > 1300 W Traverse Pkwy > > Lehi, UT 84043 > > > > > > ​ > [image: image003.p

Re: Long running compaction on huge hint table.

t;>> On May 16, 2017, at 7:58 AM, varun saluja <saluj...@gmail.com> >>>> wrote: >>>> >>>> >>>> >>>> Hi Nitan, >>>> >>>> >>>> >>>> Thanks for response. >>>> >>>> >>

Re: Consistency Level vs. Retry Policy when no local nodes are available

It certainly seems like a bug to me or at least something that should be improved. -Shannon -- *Ben Slater* *Chief Product Officer <https://www.instaclustr.com/>* <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/c

Re: Slow repair

1,3529019003015169892]] finished (progress: 31%) > [2017-03-15 06:03:15,440] Repair session > aae06160-0943-11e7-9c1f-f5ba092c6aea for range > [(-7542303048667795773,-7300899534947316960]] finished (progress: 34%) > [2017-03-15 06:03:17,786] Repair completed successfully > [2017-03-15 06:03

Re: Read after Write inconsistent at times

intermittently. Both write and read use LOCAL QUOROM. > > We have a cluster of 12 nodes which spans across 2 Data Centers and a RF > of 3. > > Has anyone encountered this problem and if yes what steps have you taken > to solve it > > Thanks, > Charu > -- *Ben Slater*

Re: Pluggable throttling of read and write queries

We've never tried this approach and given my limited experience I would > find this a terrible idea from the perspective of maintenance (remember the > old saying about basket and eggs?) > > What potential benefits do you see? > > Regards, > -- > Alex > > --

Re: DELETE/SELECT with multi-column PK and IN

gt; > Yes, thats the workaround - I'll try that. > > Would you agree it would be better for internal optimizations to process > this within a single statement? > > 2017-02-09 10:32 GMT+01:00 Ben Slater <ben.sla...@instaclustr.com>: > > Yep, that makes it clear. I think an

Re: DELETE/SELECT with multi-column PK and IN

it clear: > > DELETE FROM ks.cf WHERE (partitionkey1, partitionkey2) IN ((1, 2), (1, > 3), (2, 3), (3, 4)); > > If want to delete or select a bunch of records identified by their > multi-partitionkey tuples. > > 2017-02-09 10:18 GMT+01:00 Ben Slater <ben.sla...@i

Re: DELETE/SELECT with multi-column PK and IN

7161 304880-6 <+49%207161%203048806> · Fax +49 7161 304880-1 > <+49%207161%203048801> > AG Ulm · HRB 731058 · Managing Director: Jens Kammerer > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Current data density limits with Open Source Cassandra

ifferent data storage > format, is that 3-5TB still a valid limit? > > Does anyone have experience on running Cassandra with 3-5TB compressed > data ? > > Cheers, > Hannu -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: [RELEASE] Apache Cassandra 3.10 released

sandra-3.11 > branch in git. > > Enjoy! > > [1]: (CHANGES.txt) https://goo.gl/J0VghF > [2]: (NEWS.txt) https://goo.gl/00KNVW > [3]: https://issues.apache.org/jira/browse/CASSANDRA > > > Great job all on this release. > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Query

I wasn’t familiar with Gizzard either so I thought I’d take a look. The first things on their github readme is: *NB: This project is currently not recommended as a base for new consumers.* (And no commits since 2013) So, Cassandra definitely looks like a better choice as your datastore for a new

Re: Cassandra cluster performance

t;*; > > > > - yes, the client is on separate VM > > - In our project we use Cassandra API version 3.0.2 but the database > (cluster) is version 3.9 > > - for 2node cluster: > > first VM: 25 GB RAM, 16 CPUs > > second VM: 16 GB RAM, 16 CPUs >

Re: Cassandra cluster performance

You would expect some drop when moving to single multiple nodes but on the face of it that feels extreme to me (although I’ve never personally tested the difference). Some questions that might help provide an answer: - what consistency level are you using for the test? - what is your keyspace

Re: All nodes hosting replicas down

And I’m not aware of any case where it’s a good idea to use SimpleStrategy in Prod (be interested to hear if anyone else knows of one). NetworkTopologyStrategy behaves the same as SimpleStrategy in the basic case of one DC and Rack but gives you a good path to migrate to more sophisticated

Re: Single cluster node restore

You can have situations where rebuilding a node via streaming is painful and slow (generally because there is something bad about the data model like misused secondary indexes or massive partitions). Also, overstreaming can mean you need more disk space to bootstrap a node than you’ll require once

Re: Does recovery continue after truncating a table?

> I think it's definitely a bug to be solved asap. > > >Ben > What do you mean "an undocumented limitation" ? > > Thanks, > Hiro > > On Sat, Nov 26, 2016 at 3:13 PM, Ben Slater <ben.sla...@instaclustr.com> > wrote: > > Nice det

Re: Does recovery continue after truncating a table?

Nice detective work! Seems to me that it’s a best an undocumented limitation and potentially could be viewed as a bug - maybe log another JIRA? One node - there is a nodetool truncatehints command that could be used to clear out the hints (

Re: generate different sizes of request from single client

If targetting two different tables for the different sizes works then I’ve submitted a patch for cassandra-stress that allows you to do that: https://issues.apache.org/jira/browse/CASSANDRA-8780 It would be nice to see someone else test it if you have the appetite to build it and try it out.

Re: failure node rejoin

rejoin. > Or should I be more careful to add failure nodes to the existing cluster? > > Thanks, > yuji > > > On Fri, Nov 11, 2016 at 1:00 PM, Ben Slater <ben.sla...@instaclustr.com> > wrote: > > From a quick look I couldn’t find any defects other than the ones you’ve &g

Re: cassandra python driver routing requests to one node?

What load balancing policies are you using in your client code ( https://datastax.github.io/python-driver/api/cassandra/policies.html)? Cheers Ben On Mon, 14 Nov 2016 at 16:22 Andrew Bialecki wrote: > We have an odd situation where all of a sudden of our cluster

Re: failure node rejoin

ferent from that of 3.0?) > > Do you know other bug fixes related to commitlog? > > Regards > yuji > > On Wed, Nov 9, 2016 at 11:34 AM, Ben Slater <ben.sla...@instaclustr.com> > wrote: > > There have been a few commit log bugs around in the last couple of months

Re: failure node rejoin

down because > consistency levels was serial. > If the flush failed on more than one node, the test would retry step 2.) > However, if so, the problem would happen without deleting Cassandra data. > > Regards, > yuji > > > On Mon, Oct 24, 2016 at 8:37 AM, Ben Slater <ben.

Re: large number of pending compactions, sstables steadily increasing

What I’ve seen happen a number of times is you get in a negative feedback loop: not enough capacity to keep up with compactions (often triggered by repair or compaction hitting a large partition) -> more sstables -> more expensive reads -> even less capacity to keep up with compactions -> repeat

Re: Is it a memory issue?

a48e-11e6-b985-979fea8d6099Compaction cargts > eventdata.eventdata_event_time_idx 32098562606 42616107664 bytes > 75.32% > Active compaction remaining time : 0h11m12s > > > *From:* Ben Slater <ben.sla...@instaclustr.com> > *Date:* 2016-11-07 11:4

Re: Is it a memory issue?

This sounds to me like your writes go ahead of compactions trying to keep up which can eventually cause issues. Keep an eye on nodetool compactionstats if the number of compactions continually climbs then you are writing faster than Cassandra can actually process. If this is happening then you

Re: Commercial Support Providers?

I can confirm that we do offer support contracts for OSS Apache Cassandra at Instaclustr (in addition to our managed service) - either drop me an email direct (signature below) or contact sa...@instaclustr.com and would be happy to discuss details. Cheers Ben On Fri, 4 Nov 2016 at 14:02 Max C

Re: Lightweight transaction inside a batch : request rejected

= > > Le 25 oct. 2016 07:15, "Ben Slater" <ben.sla...@instaclustr.com> a écrit : > > Move item_id_by_key into a collection field in item table? (Would > probably be a “better” C* data model anyway.) > > On Tue, 25 Oct 2016 at 16:08 Mickael Delanoë <delanoe.

Re: Lightweight transaction inside a batch : request rejected

Move item_id_by_key into a collection field in item table? (Would probably be a “better” C* data model anyway.) On Tue, 25 Oct 2016 at 16:08 Mickael Delanoë wrote: > Ok, I understand, thanks. > So now i would like to know if there is some best practices to do what i >

Re: failure node rejoin

ed the test without killing nodes. > I'll report the result to you next Monday. > > Thanks > > > On Fri, Oct 21, 2016 at 3:05 PM, Ben Slater <ben.sla...@instaclustr.com> > wrote: > > Just to confirm, are you saying: > a) after operation 2, you select all and get 1000 rows &

Re: Hadoop vs Cassandra

It’s reasonably common to use Cassandra to cover both online and analytics requirements, particularly using it in conjunction with Spark. You can use Cassandra’s multi-DC functionality to have online and analytics DCs for a reasonable degree of workload separation without having to build ETL (or

Re: What is the maximum value of Cassandra Counter Column?

http://cassandra.apache.org/doc/latest/cql/types.html?highlight=counter#counters On Sun, 23 Oct 2016 at 19:15 Kant Kodali wrote: > where does it say counter is implemented as long? > > On Sun, Oct 23, 2016 at 1:13 AM, Ali Akhtar wrote: > > Probably: >

Re: failure node rejoin

? Cheers Ben On Fri, 21 Oct 2016 at 17:00 Yuji Ito <y...@imagine-orb.com> wrote: > > Are you certain your tests don’t generate any overlapping inserts (by > PK)? > > Yes. The operation 2) also checks the number of rows just after all > insertions. > > > On Fri, Oc

Re: failure node rejoin

tency level is SERIAL > > > On Fri, Oct 21, 2016 at 12:04 PM, Ben Slater <ben.sla...@instaclustr.com> > wrote: > > > A couple of questions: > 1) At what stage did you have (or expect to have) 1000 rows (and have the > mismatch between actual and expected) - at that e

Re: failure node rejoin

s the test need any operation when C* node is restarted? (Currently, I > just restarted C* process) > > Regards, > > > On Tue, Oct 18, 2016 at 2:18 PM, Ben Slater <ben.sla...@instaclustr.com> > wrote: > > OK, that’s a bit more unexpected (to me at least) but I think

Re: failure node rejoin

otstrapping). > > That means once the data dir is wiped, it's going to start again without a > bootstrap, and make a single node cluster or join an existing cluster if > the seed list is valid > > > > -- > Jeff Jirsa > > > On Oct 17, 2016, at 8:51 PM, Ben Slater &l

Re: failure node rejoin

If in any case the failure node is gone for a while, what you need > to do is to is remove the node first before doing "rejoin". > > Cheers, > > Yabin > > On Mon, Oct 17, 2016 at 1:48 AM, Ben Slater <ben.sla...@instaclustr.com> > wrote: > > To cassandra, th

Re: failure node rejoin

celling join..." > > I'm not sure this causes data lost. All data can be read properly just > after this rejoin. > But some rows are lost when I kill C* for destructive tests after > this rejoin. > > Thanks. > > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Re: ask for help about exmples of Data Types the document shows

My best guess it that you need to remove the quotes from around the zip values (ie change if to zip: 20500 rather than zip: ‘20500’ ) as zip is defined as an int. Cheers Ben On Wed, 28 Sep 2016 at 14:38 zha...@easemob.com <zha...@easemob.com> wrote: > Hi, Ben Slater, thank you

Re: ask for help about exmples of Data Types the document shows

} > 'work' : { > street: '1600 Pennsylvania Ave NW', > city: 'Washington', > zip: '20500', > phones: { 'fax' : { country_code: 1, number: '...' } } > } > }) > &g

Re: crash with OOM

y due to: > java.lang.OutOfMemoryError: Java heap space > ERROR [SharedPool-Worker-157] 2016-09-26 20:51:14,124 Message.java:538 - > Unexpected exception during request; channel = [id: 0xce43a388, / > 13.13.13.80:55536 :> /13.13.13.149:9042] > > My server has total 256G memory

Re: Exceptions whenever compaction happens

0.9.jar:3.0.9] > at > org.apache.cassandra.service.StorageProxy$LocalReadRunnable.runMayThrow(StorageProxy.java:1797) > ~[apache-cassandra-3.0.9.jar:3.0.9] > at > org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:2466) > ~[apache-cas

Re: Question about replica and replication factor

same data center. >> Replication factor RF is set to 3 and the consistency level is default 1. >> According to this calculator http://www.ecyrd.com/cassandracalculator/, >> every node will store 50% of the data. >> >> When I want to read all data from the clust

Re: Question about replica and replication factor

ead from, 2 or 1? Is it 2, because each node has half data? But in the > calculator it show 1: You are really reading from 1 node every time. > >Any suggestions? Thanks! > > Jun > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Export/Importing keyspace from a different sized cluster

ts opened from source to target cluster to run > sstableloader, what methods can I use to load a single keyspace from one > cluster to another cluster of different size? > > > > Appreciate the help… > > > > Thanks, > > Justin > > > -- Ben Sla

Re: Streaming Process: How can we speed it up?

r Cassandra streaming is a work in progress - being able to send >> more than one file at a time is probably the most obvious area for >> improvement, and being able to better deal with the CPU / garbage generated >> on the receiving side is just behind that. You'll likely be able to stre

Re: ServerError: An unexpected error occurred server side; in cassandra java driver

zed(NioEventLoop.java:505) > at > io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:419) > at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:391) > at > io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112) > at java.lang.Thread.run(Thread.java:745) > > Thanks > Siddharth > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Read Repairs and CL

pair_chance and speculative_retry > options. THe main gotcha is global read repair (via read_repair_chance) > which will trigger cross-dc repairs at CL ALL in the case of a digest > mismatch, even if the requested CL is DC-local. > > > On Sun, Aug 28, 2016 at 11:55 AM, Ben Slater <ben.sl

Re: Bootstrapping multiple C* nodes in AWS

ful to hear > your experiences here. > > Thanks > > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Read Repairs and CL

e (since CL=ALL) implies that the CL for the read during the read repair > is based off the CL of the query. However I don't think that makes sense at > other CLs. Anyway, I just want to clarify what CL the read for the read > repair occurs at for cases where the overall query CL is not ALL. > >

Re: [Marketing Mail] Re: Memory leak and lockup on our 2.2.7 Cassandra cluster.

y the safest upgrade is 2.1 to 3.0.x > > Best, > > Romain > > > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Memory leak and lockup on our 2.2.7 Cassandra cluster.

; -Dcom.sun.management.jmxremote.ssl=false >> -Dcom.sun.management.jmxremote.authenticate=false >> -Djava.library.path=/usr/share/cassandra/lib/sigar-bin >> -XX:+UnlockCommercialFeatures >> -XX:+FlightRecorder >> -Dlogback.configurationFile=logback.xml >> -Dcassandra.logdir=/var/log/cassandra >> -Dcassandra.storagedir= >> -Dcassandra-pidfile=/var/run/cassandra/cassandra.pid >> >> >> -- >> >> We’re hiring if you know of any awesome Java Devops or Linux Operations >> Engineers! >> >> Founder/CEO Spinn3r.com >> Location: *San Francisco, CA* >> blog: http://burtonator.wordpress.com >> … or check out my Google+ profile >> <https://plus.google.com/102718274791889610666/posts> >> >> > > > -- > > We’re hiring if you know of any awesome Java Devops or Linux Operations > Engineers! > > Founder/CEO Spinn3r.com > Location: *San Francisco, CA* > blog: http://burtonator.wordpress.com > … or check out my Google+ profile > <https://plus.google.com/102718274791889610666/posts> > > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Re : Purging tombstones from a particular row in SSTable

ul 27, 2016 at 4:05 PM, DuyHai Doan <doanduy...@gmail.com> >>> wrote: >>> >>> This feature is also exposed directly in nodetool from version Cassandra >>> 3.4 >>> >>> >>> >>> nodetool compact --user-defined >>> >>> >>> >>> On Wed, Jul 27, 2016 at 9:58 PM, Vinay Chella <vche...@netflix.com> >>> wrote: >>> >>> You can run file level compaction using JMX to get rid of tombstones in >>> one SSTable. Ensure you set GC_Grace_seconds such that >>> >>> >>> >>> current time >= deletion(tombstone time)+ GC_Grace_seconds >>> >>> >>> >>> File level compaction >>> >>> >>> >>> /usr/bin/java -jar cmdline-jmxclient-0.10.3.jar - localhost: >>> >>> ​{​ >>> >>> ​port} >>> >>> org.apache.cassandra.db:type=CompactionManager >>> forceUserDefinedCompaction="'${KEYSPACE}','${ >>> >>> ​SSTABLEFILENAME >>> >>> }'"" >>> >>> >>> >>> >>> >>> >>> >>> >>> On Wed, Jul 27, 2016 at 11:59 AM, sai krishnam raju potturi < >>> pskraj...@gmail.com> wrote: >>> >>> hi; >>> >>> we have a columnfamily that has around 1000 rows, with one row is >>> really huge (million columns). 95% of the row contains tombstones. Since >>> there exists just one SSTable , there is going to be no compaction kicked >>> in. Any way we can get rid of the tombstones in that row? >>> >>> >>> >>> Userdefined compaction nor nodetool compact had no effect. Any ideas >>> folks? >>> >>> >>> >>> thanks >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> >> > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

Re: Is my cluster normal?

>> >>>>> >>>>> *Daemeon C.M. ReiydelleUSA (+1) 415.501.0198 >>>>> <%28%2B1%29%20415.501.0198>London (+44) (0) 20 8144 9872 >>>>> <%28%2B44%29%20%280%29%2020%208144%209872>* >>>>> >>>>> On Thu, Jul 7, 2016 at 1:25 PM, Yuan Fang <y...@kryptoncloud.com> >>>>> wrote: >>>>> >>>>>> >>>>>> >>>>>> I have a cluster of 4 m4.xlarge nodes(4 cpus and 16 gb memory and >>>>>> 600GB ssd EBS). >>>>>> I can reach a cluster wide write requests of 30k/second and read >>>>>> request about 100/second. The cluster OS load constantly above 10. Are >>>>>> those normal? >>>>>> >>>>>> Thanks! >>>>>> >>>>>> >>>>>> Best, >>>>>> >>>>>> Yuan >>>>>> >>>>>> >>>>> >>>> >>> >> > -- Ben Slater Chief Product Officer Instaclustr: Cassandra + Spark - Managed | Consulting | Support +61 437 929 798

  1   2   >