[ 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