Techniques for synchronous access to database replicas
US12032555B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 31, 2022 |
| Grant date | Jul 9, 2024 |
| Priority date | — |
| Expiry date | Aug 25, 2042 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/284
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for providing consistency in read-after-write operations in a multi-replica relational database system (RDS) are provided. The method includes receiving a read transaction to read data from a database (DB) replica of the multi-replica RDS; obtaining counter values of DB replicas in the multi-replica RDS, a counter value of determines a current version of recent data stored in the respective DB replica; determining a write replica out of the DB replicas in the multi-replica RDS; determining if there is an available read replica, a read replica is a replica other than the determined write replica having counter value at least equals to a counter value of the write replica; and waiting, when there is no available read replica, a preconfigured time window to allow all replicas to synchronize with the write replica; and reading the data from a read replica when the preconfigured time window has elapsed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.