Re: Issue with Cassandra consistency in results

rite QUORUM as well. >> >> >> On Mar 16, 2017 1:09 PM, "Ryan Svihla" <r...@foundev.pro> wrote: >> >> Replication factor is 3, and write consistency is ONE and read >> consistency is QUORUM. >> >> That combination is not gonna work w

Re: Issue with Cassandra consistency in results

512.000MiB), cannot allocate chunk of >> 1.000MiB >> WARN [ScheduledTasks:1] 2017-03-14 14:58:37,141 QueryProcessor.java:103 >> - 88 prepared statements discarded in the last minute because cache limit >> reached (32 MB) >> The first api call returns 0 and the api calls later gives right values. >> >> Please let me know, if any other details needed. >> Could you please have a look at this issue once and kindly give me your >> inputs? This issue literally broke the confidence on Cassandra from our >> business team. >> >> Your inputs will be really helpful. >> >> Thank You, >> Regards, >> Srini >> > > > -- Thanks, Ryan Svihla

Re: TransportException - Consistency LOCAL_ONE - EC2

o i guess i need > > Policy policy = new > TokenAwarePolicy(DCAwareRoundRobinPolicy.builder().build(), > false); > > Frank > > On 2017-03-15 13:45 (-), Ryan Svihla <r...@foundev.pro> wrote: > > I don't see what getPolicy is retrieving but you want to use

Re: Change the IP of a live node

56 ? >>> 241f3002-8f89-4433-a521-4fa4b070b704 r1 >>> UN 10.179.xx.xx 3.45 TB256 ? >>> 3b07df3b-683b-4e2d-b307-3c48190c8f1c RAC1 >>> DN 192.168.xx.xx ? 256 ? >>> 19636f1e-9417-4354-8364-6617b8d3d20b r1 >>> DN 192.168.xx.xx? 256 ? >>> 9c65c71c-f5dd-4267-af9e-a20881cf3d48 r1 >>> DN 192.168.xx.xx ? 256 ? >>> ee75219f-0f2c-4be0-bd6d-038315212728 r1 >>> >>> Am I doing anything wrong? Thanks in advance >>> >>> Kind regards, >>> George >>> >> >> > -- Thanks, Ryan Svihla

Re: TransportException - Consistency LOCAL_ONE - EC2

t; for(Host replica : replicaCount.keySet()){ > List allocatedRanges = replicaCount.get(replica); > for(TokenRange tr : replicaCount.get(replica)){ > System.out.println(tr.getStart() + " to " + tr.getEnd()); > } > } > > //get a list of token ranges for thi

Re: TransportException - Consistency LOCAL_ONE - EC2

my questions: > > - Should this happen when Im using consistency level LOCAL_ONE and just > doing reads ? > - Does this suggest non-local reads are happening ? > > Many thanks for any help/ideas. > > Frank > > > -- Thanks, Ryan Svihla

Re: HELP with bulk loading

I suggest using cassandra loader https://github.com/brianmhess/cassandra-loader On Mar 9, 2017 5:30 PM, "Artur R" wrote: > Hello all! > > There are ~500gb of CSV files and I am trying to find the way how to > upload them to C* table (new empty C* cluster of 3 nodes,

Re: A Single Dropped Node Fails Entire Read Queries

ion based on this > message or any information herein. > If you have received this message in error, please advise the sender > immediately by reply email and delete this message. Thank you. > -- Thanks, Ryan Svihla

Re: Disconnecting two data centers

> > We would like to keep both of them for a while but we have a need to > disconnect them. How can this be done? > -- Thanks, Ryan Svihla

Re: Isolation in case of Single Partition Writes and Batching with LWT

It was just the first place google turned up, I made an answer late in the evening trying to help someone out on my own free time. Regards, Ryan Svihla > On Sep 12, 2016, at 6:34 AM, Mark Thomas <ma...@apache.org> wrote: > >> On 11/09/2016 23:07, Ryan Svihla wrote: >>

Re: Isolation in case of Single Partition Writes and Batching with LWT

. Regards, Ryan Svihla > On Sep 11, 2016, at 3:49 PM, Jens Rantil <jens.ran...@tink.se> wrote: > > Hi, > > This might be off-topic, but you could always use Zookeeper locking and/or > Apache Kafka topic keys for doing things like this. > > Cheers, > Jens > >

Re: Read timeouts on primary key queries

Have you looked at cfhistograms/tablehistograms your data maybe just skewed (most likely explanation is probably the correct one here) Regard, Ryan Svihla _ From: Joseph Tech <jaalex.t...@gmail.com> Sent: Wednesday, August 31, 2016 11:16 PM S

Re: Guidelines for configuring Thresholds for Cassandra metrics

