[jira] [Commented] (CASSANDRA-15621) LOCAL_QUORUM is waiting on remote datacenter

["Stefan Genov (Jira)" <ji...@apache.org>]

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

Stefan Genov commented on CASSANDRA-15621:
------------------------------------------

Our problem seemed to be related to the Authentication and the Authorization. For some reason with them we were seeing CRAZY slow requests and with them disabled the tracing shows everything as expected.

Maybe this is a potential bug?

> 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org