Re: Connection refused - 127.0.0.1-Gossip

I tried setting it up with pod ip, but it did not help. From: "ZAIDI, ASAD A" Reply-To: "user@cassandra.apache.org" Date: Wednesday, December 6, 2017 at 8:45 PM To: "user@cassandra.apache.org" Subject: RE: Connection refused - 127.0.0.1-Gossip Throwing my $ .002 Rpc_address defaults to local

Huge system.batches table after joining a node (Cassandra 3.11.1)

Hi, after joining a node into an existing cluster, the table system.batches became quite large (100GB) which is about 1/3 of the nodes size. Is it safe to truncate the table? Regards, Christian

run Cassandra on physical machine

Dear All, Can we run Cassandra on physical machine directly? we all know that vm can reduce the performance.For instance,we have a machine with 56 core,8 ssd disks. Can we run 8 cassandra instance in the same machine within one rack with different port? Could anyone please advise? Thanks, P

Re: Node crashes on repair (Cassandra 3.11.1)

I think we’ve hit the Bug described here: https://issues.apache.org/jira/browse/CASSANDRA-14096 Regards, Christian Von: Christian Lorenz Antworten an: "user@cassandra.apache.org" Datum: Freitag, 1. Dezember 2017 um 10:04 An: "user@cassandra.apache.org" Betreff: Re: Node crashes on repair (Cas

Re: run Cassandra on physical machine

On Thu, Dec 7, 2017 at 6:12 AM, Peng Xiao <2535...@qq.com> wrote: > Dear All, > > Can we run Cassandra on physical machine directly? > we all know that vm can reduce the performance.For instance,we have a > machine with 56 core,8 ssd disks. > Can we run 8 cassandra instance in the same machine with

Re: run Cassandra on physical machine

Hello, Yes, you can. Best, Oliver On Thu, Dec 7, 2017 at 7:12 AM, Peng Xiao <2535...@qq.com> wrote: > Dear All, > > Can we run Cassandra on physical machine directly? > we all know that vm can reduce the performance.For instance,we have a > machine with 56 core,8 ssd disks. > Can we

Re: Huge system.batches table after joining a node (Cassandra 3.11.1)

Hi Christian, it is probably not safe to drop it because it contains all logged batches that are supposed to be played on the cluster. The size of the batches table should go down as they get processed (although 100GB is a pretty huge batch log...) Do you use Materialized Views in your data model

Re: Huge system.batches table after joining a node (Cassandra 3.11.1)

Hi Alexander, yes we use MV’s. The size of the batch table is around 10GB on the existing nodes. Also seems pretty high. So is this table (also) used to process MV building? Regards, Christian Von: Alexander Dejanovski Antworten an: "user@cassandra.apache.org" Datum: Donnerstag, 7. Dezember 20

Re: Huge system.batches table after joining a node (Cassandra 3.11.1)

Yes, MVs use batches during bootstraps and decommissions. You can read more about it here : https://issues.apache.org/jira/browse/CASSANDRA-13065 and here : https://issues.apache.org/jira/browse/CASSANDRA-13614 Things will improve in 4.0 only it seems. On Thu, Dec 7, 2017 at 4:31 PM Christian Lo

Re: Huge system.batches table after joining a node (Cassandra 3.11.1)

Just a heads up that (in case you missed it) MVs were retroactively marked as experimental and that a large part of the community considers they should not be used in production. On Thu, Dec 7, 2017 at 4:53 PM Alexander Dejanovski wrote: > Yes, MVs use batches during bootstraps and decommissions

RE: When Replacing a Node, How to Force a Consistent Bootstrap

Thank you. How do I identify what other 2 nodes the former downed node replicated with? A replica set of 3 nodes A,B,C. Now, C has been terminated by AWS and is gone. Using the getendpoints assumes knowing a partition key value, but how do you even know what key to use? If there is a way to id

Re: run Cassandra on physical machine

@Peng, how many network interfaces do you have on your machine? If you just have one NIC, you probably need to wait this storage port patch. https://issues.apache.org/jira/browse/CASSANDRA-7544 . On Thu, Dec 7, 2017 at 7:01 AM, Oliver Ruebenacker wrote: > > Hello, > > Yes, you can. > >

Re: Some problems with Apache Cassandra