thorough testing, all of which I said initially and I still think is a reasonable statement. -regards, Ryan Svihla On Sat, Aug 27, 2016 at 9:31 AM -0500, "Benedict Elliott Smith" <bened...@apache.org> wrote: I did not claim you had no evidence, only that your

Re: Guidelines for configuring Thresholds for Cassandra metrics

that, along with better documentation, so the nuance is accounted for. On Friday, 26 August 2016, Ryan Svihla <r...@foundev.pro> wrote: Forgot the most important thing. LogsERROR you should investigateWARN you should have a list of known ones. Use case dependent. Ideally you change configu

Re: Guidelines for configuring Thresholds for Cassandra metrics

at present but that's a good start -regards, Ryan Svihla On Fri, Aug 26, 2016 at 7:21 AM -0500, "Ryan Svihla" <r...@foundev.pro> wrote: Thomas, Not all metrics are KPIs and are only useful when researching a specific issue or after a use case specific threshold has be

Re: Guidelines for configuring Thresholds for Cassandra metrics

these metrics start to indicate a serious issue is occurring in that particular app. Basically when people notice a problem, what did these numbers look like in the minutes, hours and days prior? That's the way to establish the levels consistently. Regards, Ryan Svihla On Fri, Aug 26, 2

Re: Failure when setting up cassandra in cluster

UPERUSER;" > > Step 10 fails with this error: > > Connection error: ('Unable to connect to any servers', {'127.0.0.1': > AuthenticationFailed(u'Failed to authenticate to 127.0.0.1: code=0100 > [Bad credentials] > message="org.apache.cassandra.exceptions.UnavailableException: Cannot > achieve consistency level QUORUM"',)}) > > > What am I missing? > > > Cheers > > Raimund > > > -- Regards, Ryan Svihla

Re: A question to updatesstables

broken and the version mismatch is a false signal. Regards, Ryan Svihla > On Aug 18, 2016, at 10:18 PM, Lu, Boying <boying...@emc.com> wrote: > > Thanks a lot. > > I’m a little bit of confusing. If the ‘nodetool updatesstable’ doesn’t work > without Cassandra server

Re: A question to updatesstables

lost with this command? >> > It shouldn't if you followed the upgrade instructions properly > >> 3. What’s the best practice to void this error occurs again (e.g. >> upgrading Cassandra next time)? >> > Upgrading SSTables is required or not depending on the upgrade you

Re: Replicating Cassandra data to HDFS

...I'd be curious of your thoughts on how to do that well..maybe I'm missing something. Regards, Ryan Svihla On Aug 9, 2016, 1:13 PM -0500, Jonathan Haddad <j...@jonhaddad.com>, wrote: > I'm having a hard time seeing how anyone would be able to work with CDC in > it's currently im

Re: Replicating Cassandra data to HDFS

an event sourcing pattern, but snapshotting data down to a single record when you encounter it on a read). Best of luck, this is a corner case that requires hard tradeoffs in all technology I've encountered. Regards, Ryan Svihla On Aug 9, 2016, 12:21 PM -0500, Ben Vogan <b...@shopkick.com>,

Re: Replicating Cassandra data to HDFS

you the trouble in case you end up in the same path chasing for something more 'real time'. Regards, Ryan Svihla On Aug 9, 2016, 11:09 AM -0500, Ben Vogan <b...@shopkick.com>, wrote: > Hi all, > > We are investigating using Cassandra in our data platform. We would lik

Re: a solution of getting cassandra cross-datacenter latency at a certain time

The first issue I can think of is the Latency table, if I understand you correctly, has an unbounded size for the partition key of DC and will over time just get larger as more measurements are recorded. Regards, Ryan Svihla > On Aug 8, 2016, at 2:58 AM, Stone Fang <cnstonef...@gma

Re: Mutation of X bytes is too large for the maximum size of Y

). Regards, Ryan Svihla > On Aug 3, 2016, at 4:21 PM, Jonathan Haddad <j...@jonhaddad.com> wrote: > > I haven't verified, so i'm not 100% certain, but I believe you'd get back an > exception to the client. Yes, this belongs in the DB, but I don't think > you're totally bli

Re: Mutation of X bytes is too large for the maximum size of Y

by the time he deploys hit production. Would save everyone a ton of brain cells if we just logged it. Regards, Ryan Svihla > On Aug 3, 2016, at 4:21 PM, Jonathan Haddad <j...@jonhaddad.com> wrote: > > I haven't verified, so i'm not 100% certain, but I believe you'd get back

Re: Mutation of X bytes is too large for the maximum size of Y

Made a Jira about it already https://issues.apache.org/jira/plugins/servlet/mobile#issue/CASSANDRA-12231 Regards, Ryan Svihla > On Aug 3, 2016, at 2:58 PM, Kevin Burton <bur...@spinn3r.com> wrote: > > It seems these are basically impossible to track down. > > https:/

