only grant select , but still can modify data

2015-08-03 Thread rock zhang
Hi All, I want to create a readonly account, so i run the following command following: http://docs.datastax.com/en/cassandra/1.2/cassandra/security/security_config_native_authenticate_t.html CREATE USER readonly WITH PASSWORD '' ; GRANT SELECT ON ALL KEYSPACES TO readonly; Then I login De

Re: "SELECT *..." query times out on a particular table

2015-08-03 Thread Bryan Holladay
Check Cassandra logs for tombstone threshold error On Aug 3, 2015 7:32 PM, "Robert Coli" wrote: > On Mon, Aug 3, 2015 at 2:48 PM, Sid Tantia > wrote: > >> Any select all or select count query on a particular table is timing out >> with "Cassandra::Errors::TimeoutError: Timed out" >> >> A “SELECT

Re: "SELECT *..." query times out on a particular table

2015-08-03 Thread Robert Coli
On Mon, Aug 3, 2015 at 2:48 PM, Sid Tantia wrote: > Any select all or select count query on a particular table is timing out > with "Cassandra::Errors::TimeoutError: Timed out" > > A “SELECT * FROM WHERE = ‘’ > on the table works, but a “SELECT * FROM LIMIT 1; does not work. > All other tables

Re: "SELECT *..." query times out on a particular table

2015-08-03 Thread Sid Tantia
Right, thanks for pointing that out. I am running Cassandra v2.1.4 On Mon, Aug 3, 2015 at 2:51 PM, Jim Witschey wrote: > You might want to send another email to the list specifying the Cassandra > version. > On Mon, Aug 3, 2015 at 5:48 PM Sid Tantia > wrote: >> Hello, >> >> Any select all or se

"SELECT *..." query times out on a particular table

2015-08-03 Thread Sid Tantia
Hello, Any select all or select count query on a particular table is timing out with "Cassandra::Errors::TimeoutError: Timed out" A “SELECT * FROM WHERE = ‘’ on the table works, but a “SELECT * FROM LIMIT 1; does not work. All other tables and queries work.  Any ideas as to why this migh

Re: GossipingPropertyFileSnitch vs Ec2Snitch

2015-08-03 Thread John Wong
Thanks Rob. But even if we do move out of EC2 in X years, unlike partitioner, I don't think there is much to do to switch snitch. Yes, I am evaluating if there is actually good benefit to use EC2. John On Mon, Aug 3, 2015 at 1:54 PM, Robert Coli wrote: > On Sun, Aug 2, 2015 at 6:22 PM, John Wo

Re: GossipingPropertyFileSnitch vs Ec2Snitch

2015-08-03 Thread Robert Coli
On Sun, Aug 2, 2015 at 6:22 PM, John Wong wrote: > What other benefits can Ec2Snitch provide in a single-region, multi-az AWS > deployment besides automatically setting dc and rack for you as the snitch > reads from EC2 metadata. > Obviously there is a concern with what if there is something wron

Re: linearizable consistency / Paxos ?

