Re: Which compaction strategy when modeling a dumb set

2017-02-27 Thread Vladimir Yudovin
Do you also store events in Cassandra? If yes, why not to add "processed" flag to existing table(s), and fetch non-processed events with single SELECT? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Fri, 24 Feb 2017 06:24:09 -0500 Vincent Ri

Re: Backups eating up disk space

2017-02-27 Thread Vladimir Yudovin
Yes, you can. It's just hardlinks to tables files, so if some file is still active it will remain intact. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 27 Feb 2017 09:27:50 -0500 Kunal Gangakhedkar kgangakhed...@gmail.com wrote Hi all

Re: Re: Cassandra listen port

2016-10-05 Thread Vladimir Yudovin
as well (look at the end of cassandra-env.sh). Best regards, Vladimir Yudovin, Winguzone Inc - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Wed, 05 Oct 2016 01:46:33 -0400 Mehdi Bada mehdi.b...@dbi-services.com wrote Be sure, it's for. Test

Re: Re: Cassandra listen port

2016-10-04 Thread Vladimir Yudovin
or not, etc. Can you give more detail about your network environment? Best regards, Vladimir Yudovin, Winguzone Inc - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Tue, 04 Oct 2016 14:03:42 -0400 Mehdi Bada mehdi.b...@dbi-services.com wrote Thanks

Re: Re: Cassandra listen port

