Data complementing method and apparatus

Patent metadata

Field	Value
Publication number	US-10045397-B2
Application number	US-201515539966-A
Country	US
Kind code	B2
Filing date	Nov 9, 2015
Priority date	Dec 24, 2014
Publication date	Aug 7, 2018
Grant date	Aug 7, 2018

Abstract

Embodiments of the invention provide a data complementing method and apparatus, which relate to the field of computer. In the method provided by the invention, in the process of master database switching in a master-slave database cluster, a slave database is selected from the database cluster to act as a new master database; first connections between the new master database and all the other slave databases are established successively; the data of the new master database is compared with the data of all the other slave databases, respectively, to synchronize new data in all the other slave databases into the new master database, to accomplish data complementing of the new master database, which causes the new master database to have the latest data in the database cluster, guarantees smooth switching of the master database, and therefore will not influence normal running of database services.

First claim

The invention claimed is:

1. A data complementing method applied in master database switching in a master-slave database cluster, the method comprising:
selecting a slave database from the database cluster to act as a new master database;
establishing first connections between the new master database and all the other slave databases successively;
comparing data of the new master database with data of all the other slave databases, respectively, to synchronize new data in all the other slave databases into the new master database; and
finishing data complementing of the new master database when data comparison and synchronization of all the other slave databases is accomplished,
wherein selecting a slave database from the database cluster to act as a new master database comprises:
obtaining a list of all the slave databases of the database cluster before the establishing connections between the new master database and all the slave databases successively; and
from all the slave databases recorded by the list, screening out and obtaining a slave database that meets a preset condition to act as the new master database, and wherein the preset condition comprises at least one of:
the state of the slave database being identified as alive; and
the number of delayed transactions of the slave database being less than a preset number.

2. The method as claimed in claim 1 , wherein the first connections are master-slave connections, and the other slave databases and the new master database have the master and slave statuses, respectively.

3. The method as claimed in claim 1 , wherein the step of comparing the data of the new master database with the data of all the other slave databases, respectively, to synchronize new data in all the other slave databases into the new master database, further comprises: after data comparison and synchronization is accomplished between the new master database and one other slave database, disconnecting the first connection between them.

4. The method as claimed in claim 1 , wherein the method further comprises: establishing second connections between the new master database and all the other slave databases successively after data complementing of the new master database is finished; and synchronizing data of the new master database to all the other slave databases.

5. The method as claimed in claim 4 , wherein the second connections are master-slave connections, and the new master database and the other slave databases have the master and slave statuses, respectively.

6. The method as claimed in claim 1 , wherein the database cluster is a MYSQL database cluster.

7. A data complementing apparatus applied in master database switching in a master-slave database cluster, the apparatus comprising:
a memory having instructions stored thereon:
a processor configured to execute the instructions to perform the following operations:
selecting a slave database from the database cluster to act as a new master database;
establishing first connections between the new master database and all the other slave databases successively;
comparing data of the new master database with data of all the other slave databases, respectively, to synchronize new data in all the other slave databases into the new master database; and
finishing data complementing of the new master database when the data comparison and synchronization of all the other slave databases is accomplished,
wherein selecting a slave database from the database cluster to act as a new master database comprises:
obtaining a list of all the slave databases of the database cluster before the establishing connections between the new master database and all the slave databases successively; and
from all the slave databases recorded by the list, screening out and obtaining a slave database that meets a preset condition to act as the new master database, and wherein the preset condition comprises at least one of:
the state of the slave database being identified as alive; and
the number of delayed transactions of the slave database being less than a preset number.

8. The apparatus as claimed in claim 7 , wherein the first connections are master-slave connections, and the other slave databases and the new master database have the master and slave statuses, respectively.

9. The apparatus as claimed in claim 7 , wherein the comparing the data of the new master database with the data of all the other slave databases, respectively, to synchronize new data in all the other slave databases into the new master database, further comprises: after data comparison and synchronization is accomplished between the new master database and one other slave database, disconnecting the first connection between them.

10. The apparatus as claimed in claim 7 , wherein the operations further comprises:
establishing second connections between the new master database and all the other slave databases successively after data complementing of the new master database is finished; and
synchronizing data of the new master database to all the other slave databases.

11. The apparatus as claimed in claim 10 , wherein the second connections are master-slave connections, and the new master database and the other slave databases have the master and slave statuses, respectively.

12. The apparatus as claimed in claim 7 , wherein the database cluster is a MYSQL database cluster.

13. A non-transitory computer readable medium having instructions stored thereon that when executed by at least one processor, cause the at least one processor to perform following operations:
selecting a slave database from the database cluster to act as a new master database:
establishing first connections between the new master database and all the other slave databases successively:
comparing data of the new master database with data of all the other slave databases, respectively, to synchronize new data in all the other slave databases into the new master database; and
finishing data complementing of the new master database when data comparison and synchronization of all the other slave databases is accomplished,
wherein selecting a slave database from the database cluster to act as a new master database comprises:
obtaining a list of all the slave databases of the database cluster before the establishing connections between the new master database and all the slave databases successively; and
from all the slave databases recorded by the list, screening out and obtaining a slave database that meets a preset condition to act as the new master database, and wherein the preset condition comprises at least one of:
the state of the slave database being identified as alive; and
the number of delayed transactions of the slave database being less than a preset number.

Assignees

• Beijing Qihoo Technology Co

Inventors

• Yang Ting

Classifications

• G06F16/275 Primary

  Synchronous replication · CPC title

• H04W84/20 Primary

  Leader-follower arrangements · CPC title

• G06F16/25

  Integrating or interfacing systems involving database management systems · CPC title

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G06F17/30581

  Physics · mapped topic