Method, system and apparatus for managing primary and secondary databases

1. A computer-implemented method for managing primary and secondary databases, the computer-implemented method comprising:

determining that a lock held by a primary database has expired, wherein the primary database and the secondary databases share the lock, and wherein the lock is updated to extend a validity period of the lock before the validity period expires, wherein:

the lock is updated during an update cycle having a first time period T 1 ,

the primary database sends, at a cycle with a second time period T 2 , a lock request for querying a status of the lock, and

a particular secondary database from the secondary databases sends, at a cycle with a third time period T 3 , a lock request for querying the status of the lock, wherein the second time period T 2 is smaller than the first time period T 1 , and the third time period T 3 is greater than or equal to the first time period T 1 ;

in response to determining that the lock held by the primary database has expired, determining that a lock renewal request of the primary database has not been received after the lock has expired; and

in response to determining that the lock renewal request of the primary database has not been received, selecting the particular secondary database as a new primary database, and controlling the primary database to be switched to the secondary database.

2. The computer-implemented method of claim 1 , further comprising:

sending a lock expiration notification to the particular secondary database; and

receiving a lock request from the particular secondary database based on the lock expiration notification, and recording a receiving time of the lock request.

3. The computer-implemented method of claim 2 , wherein selecting the particular secondary database comprises:

selecting one of the secondary databases with an earliest receiving time.

4. The computer-implemented method of claim 1 , wherein a priority of the primary database is higher than a priority of the particular secondary database.

5. The computer-implemented method of claim 1 , wherein the particular secondary database comprises a hot standby database and a disaster recovery database, the primary database and the hot standby database are located in a same data center, and the primary database and the disaster recovery database are located in different data centers.

6. The computer-implemented method of claim 1 , further comprising:

performing operations comprising at least one of a maintenance or an upgrade on the primary database.

7. The computer-implemented method of claim 6 , further comprising:

determining whether the operations comprising at least one of the maintenance and the upgrade on the primary database are completed; and

in response to determining that the operations comprising at least one of the maintenance and the upgrade on the primary database are completed, restoring the primary database.

8. The computer-implemented method of claim 7 , wherein after the primary database is restored, the method further comprises:

receiving a lock request sent by an original primary database, and controlling the lock to be held by the original primary database after the lock expires, wherein the original primary database is restored to the primary database, and a current primary database is restored to one of the secondary databases.

9. The computer-implemented method of claim 8 , further comprising:

continuing to determine whether a lock held by the current primary database expires; and

in response to determining that the lock held by the current primary database has expired, determining whether lock requests of the original primary database, the current primary database, and other secondary databases are received.

10. The computer-implemented method of claim 8 , further comprising:

in response to determining that the lock request of the original primary database is received, restoring the original primary database to the primary database, and restoring the current primary database to one of the secondary databases.

11. The computer-implemented method of claim 8 , further comprising:

in response to determining that the lock request of the original primary database is not received and the lock requests of the current primary database and the other secondary databases are received, maintaining the current primary database as the primary database.

12. The computer-implemented method of claim 8 , further comprising:

in response to determining that the lock requests of the original primary database and the current primary database are not received and the lock requests of the other secondary databases are received, selecting one of the other secondary databases as the primary database, and restoring the current primary database to one of the secondary databases.

13. A non-transitory, computer-readable medium storing one or more instructions executable by a computer system to perform operations for managing primary and secondary databases, the operations comprising:

determining that a lock held by a primary database has expired, wherein the primary database and the secondary databases share the lock, and wherein the lock is updated to extend a validity period of the lock before the validity period expires, wherein:

the lock is updated during an update cycle having a first time period T 1 ,

the primary database sends, at a cycle with a second time period T 2 , a lock request for querying a status of the lock, and

a particular secondary database from the secondary databases sends, at a cycle with a third time period T 3 , a lock request for querying the status of the lock, wherein the second time period T 2 is smaller than the first time period T 1 , and the third time period T 3 is greater than or equal to the first time period T 1 ;

in response to determining that the lock held by the primary database has expired, determining that a lock renewal request of the primary database has not been received after the lock has expired; and

in response to determining that the lock renewal request of the primary database has not been received, selecting the particular secondary database as a new primary database, and controlling the primary database to be switched to the secondary database.

14. The non-transitory, computer-readable medium of claim 13 , the operations further comprising:

sending a lock expiration notification to the particular secondary database; and

receiving a lock request from the particular secondary database based on the lock expiration notification, and recording a receiving time of the lock request.

15. The non-transitory, computer-readable medium of claim 14 , wherein selecting the particular secondary database comprises:

selecting one of the secondary databases with an earliest receiving time.

16. The non-transitory, computer-readable medium of claim 13 , wherein a priority of the primary database is higher than a priority of the particular secondary database.

17. A computer-implemented system for managing primary and secondary databases, comprising:

one or more computers; and

one or more computer memory devices interoperably coupled with the one or more computers and having tangible, non-transitory, machine-readable media storing one or more instructions that, when executed by the one or more computers, perform one or more operations comprising:

determining that a lock held by a primary database has expired, wherein the primary database and the secondary databases share the lock, and wherein the lock is updated to extend a validity period of the lock before the validity period expires, wherein:

the lock is updated during an update cycle having a first time period T 1 ,

the primary database sends, at a cycle with a second time period T 2 , a lock request for querying a status of the lock, and

a particular secondary database from the secondary databases sends, at a cycle with a third time period T 3 , a lock request for querying the status of the lock, wherein the second time period T 2 is smaller than the first time period T 1 , and the third time period T 3 is greater than or equal to the first time period T 1 ;

in response to determining that the lock held by the primary database has expired, determining that a lock renewal request of the primary database has not been received after the lock has expired; and

in response to determining that the lock renewal request of the primary database has not been received, selecting the particular secondary database as a new primary database, and controlling the primary database to be switched to the secondary database.

18. The system of claim 17 , wherein the operations further comprise:

sending a lock expiration notification to the particular secondary database; and

receiving a lock request from the particular secondary database based on the lock expiration notification, and recording a receiving time of the lock request.

19. The system of claim 18 , wherein selecting the particular secondary database comprises:

selecting one of the secondary databases with an earliest receiving time.

20. The system of claim 17 , wherein a priority of the primary database is higher than a priority of the particular secondary database.