Re: Read gets stale data after failure of commit phase in CAS operation

are you using one of the SERIAL Consistency Levels? -- Ryan Svihla On July 24, 2016 at 8:08:01 PM, Yuji Ito (y...@imagine-orb.com) wrote: > Hi, > > I have another question about CAS operation. > > Can a read get stale data after failure in commit phase? > > According to

Re: My cluster shows high system load without any apparent reason

You aren't using counters by chance? regards, Ryan Svihla On Jul 22, 2016, 2:00 PM -0500, Mark Rose <markr...@markrose.ca>, wrote: > Hi Garo, > > Are you using XFS or Ext4 for data? XFS is much better at deleting > large files, such as may happen after a compaction. If you ha

Re: Questions about anti-entropy repair

nfident I could keep a cluster healthy without running repair consistently. regards, Ryan Svihla On Jul 20, 2016, 10:32 AM -0500, daemeon reiydelle <daeme...@gmail.com>, wrote: > I don't know if my perspective on this will assist, so YMMV: > > Summary > Nodetool repairs are require

Re: Is my cluster normal?

what version of cassandra and java? Regards, Ryan Svihla > On Jul 7, 2016, at 4:51 PM, Yuan Fang <y...@kryptoncloud.com> wrote: > > Yes, here is my stress test result: > Results: > op rate : 12200 [WRITE:12200] > partition rate: 12200

Re: Is my cluster normal?

Lots of variables you're leaving out. Depends on write size, if you're using logged batch or not, what consistency level, what RF, if the writes come in bursts, etc, etc. However, that's all sort of moot for determining "normal" really you need a baseline as all those variables end up

Re: What is the best way to model this JSON ??

Lokesh, The modeling will change a bit depending on your queries, the rate of update and your tooling (Spring-data-cassandra makes a mess of updating collections for example). I suggest asking the Cassandra users mailing list for help since this list is for development OF Cassandra. > On Mar

Re: Keyspaces not found in cqlsh

Kedar, I recommend asking the user list user@cassandra.apache.org this list is for the development of cassandra and you're more likely to find someone on the user list who may have hit this issue. Curious issue though I haven't seen that myself. Regards, Ryan Svihla > On Feb 11, 2016, a

Re: Missing rows while scanning table using java driver

that are leading to this situation, can I suggest you respond on the user list with the following: - Keyspace (RF especially), data center and table configuration. - Any errors in the logs on the Cassandra nodes. Regards, Ryan Svihla > On Feb 2, 2016, at 4:58 AM, Priyanka Gugale <pri...@apac

Re: Modeling nested collection with C* 2.0

Ahmed, Just using text and serializing as Json is the easy way and a common approach. However, this list is for Cassandra commiter discussion, please be so kind as to use the regular user list for data modeling questions or for any future responses to this email thread. Regards, Ryan Svihla

Re: Help diagnosing performance issue