2015-08-03 Thread Yang
Thanks a lot for the info! I see, the paxos protocol used now in the code is actually the "single-decree synod" protocol, which votes on only one value. the scope of the implementation is only the CAS operation (which contains a read and write), not a generic txn (which could contain arbitrari

[RELEASE] Apache Cassandra 3.0.0-alpha1 released

2015-08-03 Thread Jake Luciani
The Cassandra team is pleased to announce the release of Apache Cassandra version 3.0.0-alpha1. This is the first test build of Cassandra 3.0 that includes: * New storage engine * New sstable format * Materialized Views We expect bugs in this release so test and report any issues please

Re: Understanding gossip protocol in cassandra

2015-08-03 Thread selam
If i remember correctly; In real life gossip, you can not get the information before you give some. New machine sends it's own state to seed node, seed node replys this message with list of other nodes and their states (end of seed node role), then after a while (if i remember correctly gossip p

Re: AWS multi-region DCs fail to rebuild

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

Understanding gossip protocol in cassandra

2015-08-03 Thread Thouraya TH
Hi all, Please, i try to undestand how gossip protocol is used in cassandra. I read this: “This is most critical the first time a node starts up. By default, a node remembers other nodes it has gossiped with between subsequent restarts. *The seed node designation has no purpose other than boo

Re: phi_convict_threshold

2015-08-03 Thread Thouraya TH
Ok, thank you so much for answer. Kind Regards. 2015-08-03 15:09 GMT+01:00 DuyHai Doan : > Yes it is used by Gossip > > On Mon, Aug 3, 2015 at 3:33 PM, Thouraya TH wrote: > >> Ok, i will see this reference. thank you so much for answer. >> So i understand that this value is used by gossip protoc

Re: phi_convict_threshold

2015-08-03 Thread DuyHai Doan
Yes it is used by Gossip On Mon, Aug 3, 2015 at 3:33 PM, Thouraya TH wrote: > Ok, i will see this reference. thank you so much for answer. > So i understand that this value is used by gossip protocol ? that's it ? > Best Regards. > > 2015-08-03 13:41 GMT+01:00 DuyHai Doan : > >> You can read thi

Re: phi_convict_threshold

2015-08-03 Thread Thouraya TH
Ok, i will see this reference. thank you so much for answer. So i understand that this value is used by gossip protocol ? that's it ? Best Regards. 2015-08-03 13:41 GMT+01:00 DuyHai Doan : > You can read this paper that explains the Phi Accrual Failure detection > algo: http://vsedach.googlepages

Re: phi_convict_threshold

2015-08-03 Thread DuyHai Doan
You can read this paper that explains the Phi Accrual Failure detection algo: http://vsedach.googlepages.com/HDY04.pdf The phi value is the level of suspicion a server might be down. phi_convict_threshold = suspicion level above which a server is marked down On Mon, Aug 3, 2015 at 1:29 PM, Thour

phi_convict_threshold

2015-08-03 Thread Thouraya TH
Hi all, Please, can you explain me this sentence: The configuration parameter phi_convict_threshold in the cassandra.yaml file is used to control Cassandra’s sensitivity of node failure detection. ? Thank you so much for help. Kind regards.

Re: linearizable consistency / Paxos ?

2015-08-03 Thread DuyHai Doan
"you seem to be suggesting that the "other operations on the same partition key have to wait" because Paxos grouped the first series together, which have to be committed in the same order , before all other operations, essentially ___serializing___ the operations (with guaranteed same order)." -->

Re: Scientific Paper of Gossip Protocol

2015-08-03 Thread Thouraya TH
Thank you so much for help. Kind regards. 2015-08-02 20:57 GMT+01:00 Bharatendra Boddu : > Cassandra is based on Scuttle-butt protocol. Reference: > > Robbert van Renesse, Dan Mihai Dumitriu, Valient Gough, and Chris Thomas. > Efficient reconciliation and flow control for anti-entropy protocols.

Re: linearizable consistency / Paxos ?

2015-08-03 Thread Yang
thanks for your answer DuyHai. I understand Paxos. but I think your description seems missing one important point: in the example you gave, "a series of ongoing operation (INSERT, UPDATE , DELETE ...) " you seem to be suggesting that the "other operations on the same partition key have to wait" be

Re: linearizable consistency / Paxos ?

2015-08-03 Thread DuyHai Doan
"what is the fundamental difference between the standard replication protocol and Paxos that prevents us from implementing a 2-pc on top of the standard protocol?" --> for a more detailed description of Paxos, look here: http://www.slideshare.net/doanduyhai/distributed-algorithms-for-big-data-geec

Re: Cassandra Data Stax java driver & Snappy Compression library

2015-08-03 Thread Janne Jalkanen
Correct. Note that you may lose some performance this way though; in a typical case saving bandwidth by increasing CPU usage is good. However, it always depends on your usecase and whether you’re running your cluster to the max. It’s a good, low-hanging optimization to keep in mind though for p