2016-10-04 Thread Vladimir Yudovin
not demand. Best regards, Vladimir Yudovin, Winguzone Inc - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Tue, 04 Oct 2016 14:51:59 -0400 Benjamin Roth benjamin.r...@jaumo.com wrote Of course, just add aliases to your interfaces (like eth0:0

Re: Understanding cassandra data directory contents

2016-10-08 Thread Vladimir Yudovin
Each table has unique id (suffix). If you drop and then recreate table with the same name it gets new id. Try SELECT keyspace_name, table_name, id FROM system_schema.tables ; to determinate actual ID. You can limit request to specific keyspace or table. Best regards, Vladimir Yudovin

Re: Re: JVM safepoints, mmap, and slow disks

2016-10-08 Thread Vladimir Yudovin
Page cache is data pending flush to disk and data cached from disk. Do you mean file cache? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Sat, 08 Oct 2016 13:40:19 -0400 Ariel Weisberg ar...@weisberg.ws

Re: Ordering by multiple columns?

2016-10-08 Thread Vladimir Yudovin
Yes, look at this example. But you need to add 'fake' partition with the same value for all rows, that will cause them to be stored on the same nodes. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Sat, 08

Re: Missing table suffix in data directory directories

2016-10-09 Thread Vladimir Yudovin
Probably those without suffix were created by previous Cassandra version (somewhere in 2.x series) Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Sun, 09 Oct 2016 01:58:07 -0400 Jason Kania jason.ka

Re: Do partition keys create skinny or wide rows?

2016-10-08 Thread Vladimir Yudovin
: code=2200 [Invalid query] message="Partition key parts: id2 must be restricted as other parts are" Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Sun, 09 Oct 2016 00:27:12 -0400 Graham Sandersongra..

Re: Re: Cassandra listen port

2016-10-04 Thread Vladimir Yudovin
-a-development-tool-for-creating-local-cassandra-clusters Best regards, Vladimir Yudovin, Winguzone Inc - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Tue, 04 Oct 2016 15:36:23 -0400 Mehdi Bada mehdi.b...@dbi-services.com wrote I want to run

Re: Cassandra listen port

2016-10-04 Thread Vladimir Yudovin
Actually the main port is 9042 - for client (CQL) connections and 7000 (7001 if SSL enabled) for inter node communications. Best regards, Vladimir Yudovin, Winguzone Inc - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Tue, 04 Oct 2016 11:36:04 -0400

Re: Efficient model for a sorting

2016-10-04 Thread Vladimir Yudovin
Hi Benjamin! we now use CS 3.x and have been advised that 3.x is still not considered really production ready. Did you consider using of 3.0.9? Actually it's 3.0 with almost an year fixes. Best regards, Vladimir Yudovin, Winguzone Inc - Hosted Cloud Cassandra on Azure and SoftLayer. Launch

Re: Efficient model for a sorting

2016-10-04 Thread Vladimir Yudovin
Would you consider 3.0.x to be more stable than 3.x? I guess yes, but there are some discussion on this list: (C)* stable version after 3.5 Upgrade from 3.0.6 to 3.7. It seems to be eternal topic till tick-tock approach stabilizes. Best regards, Vladimir Yudovin, Winguzone Inc - Hosted

Re: when taking backups using snapshot if the sstable gets compacted will nodetool snapshot hung ??

2016-10-04 Thread Vladimir Yudovin
? Best regards, Vladimir Yudovin, Winguzone Inc - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes.

Re: JVM safepoints, mmap, and slow disks

2016-10-07 Thread Vladimir Yudovin
Hi Josh, Running with increased heap size would reduce GC frequency, at the cost of page cache. Actually it's recommended to run C* without virtual memory enabled. So if there is no enough memory JVM fails instead of blocking Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra

Re: High Usage of Survivor Space

2016-10-27 Thread Vladimir Yudovin
Hi, did this high memory usage caused the problems? OOM crashes, GC pauses? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 26 Oct 2016 21:51:26 -0400Daniel Kleviansky dan...@kleviansky.com wrote Before anyone

Re: Improving performance where a lot of updates and deletes are required?

2016-11-08 Thread Vladimir Yudovin
Yes, as doc says "Expired data is marked with a tombstone" but you save communication with host and processing of DELETE operator. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Tue, 08 Nov 2016 09:32:16 -0500

Re: A difficult data model with C*

2016-11-08 Thread Vladimir Yudovin
entry: UPDATE recent SET review = review - [(1234,12345)] WHERE user_name='some user' AND video_id='great video'; Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 07 Nov 2016 21:54:08 -0500ben ben diamond@outlook.com

Re: 答复: A difficult data model with C*

2016-11-09 Thread Vladimir Yudovin
(user_name text PRIMARY KEY, play_list LISTfrozenplay); You can easily retrieve play list for specific user by his ID. Instead of LIST you can use MAP, I don't think that for ten entries it matters. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster

Re: Having Counters in a Collection, like a map<int, counter>?

2016-11-09 Thread Vladimir Yudovin
ire creating 1 table per type of mapint, counter that i need? But you don't need to create separate table per each counter, just use one row per counter: CREATE TABLE cnt (id int PRIMARY KEY , value counter); Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch you

Re: Having Counters in a Collection, like a map<int, counter>?

2016-11-09 Thread Vladimir Yudovin
s it will be changed, if not - created set to initial value. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 09 Nov 2016 07:52:29 -0500Ali Akhtar ali.rac...@gmail.com wrote The only issue with the last 2 soluti

Re: Log traces of debug logs

2016-11-09 Thread Vladimir Yudovin
Hi, you can change log level with nodetool setlogginglevel command Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 09 Nov 2016 10:17:37 -0500Benjamin Roth benjamin.r...@jaumo.com wrote Hi! Is there a way

Re: Improving performance where a lot of updates and deletes are required?

2016-11-08 Thread Vladimir Yudovin
The deletes will be done at a scheduled time, probably at the end of the day, each day. Probably you can use TTL? http://docs.datastax.com/en/cql/3.1/cql/cql_using/use_expire_c.html Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes

Re: Designing a table in cassandra

2016-11-08 Thread Vladimir Yudovin
own table for each device can be quite heavy solution. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 06 Nov 2016 19:23:20 -0500sat sathish.al...@gmail.com wrote Hi, We are new to Cassandra. For our POC, we

Re: store individual inventory items in a table, how to assign them correctly

2016-11-08 Thread Vladimir Yudovin
Hi, can you elaborate a little your data model? Would you like to create 100 rows for each product and then remove one row and add this row to customer? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 07 Nov 2016 14:51

Re: operation and maintenance tools

2016-11-08 Thread Vladimir Yudovin
For memory usage you can use small command line tool https://github.com/patric-r/jvmtop Also there are number of GUI tools that connect to JMX port, like jvisualvm Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 07 Nov

Re: Can a Select Count(*) Affect Writes in Cassandra?

2016-11-10 Thread Vladimir Yudovin
) are caused by memory flushes? Shalom Sagges DBA T: +972-74-700-4035 We Create Meaningful Connections On Thu, Nov 10, 2016 at 11:02 AM, Vladimir Yudovin vla...@winguzone.com wrote: This message may contain confidential and/or privileged information