- 015.558 % - Nov 16 14:50 >>>> >>>> The SSTables that come before are all at about 0% and the >>>> ones that >>>> come after it are all at about 15%. >>>> >>>> As you can see the first SSTable at 15% date back from 24h. >>>> Given my >>>> application I'm pretty sure those are not from the reads >>>> (reads of >>>> data older than 1h is definitely under 0.1% of reads). >>>> Could it be >>>> that compaction is putting those in cache constantly ? >>>> If so, then I'm probably confused on the meaning/effect of >>>> max_sstable_age_days (set at 10 in my case) and >>>> base_time_seconds >>>> (not set in my case so the default of 3600 applies). I >>>> would not >>>> expect any compaction to happen beyond the first hour and >>>> the 10 >>>> days is here to make sure data still gets expired and >>>> SSTables >>>> removed (thus releasing disk space). I don't see where the >>>> 24h come >>>> from. >>>> If you guys can shed some light on this, it would be >>>> awesome. I'm >>>> sure I got something wrong. >>>> >>>> Regarding the heap configuration, both are very similar: >>>> * 32G machine: -Xms8049M -Xmx8049M -Xmn800M >>>> * 64G machine: -Xms8192M -Xmx8192M -Xmn1200M >>>> I think we can rule that out. >>>> >>>> Thanks again for you help, I truly appreciate it. >>>> >>>> A. >>>> >>>> On 11/17/2015 08:48 PM, Robert Coli wrote: >>>> >>>> On Tue, Nov 17, 2015 at 11:08 AM, Sebastian Estevez >>>> <sebastian.este...@datastax.com >>>> <mailto:sebastian.este...@datastax.com> >>>> <mailto:sebastian.este...@datastax.com >>>> <mailto:sebastian.este...@datastax.com>> >>>> <mailto:sebastian.este...@datastax.com >>>> <mailto:sebastian.este...@datastax.com> >>>> <mailto:sebastian.este...@datastax.com >>>> <mailto:sebastian.este...@datastax.com>>>> >>>> wrote: >>>> >>>> You're sstables are probably falling out of page >>>> cache on the >>>> smaller nodes and your slow disks are killing your >>>> latencies. >>>> >>>> >>>> +1 most likely. >>>> >>>> Are the heaps the same size on both machines? >>>> >>>> =Rob >>>> >>>> >>>> -- >>>> Antoine Bonavita (anto...@stickyads.tv >>>> <mailto:anto...@stickyads.tv> >>>> <mailto:anto...@stickyads.tv >>>> <mailto:anto...@stickyads.tv>>) - CTO StickyADS.tv >>>> Tel: +33 6 34 33 47 36 <tel:%2B33%206%2034%2033%2047%2036> >>>> <tel:%2B33%206%2034%2033%2047%2036>/+33 9 50 >>>> 68 21 32 <tel:%2B33%209%2050%2068%2021%2032> >>>> NEW YORK | LONDON | HAMBURG | PARIS | MONTPELLIER | MILAN | >>>> MADRID >>>> >>>> >>>> >>>> -- >>>> Antoine Bonavita (anto...@stickyads.tv >>>> <mailto:anto...@stickyads.tv>) - CTO StickyADS.tv >>>> Tel: +33 6 34 33 47 36 <tel:%2B33%206%2034%2033%2047%2036>/+33 9 50 >>>> 68 21 32 <tel:%2B33%209%2050%2068%2021%2032> >>>> NEW YORK | LONDON | HAMBURG | PARIS | MONTPELLIER | MILAN | MADRID >>>> >>>> >>>> >>> >> > -- > Antoine Bonavita (anto...@stickyads.tv) - CTO StickyADS.tv > Tel: +33 6 34 33 47 36/+33 9 50 68 21 32 > NEW YORK | LONDON | HAMBURG | PARIS | MONTPELLIER | MILAN | MADRID > -- Thanks, Ryan Svihla

Re: Is replication possible with already existing data?

t from 12 seconds to 30 seconds. >>> >>> 2) >>> Increasing driver-connect-timeout from 5 seconds to 30 seconds. >>> >>> 3) >>> I have also confirmed that each of the 4 nodes are telnet-able over >>> ports 9042 and 9160 each. >>> >>> >>> Definitely seems to be some driver-issue, since >>> data-persistence/replication works perfect (with any permutation) if >>> data-persistence is done via "cqlsh". >>> >>> >>> Kindly provide some pointers. >>> Ultimately, it is the Java-driver that will be used in production, so it >>> is imperative that data-persistence/replication happens for any downing of >>> any permutation of node(s). >>> >>> >>> Thanks and Regards, >>> Ajay >>> >> >> >> >> -- >> Regards, >> Ajay >> > > > > -- > Regards, > Ajay > -- Thanks, Ryan Svihla

Re: Cassandra Object Mapper - Dynamically pass keyspace value

re 1000's of files it become a big maintenance > issue > > @UDT (keyspace = "complex", name = "address")public class Address { > private String street; > private String city; > private int zipCode; > > -- Thanks, Ryan Svihla

Re: Advice for asymmetric reporting cluster architecture

on the filtered dataset. - Ryan Svihla On Sat, Oct 17, 2015 at 7:12 PM -0700, "Jack Krupansky" <jack.krupan...@gmail.com> wrote: Yes, you can have all your normal data centers with DSE configured for real-time data access and then have a data center that shares the same d

Re: How to read data from local cassandra cluster

Not a Cassandra question so this isn't the right list, but you can just upload the file to CFS and then access it by the path "cfs://filename". However, since you have DSE you may want to contact support for help with pathing in DSE using CFS and Spark. -Ryan Svihla On Fri, Oct 16,

Re: Realtime data and (C)AP

;>> at QUORUM is important. If read is ONE then the read operation *may* >>>> not see important update. The safest option is QUORUM for both write and >>>> read. Then depending on the business or feature the consistency may be >>>> tuned. >>>> >>>> — Brice >>>> ​ >>>> >>> >>> >>> >>> -- >>> Steve Robenalt >>> Software Architect >>> sroben...@highwire.org <bza...@highwire.org> >>> (office/cell): 916-505-1785 >>> >>> HighWire Press, Inc. >>> 425 Broadway St, Redwood City, CA 94063 >>> www.highwire.org >>> >>> Technology for Scholarly Communication >>> >>> >> >> >> -- >> Steve Robenalt >> Software Architect >> sroben...@highwire.org <bza...@highwire.org> >> (office/cell): 916-505-1785 >> >> HighWire Press, Inc. >> 425 Broadway St, Redwood City, CA 94063 >> www.highwire.org >> >> Technology for Scholarly Communication >> >> -- Thanks, Ryan Svihla