Reposting to user@ from dev@ On Thu, Dec 7, 2017 at 4:27 AM, v.elis...@rubic.pro wrote: > Hello, my name is Vladimir and I have questions on Cassandra DMBS. > > > *1 PROBLEM. How to increase the speed?* > I installed this system from the repository: > "deb http://www.apache.org/dist/cassandra/d

Re: run Cassandra on physical machine

Which is to say, right now you can't run them on different ports, but you can run them on different IPs on the same machine (and different IPs dont need different physical NICs, you can bind multiple IPs to a given physical NIC). On Thu, Dec 7, 2017 at 10:54 AM, Dikang Gu wrote: > @Peng, how ma

RE: ClassNotFoundException when trigger is fired

Hi, Thanks for your replay. I put jar file under conf/triggers before starting Cassandra then I could found following log INFO [OptionalTasks:1] 2017-11-30 03:55:43,541 CustomClassLoader.java:87 - Loading new jar /home/tnarita/cassandra/conf/triggers/TestTrigger.jar It looks like my jar files

Re: Tombstone warnings in log file

Hello Simon. Tombstone is a tricky topic in Cassandra that brought a lot of questions over time. I exposed my understanding in a blog post last year and thought it might be of interest for you, even though things probably evolved a bit, principles and tuning did not change that much I guess. Here

Re: ClassNotFoundException when trigger is fired

Can you open a JIRA please, would be great if you have a trivial trigger to help us repro (so whoever goes to fix it doesnt need to write a fake trigger class)? https://issues.apache.org/jira/browse/CASSANDRA On Thu, Dec 7, 2017 at 10:34 AM, tsubasa.nar...@us.fujitsu.com < tsubasa.nar...@us.fujit

Reg:- Data modelling For E-Commerce Pattern data modelling for Search

Hi Peoples, As currently around the world 60-70% websites are excelling with E-commerce in which we have to store huge amount of data and select pattern based on Partial Search, Text match, Full-Text Search and all. So below questions comes to mind : 1) Is Cassandra a correct choice for data mode

Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search

1. No, Apache Cassandra is pretty terrible for search on it’s own. Even with SASI. 2. Maybe, but it’s complicated, and doing it right takes a lot of experience. I’d use Elastic Search instead. > On Dec 7, 2017, at 5:39 PM, @Nandan@ wrote: > > Hi Peoples, > > As currently around the world

about write performance

There is a table with a timestamp as a cluster key and sorted by ASC for the column. Is it better to insert by the time order when inserting data into this table for insertion performance? Or does it matter? Thank you.

Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search

Hi Jon, Do you mean Elastic search for storing data or Data should be store into Cassandra and use Elastic Search for Select records from tables. ? On Fri, Dec 8, 2017 at 9:50 AM, Jon Haddad wrote: > 1. No, Apache Cassandra is pretty terrible for search on it’s own. Even > with SASI. > 2. Mayb

Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search

I mean ES is great as a search engine. I would use Cassandra as my source of truth, and also index my data in ES. I typed my original message before I walked my dog, I should have also pointed out https://github.com/strapdata/elassandra and https://gi

Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search

Thanks. But again my questions come back at the same place that how to do data modeling because If we will do denormalized then we have to allow a lot of data duplication, as well as Insert and Update, will also need to think because based on this we have to insert data into multiple tables at sam

Re: Reg:- Data modelling For E-Commerce Pattern data modelling for Search

You’re going to have duplicate data no matter what you do. Creating indexes is another representation of the data, it’s not free. Yes, storing it in two places is more work, but I’ve typically had to do that anyways. My search queries are almost never an exact match to my Cassandra data mod

Re: Running repair while Cassandra upgrade 2.0.X to 2.1.X

Hi Can someone please answer this query? Thanks On Wed, Dec 6, 2017 at 9:58 AM, shini gupta wrote: > If we have upgraded Cassandra binaries from 2.0 to 2.1 on ALL the nodes > but upgradesstable is still pending, please provide the impact of following > scenarios: > > > > 1. Running nodetool rep

?????? run Cassandra on physical machine

Thanks All. -- -- ??: "Jeff Jirsa";; : 2017??12??8??(??) 3:19 ??: "cassandra"; : Re: run Cassandra on physical machine Which is to say, right now you can't run them on different ports, but you can run them on different IP

Re: about write performance

On Fri, Dec 8, 2017 at 3:05 AM, Eunsu Kim wrote: > There is a table with a timestamp as a cluster key and sorted by ASC for > the column. > > Is it better to insert by the time order when inserting data into this > table for insertion performance? Or does it matter? > The writes hit memory table