lyf200581105 opened a new issue, #19278:
URL: https://github.com/apache/shardingsphere/issues/19278
Using sharding-jdbc-core 4.1.1， only sharding tables
DB : AWS Aurora
Both read and write operations are using master endpoint
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-core</artifactId>
<version>4.1.1</version>
</dependency>
Using Jmeter to do some performance test
step 1: call create API to insert data to DB and return id
step 2: call get API with ID returned by step1 to query the data by Id,
about 70% results showed data not found
But if pause about 30ms between step1 and step2, then all queries of step2
return successfully
And I did a similar test for no sharding tables, and all works fine.
I saw there is a statement for LOCAL Transaction as below
"There is no loss in performance, but strong consistency and final
consistency cannot be guaranteed."
So is the insert delay I met caused by the strong consistency issue of local
consistency? or did someone encounter a similar issue before?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