Re: Seeing null pointer exception 2.0.14 after purging gossip state

an hour for nodes > that have already successfully decommissioned from the cluster, you can see > from below exception that 10.0.0.1 has been already decommissioned. Below is > the exception snippet. > > Have you done : > > nodetool gossipinfo |grep SCHEMA |sort | uniq -c | sort -n > > and checked for schema agreement... ? > > =Rob > Regards, Ryan Svihla

Re: High read latency

'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne > saurait être recherchée pour tout dommage résultant d'un virus transmis. > > This e-mail and the documents attached are confidential and intended solely > for the addressee; it may also be privileged. If you receive this e-mail in > error, please notify the sender immediately and destroy it. As its integrity > cannot be secured on the Internet, the Worldline liability cannot be > triggered for the message content. Although the sender endeavours to maintain > a computer virus-free network, the sender does not warrant that this > transmission is virus-free and will not be liable for any damages resulting > from any virus transmitted. > > > Regards, Ryan Svihla

Re: memory usage problem of Metadata.tokenMap.tokenToHost

In practice there are not many good reasons to use that many keyspaces and tables. If the use case is multi tenancy then you’re almost always better off just using a combination of version tables and tenantId to give you flexibility as well as separation of client data. If you have that many

Re: To batch or not to batch: A question for fast inserts

s around the other replicas instead of beating up the primary one. However, for a well modeled partition key the approach you outline is probably optimal. > > > > On Fri, Sep 25, 2015 at 7:30 AM, Ryan Svihla <r...@foundev.pro > <mailto:r...@foundev.pro>> wrot

Re: High read latency

oes it take 43ms latency? > > On Fri, Sep 25, 2015 at 7:54 AM, Ryan Svihla <r...@foundev.pro > <mailto:r...@foundev.pro>> wrote: > if you run: > > nodetool cfhistograms > > On the given table and that will tell you how wide your rows are getting. At >

Re: How to tune Cassandra or Java Driver to get lower latency when there are a lot of writes?

iver request 99thPercentile was 90ms during > the load > The java driver took the most time. I knew the Cassandra servers are busy in > writing, but I want to know what kinds of metrics can identify where is the > bottleneck so that I can tune it. > > I’m using Cassandra 2.1.8 and Cassandra Java Driver 2.1.5. > > > Regards, Ryan Svihla

Re: To batch or not to batch: A question for fast inserts

achieve better insertion throughput? > > https://docs.google.com/document/d/1qSIJ46cmjKggxm1yxboI-KhYJh1gnA6RK-FkfUg6FrI > > <https://docs.google.com/document/d/1qSIJ46cmjKggxm1yxboI-KhYJh1gnA6RK-FkfUg6FrI> > > Let me know. > > Kind regards, > > Gerard. > Regards, Ryan Svihla

Re: Is Cassandra really Strong consistency?

echnology. On Mon, Sep 7, 2015 at 6:20 AM, ibrahim El-sanosi <ibrahimsaba...@gmail.com> wrote: > ""It you need strong consistency and don't mind lower transaction rate, > you're better off with base"" > I wish you can explain more how this statment relate to the my post? > Regards, > -- Thanks, Ryan Svihla

Re: Convert joins in RDBMS to Cassandra

4. Solution 2: * >25. >26. 1) Create a map table for every possible join. >27. >28. Drawbacks with this aproach: >29. >30. I think, this is not a right approach. So join to table (map >table) mapping idea is not right. >31. >32. pastebin link for the same: http://pastebin.com/FRAyihPT >33. Please suggest me on this. > > > > -- Thanks, Ryan Svihla

Re: Data Size on each node

currently have a Cassandra Cluster spread over 2 DC. The data size on >>> each node of the cluster is 1.2TB with spinning disk. Minor and Major >>> compactions are slowing down our Read queries. It has been suggested that >>> replacing Spinning disks with SSD might help. Has anybody done something >>> similar? If so what has been the results? >>> Also if we go with SSD, how big can each node get for commercially >>> available SSDs? >>> Regards >>> Sachin >>> >> >> > -- Regards, Ryan Svihla

Re: cassandra scalability

Rack >> UN 40.0.0.208 128.73 KB 248 68.8% >> 6e7788f9-56bf-4314-a23a-3bf1642d0606 RAC1 >> UN 40.0.0.209 114.59 KB 249 67.8% >> 84f6f0be-6633-4c36-b341-b968ff91a58f RAC1 >> UN 40.0.0.205 129.53 KB 245 63.5% >> aa233dc2-a8ae-4c00-af74-0a119825237f RAC1 >> >> the result of the query select * from service_dictionary.table1; gave me >> 70 rows from 40.0.0.205 >> 64 from 40.0.0.209 >> 54 from 40.0.0.208 >> >> 2015-09-07 11:13 GMT+02:00 Edouard COLE <edouard.c...@rgsystem.com>: >> Could you provide the result of : >> - nodetool status >> - nodetool status YOURKEYSPACE >> >> >> > -- Regards, Ryan Svihla

