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.
Legal claims defining the scope of protection, as filed with the USPTO.
5. The method of claim 1, wherein the read transaction is posted to an SQL engine.
6. The method of claim 5, wherein the SQL engine is any one of: MySQL and PostgreSQL.
7. The method of claim 1, wherein the preconfigured time window is shorter than a watchdog timer in the multi-replica RDS.
8. The method of claim 1, wherein the preconfigured time window is set based on an update time parameter set by the multi-replica RDS.
9. The method of claim 1, wherein the read transaction is received substantially received after a completion of a write transaction in the multi-replica RDS.
15. The controller of claim 11, wherein the read transaction is posted to an SQL engine.
16. The controller of claim 15, wherein the SQL engine is any one of: MySQL and PostgreSQL.
17. The controller of claim 11, wherein the preconfigured time window is shorter than a watchdog timer in the multi-replica RDS.
18. The controller of claim 11, wherein the preconfigured time window is set based on an update time parameter set by the multi-replica RDS.
19. The controller of claim 11, wherein the read transaction is received substantially received after a completion of a write transaction in the multi-replica RDS.
20. The controller of claim 11, wherein the controller is integrated in the multi-replica relational database system (RDS).
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
May 31, 2022
July 9, 2024
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.