US 11,704,182 B2
Access consistency in high-availability databases
Zhe Huang, Shanghai (CN); Jia Mei, Shanghai (CN); Xin Li, Shanghai (CN); Ying Yue, Nanjing (CN); and Chaoyi Chen, Shanghai (CN)
Assigned to PayPal, Inc., San Jose, CA (US)
Filed by PayPal, Inc., San Jose, CA (US)
Filed on Aug. 17, 2021, as Appl. No. 17/404,471.
Claims priority of application No. PCT/CN2020/122348 (WO), filed on Oct. 21, 2020.
Prior Publication US 2022/0121510 A1, Apr. 21, 2022
Int. Cl. G06F 11/00 (2006.01); G06F 11/07 (2006.01); G06F 11/14 (2006.01); G06F 11/30 (2006.01); G06F 11/20 (2006.01)
CPC G06F 11/0772 (2013.01) [G06F 11/076 (2013.01); G06F 11/0757 (2013.01); G06F 11/1451 (2013.01); G06F 11/1464 (2013.01); G06F 11/1469 (2013.01); G06F 11/2069 (2013.01); G06F 11/2082 (2013.01); G06F 11/3034 (2013.01); G06F 2201/80 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method, comprising:
receiving, by a computer system from a plurality of host computers, a plurality of requests to access data stored in a database implemented using a plurality of clusters;
responding, by the computer system, to the plurality of requests by accessing data stored in an active cluster;
determining, by the computer system based on the responding, health information for ones of the plurality of clusters, wherein the health information is generated based on real-time traffic for the database;
periodically determining, by the computer system based on a cleanup time threshold, whether one or more access host computers have been removed from a pool of access host computers used in responding to the plurality of requests;
removing, by the computer system from the health information, one or more health ballots associated with one or more access host computers that have been removed from the pool;
determining, by the computer system based on the health information, whether to switch from accessing the active cluster to accessing a backup cluster; and
storing, by the computer system in respective clusters of the database, a changeover decision generated based on the determining.