Re: How to prevent queries being routed to new DC?

at LOCAL_* quorum levels, I do not believe those queries should be >>> routed to the new dc. >>> >> >> Other than CASSANDRA-9753, this is true. >> >> https://issues.apache.org/jira/browse/CASSANDRA-9753 (Unresolved; ): >> "LOCAL_QUORUM reads can block cross-DC if there is a digest mismatch" >> >> =Rob >> >> > -- Regards, Ryan Svihla

Re: Querying on multiple columns

f while writing the data. > > > Please let me know if a better solution is available. I am using 2.1.5 > version. > > Regards, > Sam > -- Thanks, Ryan Svihla

Re: Does nodetool repair stop the node to answer requests ?

that if you are operating near failure, repair might trip a node into failure. But if you are operating correctly, repair should not. =Rob -- Morgan SEGALIS -- Thanks, Ryan Svihla

Re: Is there a way to add a new node to a cluster but not sync old data?

and this node only afford new data? -- Thanks, Ryan Svihla

Re: C* throws OOM error despite use of automatic paging

. Does anybody have insights as to what could be happening? Thanks. Mohammed -- Thanks, Ryan Svihla

Re: How to bulkload into a specific data center?

Just noticed you'd sent this to the dev list, this is a question for only the user list, and please do not send questions of this type to the developer list. On Thu, Jan 8, 2015 at 8:33 AM, Ryan Svihla r...@foundev.pro wrote: The nature of replication factor is such that writes will go wherever

Re: How to bulkload into a specific data center?

address. However, I found my jobs were connecting to the REST service data center. How can I specify the data center? -- Thanks, Ryan Svihla

Re: Re: Is it possible to implement a interface to replace a row in cassandra using cassandra.thrift?

and update use the client side timestamp. The update timestamp should be always bigger than the deletion timestamp. I wonder why the update failed in some cases? thank you. - 原始邮件 - 发件人：Ryan Svihla r...@foundev.pro 收件人：user@cassandra.apache.org, yhq...@sina.com 主题：Re

Re:

to explore. Materialized views are your friend, use them freely but as always being mindful of real world constraints and goals. Regards, Nageswara Rao On Tue, Jan 6, 2015 at 10:53 PM, Ryan Svihla r...@foundev.pro wrote: Normal data modeling approach in Cassandra is a separate column family

Re: Are Triggers in Cassandra 2.1.2 performace Hog??

view does a Cassandra Trigger impacts the performance of read/Write of Cassandra. Also any other way you guys achieve this please guide me. I am struck on this . Regards Asit -- Thanks, Ryan Svihla

Re: Cassandra consuming whole RAM (64 G)

, Ryan Svihla

Re: Re: Cassandra update row after delete immediately, and read that, the data not right?

with cassandra?? Thanks! -- Thanks, Ryan Svihla

Re: Implications of ramping up max_hint_window_in_ms

, Ryan Svihla r...@foundev.pro wrote: as long as they know how to handle node recovery and don't inflict return data back from the dead that was deleted. On Tue, Jan 6, 2015 at 12:52 PM, Robert Coli rc...@eventbrite.com wrote: On Tue, Jan 6, 2015 at 7:39 AM, Ryan Svihla r...@foundev.pro wrote

Re: STCS limitation with JBOD?

) by deleting and inserting as a new row. This is not something we would do on a regular basis, but after or during the process a compact would greatly help to clear out tombstones/rewritten data. @Ryan Svihla it also sounds like your suggestion in this case would be: create a new column family

Re: Implications of ramping up max_hint_window_in_ms

as long as they know how to handle node recovery and don't inflict return data back from the dead that was deleted. On Tue, Jan 6, 2015 at 12:52 PM, Robert Coli rc...@eventbrite.com wrote: On Tue, Jan 6, 2015 at 7:39 AM, Ryan Svihla r...@foundev.pro wrote: In general today, large amounts

Re: Question about `nodetool rebuild` finsh

, but there is few network traffic on my new data center nodes. I want to konw _how could I konw when the rebuild finsh_. Thanks all for your reply. -- All the best! http://luolee.me -- Thanks, Ryan Svihla

Re: deletedAt and localDeletion

log. SliceQueryFilter.java (line 225) Read 6 live and 2688 tombstoned cells in ks.mytable (see tombstone_warn_threshold). 10 columns was requested, slices=[-], delInfo={deletedAt=-9223372036854775808, localDeletion= 2147483647} Thanks, -- Thanks, Ryan Svihla