Re: Can a Select Count(*) Affect Writes in Cassandra?

2016-11-10 Thread Vladimir Yudovin
Hi Shalom, so not sure, but probably excessive memory consumption by this SELECT causes C* to flush tables to free memory. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 10 Nov 2016 03:36:59 -0500Shalom Sagges shal

Re: 答复: 答复: A difficult data model with C*

2016-11-10 Thread Vladimir Yudovin
Do you mean the oldest one should be removed when a new play is added? Sure. As you described the issue "the last ten items may be adequate for the business" Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 09 N

Re: quick question

2016-10-19 Thread Vladimir Yudovin
com/dev/blog/dynamic-snitching-in-cassandra-past-present-and-future Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 19 Oct 2016 06:14:27 -0400Kant Kodali k...@peernova.com wrote can Cassandra cluster direct or load bal

Re: How to insert "Empty" timeuuid by Cql

2016-10-19 Thread Vladimir Yudovin
Hi, what does it exactly mean 'empty timeuuid'? UUID takes 16 bytes for storage, so it should be either null, or some value. Do you mean 'zero' UUID? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 19 Oct 2016 09:16:29

Re: time series data model

2016-10-20 Thread Vladimir Yudovin
(or opposite, heading.speed) and save column storage overhead. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 20 Oct 2016 03:29:16 -0400wxn...@zjqunshuo.com wrote Hi All, I'm trying to migrate my time series data

Re: Inserting list data

2016-10-14 Thread Vladimir Yudovin
Did you try the same quires with Java driver without using prepared statements? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Fri, 14 Oct 2016 15:13:38 -0400Aoi Kadoya cadyan@gmail.com wrote

Re: Adding disk capacity to a running node

2016-10-18 Thread Vladimir Yudovin
pulled from under our feet without warning. Yes, in case of planned event. But in case of some hardware failure it can happen. And it shouldn't be some catastrophe affecting the whole availability zone. Just failure of singe blade. Best regards, Vladimir Yudovin, Winguzone - Hosted

