[ 
https://issues.apache.org/jira/browse/CASSANDRA-15621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17051298#comment-17051298
 ] 

Brandon Williams commented on CASSANDRA-15621:
----------------------------------------------

That's your problem.

http://cassandra.apache.org/doc/latest/operating/security.html#enabling-password-authentication

bq. During login, the credentials for the default superuser are read with a 
consistency level of QUORUM, whereas those for all other users (including 
superusers) are read at LOCAL_ONE. In the interests of performance and 
availability, as well as security, operators should create another superuser 
and disable the default one. 

> LOCAL_QUORUM is waiting on remote datacenter
> --------------------------------------------
>
>                 Key: CASSANDRA-15621
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15621
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Stefan Genov
>            Priority: Normal
>
> We have a 2 datacenters ( One in EU and one in US ) cluster with 4 nodes each 
> deployed in AWS. 
> The nodes are separated in 3 racks ( Availability zones ) each.
> In the cluster we have a keyspace test with replication: 
> NetworkTopologyStrategy, eu-west:3, us-east:3
> In the keyspace we have a table called mytable that has only one row 'id' text
> Now, we were doing some tests on the performance of the database.
> In CQLSH with a consistency level of LOCAL_QUORUM we were doing some inserts 
> with TRACING ON and we noticed that the requests were not working as we 
> expected them.
> From the tracing data we found out that the coordinator node was hitting as 
> expected 2 other local nodes and was also sending a request to one of the 
> remote datacenter nodes. Now the problem here was that the coordinator was 
> waiting not only for the local nodes ( who finished in no time ) but for the 
> remote nodes too.
> Now since our 2 datacenters are geographically far away from each other, our 
> requests were taking a very long time to complete.
> Notes:
> - This does not happen with DSE but our understanding was we don't need to 
> pay crazy money for LOCAL_QUORUM to work as is expected



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

Reply via email to