Re: ttl in collections

quickly, having thousands of record updates per second. That left us with a CF containing millions of records that we couldn't select the way we originally intended. Regards, Jens -- Thanks, Ryan Svihla

Re: Is it possible to implement a interface to replace a row in cassandra using cassandra.thrift?

are this way. Inserts are actually UPSERTS and you can go ahead and do two updates instead of insert, delete, update. Thanks. -- Thanks, Ryan Svihla

Re: Implications of ramping up max_hint_window_in_ms

of hints. I personally run with at least a 6 hour max_h_w_i_m. In older versions of Cassandra, 24-48 hours of hints could hose your node via ineffective constant compaction. =Rob -- Thanks, Ryan Svihla

Re:

a super column family which has the key PRIMARY KEY((prodgroup), staus, productid) should work. Would like to get expert advice on other alternatives. -- Thanks, Nageswara Rao.V *The LORD reigns* -- Thanks, Ryan Svihla

Re: Cassandra consuming whole RAM (64 G)

this. On Tuesday, January 6, 2015, Ryan Svihla r...@foundev.pro wrote: Btw side note here, you're using GIANT Batches, and the logs are indicating such, this will cause a signficant amount of heap pressure. The root cause fix is not to use giant batches in the first place. On Tue, Jan 6, 2015 at 4:43 AM

Re: Queries required before data modeling?

when I get a query which I had not thought off? Regards, Seenu. -- Thanks, Ryan Svihla

Re: STCS limitation with JBOD?

. =Rob -- Thanks, Ryan Svihla

Re: Reload/resync system.peers table

here, though I'm not sure if that's just FUD talking... =Rob -- Thanks, Ryan Svihla

Re: [Cassandra] [Generation of SStableLoader slow]

I think that'd be slow copying large files with just the cp command. Cassandra isn't doing anything amazingly strange here, you don't have a lot of RAM, nor CPU and I'm assuming the underlying disk is slow here as well. Without more parameters and details it's hard to define if there is an issue.

Re: 答复:

Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil -- [image: datastax_logo.png] http://www.datastax.com/ Ryan Svihla Solution Architect [image: twitter.png] https://twitter.com/foundev [image: linkedin.png] http://www.linkedin.com/pub/ryan-svihla/12/621

Re: Tombstones without DELETE

an email to java-driver-user+unsubscr...@lists.datastax.com. -- [image: datastax_logo.png] http://www.datastax.com/ Ryan Svihla Solution Architect [image: twitter.png] https://twitter.com/foundev [image: linkedin.png] http://www.linkedin.com/pub/ryan-svihla/12/621/727/ DataStax

Re: [Cassandra] [Generation of SStableLoader slow]

if there is other way to make it faster except adding CPUs and ram. *Best Regards！* *Chao Yan--**My twitter：Andy Yan @yanchao727 https://twitter.com/yanchao727* *My Weibo：http://weibo.com/herewearenow http://weibo.com/herewearenow--* 2014-12-24 20:40 GMT+08:00 Ryan Svihla

Re: CQL3 vs Thrift

again! On Mon, Dec 22, 2014 at 9:50 PM, Ryan Svihla rsvi...@datastax.com wrote: Don't static columns get you what you want? http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/refStaticCol.html On Dec 22, 2014 10:50 PM, David Broyles sj.clim...@gmail.com wrote: Although I used

Re: CQL3 vs Thrift

/total_events (although with potentially many other pieces of static information). More generally, do you find that tuned applications tend to use Thrift, a combination of Thrift and CQL3, or is CQL3 really expected to replace Thrift? Thanks again! On Mon, Dec 22, 2014 at 9:50 PM, Ryan Svihla rsvi

Re: Store counter with non-counter column in the same column family?

You can cheat it by using the non counter column as part of your primary key (clustering column specifically) but the cases where this could work are limited and the places this is a good idea are even more rare. As for using counters in batches are already a not well regarded concept and counter

Re: installing cassandra

are operating at a scale where you need to be able to automate adding new nodes. On Sun, Dec 21, 2014, 8:05 AM Ryan Svihla rsvi...@datastax.com wrote: Puppet, Chef, Ansible and I'm sure many others. I've personally worked with a number of people on all three, a quick google for Puppet Cassandra

Re: Multi DC informations (sync)

information Ryan, I hope I am clear enough while expressing my doubts. C*heers Alain 2014-12-19 15:43 GMT+01:00 Ryan Svihla rsvi...@datastax.com: More accurately,the write path of Cassandra in a multi dc sense is kinda like the following 1. write goes to a node which acts as coordinator 2. writes

Re: CF performance suddenly degraded

