[ https://issues.apache.org/jira/browse/CASSANDRA-15621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17051281#comment-17051281 ]
Brandon Williams commented on CASSANDRA-15621: ---------------------------------------------- Are you using the cassandra user? > 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