Re: Error creating pool to /IP_ADDRESS33:9042 (Proving Cassandra's NO SINGLE point of failure)

2016-10-24 Thread Vladimir Yudovin
Probably used Python driver can't restart failed operation with connection to other node. Do you provide all three IPs to Python driver for connecting? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 24 Oct 2016 07:48:05

Re: Consistency when adding data to collections concurrently?

2016-11-12 Thread Vladimir Yudovin
, adding an element at a particular position results in greater latency than appending or prefixing an element to a list. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sat, 12 Nov 2016 07:57:36 -0500Ali Akhtar ali.rac...@gmail.com

Re: Some questions to updating and tombstone

2016-11-14 Thread Vladimir Yudovin
Hi Boying, UPDATE write new value with new time stamp. Old value is not tombstone, but remains until compaction. gc_grace_period is not related to this. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 14 Nov 2016 03:02

Re: How to Choose a Version for Upgrade

2016-11-23 Thread Vladimir Yudovin
Hi Shalom, there are a lot of discussion on this topic, but it seems that for know we can call 3.0.xx line as most stable. If you don't need specific feature from 3.x line take 3.0.10. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 03

RE: Cassandra Config as per server hardware for heavy write

2016-11-23 Thread Vladimir Yudovin
I have 1Cr records in my Java ArrayList and yes I am writing in sync mode. Is your Java program single threaded? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting, Zero production time On Wed, 23 Nov 2016 03:09:29 -0500Abhishek Kumar Maheshwari abhishek.maheshw

Re: Java GC pauses, reality check

2016-11-25 Thread Vladimir Yudovin
Hi Ahmed, obviously, 20-30 sec. pause is unacceptable. I suppose check the following: - disable swapping completely - check Java version, v8. is desirable (depending on Cassandra version) - use multiprocessor machine (it allows concurrent GC) Best regards, Vladimir Yudovin, Winguzone

RE: Cassandra Config as per server hardware for heavy write

2016-11-23 Thread Vladimir Yudovin
connection pool (with TokenAwarePolicy each) and then pass each item to separate thread. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 04:23:13 -0500Abhishek Kumar Maheshwari abhishek.maheshw...@timesinternet.in wrote Hi Siddharth

RE: Cassandra Config as per server hardware for heavy write

2016-11-23 Thread Vladimir Yudovin
session.execute is coming from Session session = cluster.connect(); I guess? So actually all threads work with the same TCP connection. It's worth to try async API with Connection Pool. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 04

RE: Cassandra Config as per server hardware for heavy write

2016-11-23 Thread Vladimir Yudovin
So do you see speed write saturation at this number of thread? Does doubling to 200 bring increase? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting, Zero production time On Wed, 23 Nov 2016 03:31:32 -0500Abhishek Kumar Maheshwari abhishek.maheshw

RE: Cassandra Config as per server hardware for heavy write

2016-11-23 Thread Vladimir Yudovin
Try to build cluster with .withPoolingOptions Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 05:57:58 -0500Abhishek Kumar Maheshwari abhishek.maheshw...@timesinternet.in wrote Yes, i also try with async mode but I got max speed

Re: Row and column level tombstones

2016-11-23 Thread Vladimir Yudovin
; INSERT INTO ks.tb (id) VALUES ( 0); SELECT * FROM ks.tb ; id | str +-- 0 | null (1 rows) Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 11:59:51 -0500Andrew Cooper andrew.coo...@nisc.coop wrote What would

Re: Cassandra Encryption

2016-11-22 Thread Vladimir Yudovin
if I use the same certificate how does it helps? This certificate will be recognized by all existing nodes, and no restart will be needed. Or, as Nate suggested, you can use trusted root certificate to issue nodes' certificates. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud

Re: single instance failover

2016-11-22 Thread Vladimir Yudovin
this situation, may be with some sort of file locking. multinode Cassandra for Node B is not free Sure, but besides higher reliability you also get increase in read queries speed (with consistency ONE). Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting, Zero production time

RE: cassandra documentation (Multiple datacenter write requests) question

2016-11-22 Thread Vladimir Yudovin
Is Apache Cassandra community can update this documentation ? I don't think so, it's hosted on DataStax website and it's not public Wiki. Anyway you know what is right quorum calculation formula is ))). Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your

Re: single instance failover

2016-11-22 Thread Vladimir Yudovin
. Is there any guidance on single instance failover? I never saw one, the main Casandra idea that you build multinode cluster. Any specific reason why can't you use two nodes as single cluster? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting, zero production time

Re: how to effectively drop table

2016-11-24 Thread Vladimir Yudovin
Hi, Is DROP whole keyspace an option? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 03:00:40 -0500joseph gao gaojf.bok...@gmail.com wrote Hi, all I've had a very bad system design before. This caused about 1 tables

Re: generate different sizes of request from single client

2016-11-24 Thread Vladimir Yudovin
You can use cassandra stress-tool. It has options to set different load patterns. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 13:27:59 -0500Vikas Jaiman er.vikasjai...@gmail.com wrote Hi all, I want to generate two different

Re: OperationTimedOutException (NoHostAvailableException)

2016-11-24 Thread Vladimir Yudovin
rpc_address: 0.0.0.0 , broadcast_address: 1.2.3.4 Did you try set rpc_address to node IP and not to 0.0.0.0 ? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 04:50:08 -0500Jeff Jirsa jeff.ji...@crowdstrike.com wrote Did you

Re: how to effectively drop table

2016-11-24 Thread Vladimir Yudovin
Actually you shouldn't drop tables prior to dropping keyspace. Just drop keyspace with all its tables. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 05:38:36 -0500joseph gao gaojf.bok...@gmail.com wrote Hi,Vladimir, I have

Re: Cassandra Encryption

2016-11-21 Thread Vladimir Yudovin
Hi Jai, so do you generate separate certificate for each node? Why not use one certificate for all nodes? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 17:25:11 -0500Jai Bheemsen Rao Dhanwada jaibheem

Re: [RELEASE] Apache Cassandra 3.0.10 released

2016-11-17 Thread Vladimir Yudovin
release, see https://issues.apache.org/jira/browse/CASSANDRA-9472 for details on Cassandra start. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 17 Nov 2016 06:02:15 -0500Oleksandr Shulgin oleksandr.shul...@zalando.de

Re: [RELEASE] Apache Cassandra 3.0.10 released

2016-11-17 Thread Vladimir Yudovin
My question was about a different option named "offheap_objects". Sorry. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 17 Nov 2016 07:56:10 -0500Oleksandr Shulgin oleksandr.shul...@zalando.de wrote O

Re: NoHostAvailableException

2016-11-21 Thread Vladimir Yudovin
Try to set broadcast_rpc_address on each node to its real external IP address. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 05:47:00 -0500techpyaasa . techpya...@gmail.com wrote Following exception

Re: Out of memory and/or OOM kill on a cluster

2016-11-21 Thread Vladimir Yudovin
Did you try any value in the range 8-20 (e.g. 60-70% of physical memory). Also how many tables do you have across all keyspaces? Each table can consume minimum 1M of Java heap. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes

Re: NoHostAvailableException

2016-11-21 Thread Vladimir Yudovin
Not broadcast_address, but broadcast_rpc_address (you gave this example:rpc_address: 0.0.0.0 , broadcast_rpc_address: 1.2.3.4) Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 08:14:38 -0500techpyaasa

Re: NoHostAvailableException

2016-11-21 Thread Vladimir Yudovin
to listen for clients on rpc_port: 9160 So probably rpc_address: 0.0.0.0 is a problem. Also do you have native port 9042 open in firewall (if there is one). Can you connect to cluster with cqlsh? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster

Re: NoHostAvailableException

2016-11-21 Thread Vladimir Yudovin
Hi, as I mentioned about rpc_address: 0.0.0.0 YAML says it is allowed to specify 0.0.0.0 ... but that will break clients that rely on node auto-discovery. Try set rpc_address: external_ip Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes

Re: Is Centos 7 Supported for Version 3.0

2016-11-20 Thread Vladimir Yudovin
Hi, Centos 7 has Java 8 available, so there shouldn't be any problem to run Casandra. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 20 Nov 2016 11:14:07 -0500Shalom Sagges shal...@liveperson.com wrote Hi Guys

Re: data not replicated on new node

2016-11-20 Thread Vladimir Yudovin
with data, then added third. When did you change replication factor for existing keyspace? Or it was created with factor three? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 01:28:54 -0500Shalom Sagges shal...@live

Re: data not replicated on new node

2016-11-20 Thread Vladimir Yudovin
try SELECT for some undoubtedly old data with consistency ALL It's worth to turn trace on for this query. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 02:05:35 -0500Vladimir Yudovin vla...@winguzone.com

Re: Consistency when adding data to collections concurrently?

2016-11-12 Thread Vladimir Yudovin
, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sat, 12 Nov 2016 05:34:24 -0500Ali Akhtar ali.rac...@gmail.com wrote I have a table where each record contains a liststring of labels. I have an endpoint which responds to new labels

Re: Specifying multiple conditions for lightweight conditions?

2016-11-01 Thread Vladimir Yudovin
= '2013-01-01 00:00:00+0200' WHERE id = '1' IF last_due_at '2013-01-01 00:00:00+0200' Sure, it's less effective then OR condition. Probably you can use IF NOT EXISTS in first request (depending on your application logic), may be it will be slightly faster (not sure). Best regards, Vladimir

Re: failing bootstraps with OOM

2016-11-02 Thread Vladimir Yudovin
Hi, probably you can try to start new node with auto_bootstrap: false and then repair keypaces or even tables one by one with nodetool repair Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 02 Nov 2016 10:35:45

Re: how to get the size of the particular partition key belonging to an sstable ??

2016-10-28 Thread Vladimir Yudovin
Hi, size of a particular partition key Can you please elucidate this? Key can be just number, or string, or several values. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 27 Oct 2016 11:45:47 -0400Pranay akula

Re: Re : Generic keystore when enabling SSL

2016-10-28 Thread Vladimir Yudovin
either add nodes certificate to their truststore or disable validation (each Cassandra driver does this in its own way). Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 27 Oct 2016 16:45:48 -0400Jacob Shadix jacobsha...@gmail.com

Re: Securing a Cassandra 2.2.6 Cluster

2016-10-31 Thread Vladimir Yudovin
Both nodes can be seeds. Probably I misunderstood Raimund as setting each node as the only seed. If he set both IP on both nodes it's OK. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 30 Oct 2016 14:48:00 -0400Jonathan

Re: Securing a Cassandra 2.2.6 Cluster

2016-10-31 Thread Vladimir Yudovin
, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 30 Oct 2016 15:37:50 -0400Raimund Klein chessra...@gmail.com wrote Hi guys, Thank you for your responses. Let me try to address them: I just tried cqlsh directly with the IP, no change

Re: Securing a Cassandra 2.2.6 Cluster

2016-10-30 Thread Vladimir Yudovin
sh refuses to connect Can you please give output of nodetool status and netstat -lptn | grep java Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 30 Oct 2016 14:11:55 -0400Raimund Klein chessra...@gmail.com wrote H

Re: Cassandra on Cloud platforms experience

2016-11-04 Thread Vladimir Yudovin
locations) with relative low latency 1-1.5 ms. or purchase another VLAN in different pod for $25 per month in the same DC. We provide Cassandra cluster on all provider in many worldwide locations. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes

Re: commit log on NFS volume

2016-11-01 Thread Vladimir Yudovin
Hi, it's not only performance issue. In case of network problem writer tread can be blocked, also in case of failure loss of data can occur. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Tue, 01 Nov 2016 14:10:10 -0400John

Re: JConsole Support for SSL in C* 2.0

2016-10-12 Thread Vladimir Yudovin
her-suites" You see ssl and keystore options. The same in 2.0.17, the only SSL option is: JVM_OPTS="$JVM_OPTS -Dcom.sun.management.jmxremote.ssl=false" Though this config file fo version 2.0 doesn't contain keystore options I think it's worth to try to add them in v2.0. en

Re: Where to change the datacenter name?

2016-10-10 Thread Vladimir Yudovin
because it says 0 replicas available Probably you can also use SimpleStrategy (depending on system configuration and needs) Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Mon, 10 Oct 2016 16:30:49 -0400Ali

Re: Understanding cassandra data directory contents

2016-10-10 Thread Vladimir Yudovin
/1476165047920 Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Mon, 10 Oct 2016 17:00:03 -0400Nicolas Douillet nicolas.douil...@gmail.com wrote Hi Json, I'm not familiar enough with Cassandra 3

Re: VNode Streaming Math

2016-10-12 Thread Vladimir Yudovin
approach - each node keeps more or less the same amount of date. If you add new node to cluster it should get the same data volume that is stored on any other node. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