There can be many root causes. Would need a lot more information such as node hardware specs, cf histograms on the table, tpstats,GC settings (Max heap, parnew, JVM version) and logs with specifically any ERROR, WARN, or GCInspector messages As a start a simple trace of the query in question is

Re: Connect to C* instance inside virtualbox

] http://www.datastax.com/ Ryan Svihla Solution Architect [image: twitter.png] https://twitter.com/foundev [image: linkedin.png] http://www.linkedin.com/pub/ryan-svihla/12/621/727/ DataStax is the fastest, most scalable distributed database technology, delivering Apache Cassandra to the world’s

Re: Connect to C* instance inside virtualbox

realize it applied in my case. Thanks. On Mon, Dec 22, 2014 at 4:43 PM, Ryan Svihla rsvi...@datastax.com wrote: what is rpc_address set to in cassandra.yaml? my gut is localhost, set it to the interface that communicates between host and guest. On Mon, Dec 22, 2014 at 3:38 PM, Kai Wang dep

Re: Connect to C* instance inside virtualbox

if this helps..what did you change rpc_address to? On Mon, Dec 22, 2014 at 8:15 PM, Ryan Svihla rsvi...@datastax.com wrote: right that's localhost, you have to change it to match the ip of whatever you changed rpc_address too On Mon, Dec 22, 2014 at 8:07 PM, Kai Wang dep...@gmail.com wrote

Re: Connect to C* instance inside virtualbox

connect 127.0.0.1:9042. On Mon, Dec 22, 2014 at 9:01 PM, Ryan Svihla rsvi...@datastax.com wrote: totally depends on how the implementation is handled in virtualbox, I'm assuming you're connecting to an IP that makes sense on the guest (ie nodetool -h 192.168.1.100 and cqlsh 192.168.1.100, replace

Re: Connect to C* instance inside virtualbox

but not both. So I didn't set rpc_addresa. Will double check tomorrow. Thanks. On Dec 22, 2014 9:17 PM, Ryan Svihla rsvi...@datastax.com wrote: if this helps..what did you change rpc_address to? On Mon, Dec 22, 2014 at 8:15 PM, Ryan Svihla rsvi...@datastax.com wrote: right that's localhost

Re: Store counter with non-counter column in the same column family?

) I don't need a 100% accurate count and strong consistency. Performance and application complexity is my main concern. Thanks On Mon, Dec 22, 2014 at 10:37 PM, Ryan Svihla rsvi...@datastax.com wrote: You can cheat it by using the non counter column as part of your primary key (clustering

Re: Store counter with non-counter column in the same column family?

for different query paths and solr. If I switch to Spark, do I still needs to use counter or counting will be done by spark on regular table? On Tue, Dec 23, 2014 at 11:31 AM, Ryan Svihla rsvi...@datastax.com wrote: increment wouldn't be idempotent from the client unless you knew the count

Re: CQL3 vs Thrift

Don't static columns get you what you want? http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/refStaticCol.html On Dec 22, 2014 10:50 PM, David Broyles sj.clim...@gmail.com wrote: Although I used Cassandra 1.0.X extensively, I'm new to CQL3. Pages such as

Re: installing cassandra

wide deployment in the install process already? B. -- [image: datastax_logo.png] http://www.datastax.com/ Ryan Svihla Solution Architect [image: twitter.png] https://twitter.com/foundev [image: linkedin.png] http://www.linkedin.com/pub/ryan-svihla/12/621/727/ DataStax is the fastest, most

Re: Replacing nodes disks

would take to rebuild a 250G data node? Thanks in advance, Or. -- Or Sher -- Or Sher -- Or Sher -- Or Sher -- [image: datastax_logo.png] http://www.datastax.com/ Ryan Svihla Solution Architect [image: twitter.png] https://twitter.com/foundev [image: linkedin.png] http

Re: Drivers performance

: datastax_logo.png] http://www.datastax.com/ Ryan Svihla Solution Architect [image: twitter.png] https://twitter.com/foundev [image: linkedin.png] http://www.linkedin.com/pub/ryan-svihla/12/621/727/ DataStax is the fastest, most scalable distributed database technology, delivering Apache

Re: 答复: Cassandra 2.1.0 Crashes the JVM with OOM with heaps of memory free

] http://www.datastax.com/ Ryan Svihla Solution Architect [image: twitter.png] https://twitter.com/foundev [image: linkedin.png] http://www.linkedin.com/pub/ryan-svihla/12/621/727/ DataStax is the fastest, most scalable distributed database technology, delivering Apache Cassandra to the world’s

Re: Multi DC informations (sync)

exist but I am not aware of it. Any other important information or advice you can give me about best practices or tricks while running a multi DC (cross regions US - EU) is welcome of course ! cheers, Alain -- [image: datastax_logo.png] http://www.datastax.com/ Ryan Svihla Solution

  1   2   >