2016-10-12 Thread Vladimir Yudovin
, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Wed, 12 Oct 2016 23:54:58 -0400sudheer k sudheer.hdp...@gmail.com wrote Hi All, I faced issue with triggers today. Below is the clear description of the issue: 1

Re: Inserting list data

2016-10-12 Thread Vladimir Yudovin
by 'b' Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Wed, 12 Oct 2016 23:58:23 -0400Aoi Kadoya cadyan@gmail.com wrote yes, that's what I thought. but, when I use these forms, INSERT

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

2016-10-12 Thread Vladimir Yudovin
Yes, pass this argument to bin/cassandra script: bin/cassandra -Djava.io.tmpdir=/path/to/tmpdir Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Thu, 13 Oct 2016 00:36:35 -0400sudheer k sudheer.hdp

Re: Inserting list data

2016-10-12 Thread Vladimir Yudovin
list. >From here https://docs.datastax.com/en/cql/3.0/cql/cql_using/use_list_t.html : These update operations are implemented internally without any read-before-write. Appending and prepending a new element to the list writes only the new element. Best regards, Vladimir Yudo

Re: Adding disk capacity to a running node

2016-10-17 Thread Vladimir Yudovin
Yes, Cassandra should keep percent of disk usage equal for all disk. Compaction process and SSTable flushes will use new disk to distribute both new and existing data. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes

Re: Cassandra installation best practices

2016-10-17 Thread Vladimir Yudovin
Hi, you can take a look on http://docs.datastax.com/en/landing_page/doc/landing_page/recommendedSettingsLinux.html Regarding file system type I guess ext4 is good enough. (Though RedHat now use XFS as default FS). Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra

Re: Adding disk capacity to a running node

2016-10-17 Thread Vladimir Yudovin
It's extremely unreliable to use ephemeral (local) disks. Even if you don't stop instance by yourself, it can be restarted on different server in case of some hardware failure or AWS initiated update. So all node data will be lost. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud

Re: Adding disk capacity to a running node

2016-10-17 Thread Vladimir Yudovin
But after such restart node should be joined to cluster again and restore data, right? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Mon, 17 Oct 2016 14:55:49 -0400Jonathan Haddad j...@jonhaddad.com

Re: Cassandra: maximum size of collection list type

2016-12-01 Thread Vladimir Yudovin
of data. Never insert more than 64K items in a collection. If you insert more than 64K items into a collection, only 64K of them will be queryable, resulting in data loss. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 01 Dec 2016 12:17:23 -0500

Re: Cassandra 2.x Stability

2016-11-30 Thread Vladimir Yudovin
You should also consider end of support term, as Cassandra page says: Apache Cassandra 2.2 is supported until November 2016. Apache Cassandra 2.1 is supported until November 2016 with critical fixes only So 2.1 actually don't get any fixes, even critical. Best regards, Vladimir Yudovin

Re: Cqlsh timeout and schema refresh exceptions

2016-12-19 Thread Vladimir Yudovin
. Make test on one-two node cluster. Question: What is the effect of below exception? Is keyspaces created despite exception or no? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 19 Dec 2016 10:24:20 -0500 Saumitra S saumitra.srivast...@gmail.com

Re: Cqlsh timeout and schema refresh exceptions

2016-12-19 Thread Vladimir Yudovin
Regarding schema agreement - try to increase time between CF creation. Also stress-tool waits for schema, look on its code, probably it uses some methods to ensure schema distribution. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 19 Dec 2016 14:35

Re: Not timing out some queries (Java driver)

2016-12-22 Thread Vladimir Yudovin
What is replication factor? Why not use CONSISTENCY QUORUM? It's faster and safe enough. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 22 Dec 2016 10:14:14 -0500 Ali Akhtar ali.rac...@gmail.com wrote Is it possible to provide these options

Re: Cqlsh timeout and schema refresh exceptions

2016-12-19 Thread Vladimir Yudovin
me to the this 1MB per CF thingy, it would be great. Look at http://www.mail-archive.com/user@cassandra.apache.org/msg46359.html, CASSANDRA-5935, CASSANDRA-2252 In source look at SlabAllocator.REGION_SIZE definition. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting

Re: Openstack and Cassandra

2016-12-22 Thread Vladimir Yudovin
Hi Shalom, I don't see any reason why it wouldn't work, but obviously, any resource sharing affects performance. You can expect less degradation with SSD disks, I guess. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 21 Dec 2016 13:31:22 -0500

Re: Altering of types is not allowed

2017-03-24 Thread Vladimir Yudovin
As error message said "Altering of types is not allowed" is not allowed in Cassandra. It's NO Sql, but still not schemaless database. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 22 Mar 2017 18:57:18 -0400 Ryan Flynn ry...@splunk.

Re: Using datastax driver, how can I read a non-primitive column as a JSON string?

2017-03-24 Thread Vladimir Yudovin
Hi, why not used SELECT JSON * FROM as described here https://www.datastax.com/dev/blog/whats-new-in-cassandra-2-2-json-support ? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 23 Mar 2017 13:08:30 -0400 S G sg.online.em...@gmail.com wrote

Re: Weird error: InvalidQueryException: unconfigured table table2

2017-03-27 Thread Vladimir Yudovin
Just wish that an error like: "Table x not found in keyspace y" You are welcome to open JIRA with type Improvement. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 26 Mar 2017 13:31:33 -0400 S G sg.online.em...@gmail.com wrote T

Re: Changed node ID?

2017-03-07 Thread Vladimir Yudovin
Hi, Why did the host ID change? probably this node data folder (at least system keyspace) was erased. Or nodes changed their IP, do you use dynamic IPs? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 06 Mar 2017 22:44:50 -0500 Joe Olson technol

Re: Limit on number of keyspaces/tables

2017-03-05 Thread Vladimir Yudovin
Hi, there is no such hard limit, but each table consume at least 1M memory, so 1000 tables takes at least 1G. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 05 Mar 2017 05:57:48 -0500 Lata Kannan lata.kan...@oracle.com wrote Hi I just

Re: Limit on number of keyspaces/tables

2017-03-05 Thread Vladimir Yudovin
>From source code and measurement. Try to create a lot of tables with small write to each of them and monitor Java heap. Each table takes some more then 1M. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 05 Mar 2017 14:40:42 -0500 benjamin roth

  1   2   >