WO2016173179A1 - Procédé et dispositif pour commutation de base de données primaire et de base de données secondaire - Google Patents
Procédé et dispositif pour commutation de base de données primaire et de base de données secondaire Download PDFInfo
- Publication number
- WO2016173179A1 WO2016173179A1 PCT/CN2015/089553 CN2015089553W WO2016173179A1 WO 2016173179 A1 WO2016173179 A1 WO 2016173179A1 CN 2015089553 W CN2015089553 W CN 2015089553W WO 2016173179 A1 WO2016173179 A1 WO 2016173179A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- database
- data
- location
- current
- standby
- Prior art date
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
Definitions
- This document relates to but not limited to the field of databases, and in particular relates to a method and apparatus for database master-slave switching.
- Master-slave replication is a backup of the host binary log. Due to factors such as the host write log delay and network communication delay, the active and standby logs are not synchronized. However, there is still no tool in the industry to compare the data consistency between the primary and backup databases. You can only use the manual execution of the database statement to understand whether the data of the primary and backup machines are consistent. When the host is down and needs to do the active/standby switchover, you can only view the database binary. The log can determine the difference between the primary and secondary binary logs, manually extract the corresponding logs from the host, restore them to the corresponding database statements, and insert them into the standby machine for synchronization. This process is very cumbersome, and the labor cost is high, the reaction speed is slow, and the error rate is high.
- the embodiment of the invention provides a method and a device for switching between active and standby databases, and the purpose thereof is to solve the technical problem that the database active/standby switching process is cumbersome, and the labor cost is high, the reaction speed is slow, and the error rate is high.
- An embodiment of the present invention provides a method for database active/standby switchover, which is applied to a management server, and includes:
- the second database successfully returns to the current primary database, and the feedback data is obtained according to the feedback data.
- the second database finally switches data from the first database synchronization data;
- the step of monitoring the operation of the first database as the current primary database comprises:
- the heartbeat information periodically reported by the first database is obtained.
- the heartbeat information is not received within a predetermined interval, it is determined that the first database is abnormal.
- the method further includes:
- the first binary log first location of the first database is sent to the second database while the backup master request is sent to the second database.
- the step of acquiring data switching information synchronized by the second database from the first database according to the feedback data includes:
- the method further includes: while transmitting a master cut request to the first database, The second database is finally sent from the second location of the binary log synchronized by the first database to the first database.
- the step of acquiring the first location of the current binary log for recording the data execution action in the first database according to the last time the heartbeat information reported by the first database includes:
- the embodiment of the present invention further provides a method for database active/standby switchover, which is applied to the first database as the current primary database, and includes:
- the method before the step of receiving a primary server request sent by the management server to detect that the first database is abnormal, the method further includes:
- the heartbeat information is periodically reported to the management server, so that the management server detects whether the first database is abnormal according to the heartbeat information.
- the step of data switching information that is finally synchronized from the first database includes:
- the determining, according to the data switching information, the data synchronized to the second database Whether there is a missing step comprising: obtaining a fourth location of the binary log after the first database returns to a normal heartbeat;
- the method further includes:
- the embodiment of the present invention further provides a method for database active/standby switching, which is applied to a second database as a current standby database, including:
- the step of obtaining the current data information of the first database from the backup master request and comparing the current data information of the second database includes:
- An embodiment of the present invention further provides a device for switching between active and standby databases, which is applied to a management server, and the device includes:
- a monitoring module configured to monitor operation of the first database as the current primary database, and when detecting that the first database is running abnormally, send a standby primary request to the second database that is the current standby database;
- the first obtaining module is configured to: when the second database detects that the data in the second database and the first database are consistent, and the second database successfully switches to the current primary database, the feedback data is reported, according to the Determining, by the feedback data, data switching information synchronized by the second database from the first database;
- a first data sending module configured to send a primary cutting request including the data switching information to the first database, so that the first database determines, according to the data switching information, that data synchronized to the second database is not When there is data loss, switch to the current standby database.
- the monitoring module includes:
- the first monitoring sub-module is configured to acquire the heartbeat information periodically reported by the first database, and when the heartbeat information is not received within a predetermined interval, determining that the first database is abnormal.
- the device further includes:
- the first log obtaining module is configured to acquire, according to the heartbeat information reported by the first database in the last time, the first location of the current binary log in the first database for recording data execution actions;
- the monitoring module is further configured to send the first location of the current binary log of the first database to the second database while sending a backup master request to the second database.
- the first obtaining module includes:
- a first log obtaining unit configured to acquire, according to the feedback data, a second location of the binary log that is finally synchronized from the first data by the second database
- the first data sending module is further configured to send, when the primary database request is sent to the first database, the second database to be sent from the second location of the binary database synchronized by the first database to the The first database.
- the first log obtaining module further includes:
- a second log obtaining unit configured to obtain the record data execution in the last heartbeat information The third position of the binary log of the action
- a first detecting unit configured to detect whether a link between the first database and the first database exists:
- the device comprising:
- the first receiving module is configured to receive a master cutting request sent by the management server when detecting that the first database is abnormal;
- a second acquiring module configured to: when the second database that is the current standby database is acquired from the primary standby request, the data is switched from the first database;
- the first discriminating module is configured to determine, according to the data switching information, whether there is a loss of data synchronized to the second database, and when it is determined that there is no data loss, switch to the current standby database; when the judgment data is lost, prompt The switch failed.
- the first receiving module includes:
- the first reporting sub-module is configured to periodically report heartbeat information to the management server, so that the management server detects whether the first database is abnormal according to the heartbeat information.
- the second obtaining module includes:
- the first obtaining submodule is configured to acquire, from the master cutting request, a second location of the binary log that is synchronized by the second database from the first database.
- the first determining module includes:
- a second obtaining submodule configured to acquire a fourth location of the binary log after the first database resumes a normal heartbeat
- a first discriminating sub-module configured to compare the fourth location with the second location, and if the fourth location is less than or equal to the second location, determining that data synchronized to the second database is not lost, and switching to the current standby database; If the fourth location is greater than the second location, it is determined that the data synchronized to the second database is lost, and the data of the first database is different, indicating that the handover fails.
- the device further includes:
- a first detecting module configured to detect a difference between the first database and the second database The start file of the SQL script
- the first generation module is configured to, from the data of the first database, traverse from the second position of the binary log to all log files, generate an SQL statement for each transaction, and redirect to the target text file.
- An embodiment of the present invention provides a device for performing active/standby switchover of a database, which is applied to a second database that is a current standby database, and the device includes:
- a third obtaining module configured to acquire a backup master request sent by the management server when monitoring the first database abnormality as the current primary database
- the second discriminating module is configured to obtain current data information of the first database from the backup master request, compare with current data information of the second database, and determine whether the data is consistent; when the data is consistent, Switch to the current primary database. When the data is inconsistent, the prompt to switch to the current primary database fails.
- the second determining module includes:
- a third obtaining submodule configured to acquire a first location of the current binary log of the first database from the backup master request
- a fourth obtaining submodule configured to acquire a fifth location of the current binary log of the second database to copy data from the first database
- the second discriminating sub-module is configured to compare the first location with the fifth location, and if the first location is equal to the fifth location, determining current data information of the first database and current data information of the second database The data is consistent, and is switched to the current primary database. If the first location is smaller than the fifth location, it is determined that the current data information of the first database is inconsistent with the current data information of the second database, indicating that the switch to the current primary database fails.
- Embodiments of the present invention provide a computer storage medium having stored therein computer executable instructions for performing the methods described above.
- the method and device for the active/standby switchover of the database provided by the embodiment of the present invention can effectively identify the inconsistency between the active and standby databases and perform the active/standby switchover.
- the host database continuously synchronizes the binary logs to the standby database, which can effectively ensure the active/standby switchover.
- Data consistency of the primary and secondary databases during the process The accuracy of the handover; the entire handover process does not require manual participation, saving labor costs, and the response speed is fast and the error rate is low.
- FIG. 1 is a schematic structural diagram of an active/standby switchover according to an embodiment of the present invention
- FIG. 3 is a flowchart of a method for switching between active and standby applications applied to a management server according to an embodiment of the present invention
- FIG. 4 is a schematic diagram of an apparatus for applying active/standby switchover of a management server according to an embodiment of the present invention
- FIG. 5 is a flowchart of an active/standby switchover method applied to a first database that is currently a primary database according to an embodiment of the present invention
- FIG. 6 is a schematic diagram of an apparatus for applying active/standby handover of a first database currently serving as a primary database according to an embodiment of the present invention
- FIG. 7 is a flowchart of an active/standby switchover method applied to a second database that is currently used as a standby database according to an embodiment of the present invention
- FIG. 8 is a schematic diagram of an apparatus for applying active/standby handover of a second database that is currently used as a standby database according to an embodiment of the present invention.
- an embodiment of the present invention provides an architecture for database active/standby switchover, wherein a management server interacts with a first database and a second database through a control flow, and the first database and the second database are managed.
- the server reports the heartbeat message, and the management server sends a primary and secondary handover request to the first database and the second database; the first database sends a data flow to the second database, and the second database synchronizes the heartbeat message of the first database.
- an embodiment of the present invention provides an active/standby switch applied to a management server.
- Methods including:
- Step 11 Monitor the operation of the first database as the current primary database, and when detecting that the first database runs abnormally, send a standby primary request to the second database that is the current standby database;
- step of monitoring the operation of the first database as the current primary database in step 11 includes:
- the first binary log first location of the first database is sent to the second database while the backup master request is sent to the second database.
- the step of acquiring the first location of the current binary log for recording the data execution action in the first database according to the last time the heartbeat information reported by the first database includes:
- Step 12 Acquire feedback data reported when the second database detects that the data in the second database and the first database are consistent, and the second database successfully switches to the current primary database, and obtains the feedback data according to the feedback data.
- the second database finally switches information from the data synchronized by the first database;
- the step of acquiring the data switching information synchronized by the second database from the first database according to the feedback data in step 12 includes:
- Step 13 Send a primary cutting request that includes the data switching information to the first database, so that the first database determines, according to the data switching information, that data that is synchronized to the second database does not have data loss. Switch to the current standby database.
- the second database is finally sent from the second location of the binary database synchronized by the first database to the first database, while the primary database request is sent to the first database.
- the first database that is currently the primary database periodically reports a heartbeat message to the management server, and the management server acquires the binary of the first database from the heartbeat message. a first location of the log, when the management server does not receive the heartbeat information at a predetermined interval, determining that the first database is abnormally operated;
- the management server acquires a first location of the binary log of the first database:
- the management server sends a backup master request to the second database that is the current standby database, and after the second database receives the backup master request, obtains the current current of the first database from the standby master request.
- a first location of the binary log acquiring a fifth location of the current binary log of the second database from the first database; comparing the first location with the fifth location, and determining if the first location is equal to the fifth location
- the current data information of the first database is consistent with the data of the current data information of the second database, is switched to the current primary database, and reports the switching result to the management server, and is finally synchronized from the first database.
- the second location of the binary log is reported to the management server;
- the first location is smaller than the fifth location, determining that the current data information of the first database is inconsistent with the current data information of the second database, indicating that the handover to the current primary database fails.
- the second database acquires the fourth location of the binary log after the first database resumes the normal heartbeat, and Comparing the four positions with the second position, if the fourth position is less than or equal to the second position, determining that the data synchronized to the second database is not lost, and switching to the current standby database;
- the handover fails. After the step of detecting, detecting a start file of the differentiated SQL script between the first database and the second database;
- the second database In the data of the first database, traversing from the second position of the binary log to all the log files, generating a SQL statement for each transaction, and redirecting to the target text file, the second database executing the target text file
- the SQL statement is switched to the current standby database; if the target text file cannot be directed, it indicates that there is a data difference between the first database and the second database, data consistency cannot be restored, and the handover fails;
- the example continuously synchronizes the binary logs to the standby database through the host database, which can effectively ensure the data consistency of the primary and backup databases during the active/standby switchover process and the accuracy of the handover.
- the entire handover process does not require manual participation, saving labor costs and reacting. Fast and low error rate.
- Embodiments of the present invention provide a computer storage medium having stored therein computer executable instructions for performing the methods described above.
- an embodiment of the present invention further provides a device for switching between active and standby databases, which is applied to the management server 1.
- the device includes:
- the monitoring module 11 is configured to monitor the running of the first database as the current primary database, and when detecting that the first database is running abnormally, send a standby primary request to the second database that is the current standby database;
- the first obtaining module 12 is configured to: when the second database detects that the data in the second database and the first database are consistent, and the second database successfully switches to the current primary database, the feedback data is reported according to The feedback data acquires data switching information that is finally synchronized by the second database from the first database;
- the first data sending module 13 is configured to send a primary cutting request including the data switching information to the first database, so that the first database determines that the synchronization is performed according to the data switching information. When there is no data loss in the data of the second database, the current database is switched.
- the monitoring module 11 includes:
- the first monitoring sub-module 111 is configured to acquire the heartbeat information periodically reported by the first database. When the heartbeat information is not received within a predetermined interval, the first database is determined to be abnormal.
- the device further includes:
- the first log obtaining module 14 is configured to acquire, according to the heartbeat information reported by the first database in the last time, the first location of the current binary log in the first database for recording data execution actions;
- the monitoring module 11 is further configured to send the first location of the current binary log of the first database to the second database while sending a backup master request to the second database.
- the first obtaining module 12 includes:
- the first log obtaining unit 121 is configured to acquire, according to the feedback data, a second location of the binary log that is finally synchronized from the first data by the second database;
- the first data sending module is further configured to send the second database to the second location of the binary log synchronized by the first database to the second database while sending the master cutting request to the first database. Said the first database.
- the first log obtaining module 14 further includes:
- the second log obtaining unit 141 is configured to acquire a binary log third position of the last execution of the data execution action in the heartbeat information
- a first detecting unit configured to detect whether a link between the first database and the first database exists:
- the apparatus for the active/standby switchover of the database applied to the management server provided by the embodiment of the present invention is a device that applies the method for applying the database master/slave switch to the management server, that is, all the embodiments of the foregoing method are applicable to the method. Devices, and all achieve the same or similar benefits.
- an embodiment of the present invention further provides a method for database active/standby switchover, which is applied to a first database as a current primary database, including:
- Step 21 Receive a master switch request sent by the management server to detect the abnormality of the first database operation.
- the method further includes:
- the heartbeat information is periodically reported to the management server, so that the management server detects whether the first database is abnormal according to the heartbeat information.
- Step 22 When the second database that is the current standby database is switched from the primary backup request to the primary database, the data is finally synchronized from the first database.
- the step 22 includes:
- the step of determining, according to the data switching information, whether data synchronized to the second database is lost includes: acquiring a fourth location of the binary log after the first database resumes a normal heartbeat;
- Step 23 Determine, according to the data switching information, whether there is a loss of data synchronized to the second database. When it is determined that there is no data loss, the data is switched to the current standby database; when it is determined that the data is lost, the handover fails.
- step 23 after the step of indicating that the data is lost, indicating that the handover fails, the method further includes:
- Embodiments of the present invention provide a computer storage medium having stored therein computer executable instructions for performing the methods described above.
- an embodiment of the present invention further provides a device for switching between active and standby databases, and an application thereof.
- the device includes:
- the first receiving module 21 is configured to receive a master switch request sent by the management server to detect that the first database is abnormal.
- the first receiving module 21 includes:
- the first reporting sub-module 211 is configured to periodically report heartbeat information to the management server, so that the management server detects whether the first database is abnormal according to the heartbeat information.
- the second obtaining module 22 is configured to: when the second database that is the current standby database is acquired from the primary standby request, the data is switched from the first database, and the data is switched from the first database; optionally, the The second obtaining module 22 includes: a first obtaining submodule 221, configured to acquire, from the master cutting request, a second location of the binary log that is finally synchronized from the first database by the second database.
- the first discriminating module 23 is configured to determine, according to the data switching information, whether there is a loss of data synchronized to the second database, and when it is determined that there is no data loss, switch to the current standby database; when it is determined that the data is lost, The prompting of the switching fails; optionally, the first determining module 23 includes:
- the second obtaining sub-module 231 is configured to acquire a fourth location of the binary log after the first database resumes a normal heartbeat
- the first discriminating sub-module 232 is configured to compare the fourth location with the second location. If the fourth location is less than or equal to the second location, determining that the data synchronized to the second database is not lost, and switching to the current standby database If the fourth location is greater than the second location, it is determined that there is a loss of data synchronized to the second database, and there is a difference from the data of the first database, indicating that the handover fails.
- the device further includes:
- the first detecting module 24 is configured to detect a start file of the differentiated SQL script between the first database and the second database;
- the first generation module 25 is configured to, from the data of the first database, traverse from the second position of the binary log to all the log files, generate an SQL statement for each transaction, and redirect to the target text file.
- the apparatus for applying the database master/slave switch to the first database currently serving as the primary database is a device applying the above method for applying the database master/slave switch to the first database currently serving as the primary database. That is, all embodiments of the above method are applicable to the Devices, and all achieve the same or similar benefits.
- an embodiment of the present invention further provides a method for database active/standby switching, which is applied to a second database as a current standby database, including:
- Step 31 Acquire a backup master request sent by the management server when monitoring the first database abnormality as the current primary database
- Step 32 Obtain current data information of the first database from the backup master request, compare with current data information of the second database, and determine whether the data is consistent. When the data is consistent, switch to the current master. Database, when the data is inconsistent, the prompt to switch to the current primary database fails.
- step 32 the step of obtaining the current data information of the first database from the backup master request, and comparing the current data information of the second database, includes:
- Embodiments of the present invention provide a computer storage medium having stored therein computer executable instructions for performing the methods described above.
- an embodiment of the present invention provides a device for performing active/standby switchover of a database, which is applied to a second database 3 as a current standby database, and the device includes:
- the third obtaining module 31 is configured to acquire a backup master request sent by the management server when detecting the first database abnormality as the current primary database;
- the second discriminating module 32 is configured to obtain current data information of the first database from the backup master request, compare with current data information of the second database, and determine whether the data is consistent; when the data is consistent, Then switch to the current primary database, when the data is inconsistent, prompt to switch to The current primary database failed.
- the second determining module includes:
- the third obtaining submodule 321 is configured to acquire a first location of the current binary log of the first database from the backup master request;
- a fourth obtaining submodule 322 configured to acquire a fifth location of the current binary log of the second database to copy data from the first database
- the second discriminating sub-module 323 is configured to compare the first location with the fifth location, and if the first location is equal to the fifth location, determining current data information of the first database and current data information of the second database The data is consistent, and is switched to the current primary database. If the first location is smaller than the fifth location, it is determined that the current data information of the first database is inconsistent with the current data information of the second database, indicating that the switch to the current primary database fails.
- the apparatus for applying the database master/slave switch to the second database that is currently used as the standby database is a device that applies the method for applying the database master/slave switch to the second database that is currently used as the standby database. That is, all of the embodiments of the above methods are applicable to the device, and both achieve the same or similar benefits.
- all or part of the steps of the above embodiments may also be implemented by using an integrated circuit. These steps may be separately fabricated into individual integrated circuit modules, or multiple modules or steps may be fabricated into a single integrated circuit module. achieve.
- the devices/function modules/functional units in the above embodiments may be implemented by a general-purpose computing device, which may be centralized on a single computing device or distributed over a network of multiple computing devices.
- each device/function module/functional unit in the above embodiment When each device/function module/functional unit in the above embodiment is implemented in the form of a software function module and sold or used as a stand-alone product, it can be stored in a computer readable storage medium.
- the above mentioned computer readable storage medium may be a read only memory, a magnetic disk or an optical disk or the like.
- the foregoing technical solution can effectively identify that the active and standby databases are inconsistent and perform active/standby switchover; the data consistency of the primary and backup databases and the accuracy of handover can be effectively ensured during the active/standby switchover; the entire handover process does not require manual participation, saving The labor cost is fast, and the error rate is low.
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Hardware Redundancy (AREA)
- Mobile Radio Communication Systems (AREA)
Abstract
La présente invention concerne un procédé et un dispositif pour commuter une base de données primaire et une base de données secondaire. Le procédé comprend : la surveillance du fonctionnement d'une première base de données utilisée en tant que base de données primaire actuel, et l'envoi d'une demande de commutation secondaire-à-primaire à une seconde base de données utilisée en tant que base de données secondaire actuelle lorsqu'il est détecté que la première base de données est en fonctionnement anormal ; l'acquisition de données de rétroaction rapportées lorsque la seconde base de données détecte que des données dans la seconde base de données sont en accord avec les données dans la première base de données et la seconde base de données est commutée avec succès dans la base de données primaire actuelle, et l'acquisition, selon les données de rétroaction, d'informations de commutation de données, enfin synchronisées à partir de la première base de données, de la seconde base de données ; et l'envoi d'une demande de commutation primaire-à-secondaire qui comprend les informations de commutation de données à la première base de données, et la commutation de la première base de données dans la base de données secondaire actuelle lorsqu'il est jugé, selon les informations de commutation de données, que les données synchronisées avec la seconde base de données ne sont pas en perte de données.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510213694.1 | 2015-04-29 | ||
CN201510213694.1A CN106202075B (zh) | 2015-04-29 | 2015-04-29 | 一种数据库主备切换的方法及装置 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2016173179A1 true WO2016173179A1 (fr) | 2016-11-03 |
Family
ID=57198042
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/CN2015/089553 WO2016173179A1 (fr) | 2015-04-29 | 2015-09-14 | Procédé et dispositif pour commutation de base de données primaire et de base de données secondaire |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN106202075B (fr) |
WO (1) | WO2016173179A1 (fr) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108834179A (zh) * | 2018-05-31 | 2018-11-16 | 深圳市酷达通讯有限公司 | 调整心跳周期的方法、服务器和客户端 |
CN108984569A (zh) * | 2017-06-05 | 2018-12-11 | 中兴通讯股份有限公司 | 数据库切换方法、系统和计算机可读存储介质 |
CN109086292A (zh) * | 2018-06-11 | 2018-12-25 | 平安科技(深圳)有限公司 | 一种数据库的切换方法及系统 |
CN111258823A (zh) * | 2020-01-17 | 2020-06-09 | 青梧桐有限责任公司 | 一种主从服务器的切换方法及系统 |
CN112363865A (zh) * | 2020-10-19 | 2021-02-12 | 深圳云天励飞技术股份有限公司 | 数据库故障恢复方法、装置及人脸图像搜索系统 |
CN113297002A (zh) * | 2020-02-21 | 2021-08-24 | 北京京东振世信息技术有限公司 | 数据库工作模式的切换方法和装置 |
CN114679399A (zh) * | 2022-03-17 | 2022-06-28 | 浙江大华技术股份有限公司 | 主机切换的方法、装置、存储介质及电子装置 |
CN114722114A (zh) * | 2020-12-22 | 2022-07-08 | 金篆信科有限责任公司 | 节点切换方法、电子设备和计算机可读存储介质 |
CN115361269A (zh) * | 2022-07-08 | 2022-11-18 | 福建新大陆通信科技股份有限公司 | 一种应急广播设备热备份方法 |
CN115941450A (zh) * | 2022-12-13 | 2023-04-07 | 深圳市瑞沃德生命科技有限公司 | 用于板卡堆叠拓展的通信切换方法、装置、系统及介质 |
Families Citing this family (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107066480B (zh) | 2016-12-20 | 2020-08-11 | 创新先进技术有限公司 | 主备数据库的管理方法、系统及其设备 |
CN106815097A (zh) * | 2017-01-18 | 2017-06-09 | 北京许继电气有限公司 | 数据库容灾系统和方法 |
CN107506263A (zh) * | 2017-08-24 | 2017-12-22 | 深圳互联先锋科技有限公司 | 一种故障测试方法和装置 |
CN107632906A (zh) * | 2017-09-30 | 2018-01-26 | 北京九桥同步软件有限公司 | 数据库数据备份方法及装置 |
CN107967291B (zh) * | 2017-10-12 | 2019-08-13 | 腾讯科技(深圳)有限公司 | 日志条目复制方法、装置、计算机设备及存储介质 |
CN108897658B (zh) * | 2018-05-31 | 2023-03-21 | 康键信息技术(深圳)有限公司 | 主数据库监控方法、装置、计算机设备和存储介质 |
CN109947772A (zh) * | 2018-09-07 | 2019-06-28 | 网联清算有限公司 | 数据库自动切换方法、装置、存储介质及计算机设备 |
CN109388630B (zh) * | 2018-09-29 | 2020-09-29 | 京东数字科技控股有限公司 | 数据库切换方法、系统、电子设备和计算机可读介质 |
CN110166524B (zh) * | 2019-04-12 | 2023-04-07 | 未鲲(上海)科技服务有限公司 | 数据中心的切换方法、装置、设备及存储介质 |
CN110109934B (zh) * | 2019-05-08 | 2021-07-30 | 上海达梦数据库有限公司 | 一种数据库管理方法、装置、服务器及存储介质 |
CN110209554B (zh) * | 2019-06-14 | 2023-08-11 | 上海中通吉网络技术有限公司 | 数据库日志分发方法、装置及设备 |
CN110909171B (zh) * | 2019-10-16 | 2022-07-12 | 珠海格力电器股份有限公司 | 一种数据调度方法、装置、终端及存储介质 |
CN111460029B (zh) * | 2020-03-11 | 2024-04-19 | 中移动信息技术有限公司 | 数据同步方法和装置 |
CN113761054A (zh) * | 2021-01-22 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | 数据调取方法、装置、电子设备及存储介质 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101729290A (zh) * | 2009-11-04 | 2010-06-09 | 中兴通讯股份有限公司 | 用于实现业务系统保护的方法及装置 |
CN103064860A (zh) * | 2011-10-21 | 2013-04-24 | 阿里巴巴集团控股有限公司 | 数据库高可用实现方法及其装置 |
CN103780638A (zh) * | 2012-10-18 | 2014-05-07 | 腾讯科技(深圳)有限公司 | 数据同步方法及系统 |
Family Cites Families (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH08115323A (ja) * | 1994-10-18 | 1996-05-07 | Toppan Printing Co Ltd | 自動ページアップルール作成装置 |
US7043504B1 (en) * | 2000-04-10 | 2006-05-09 | International Business Machines Corporation | System and method for parallel primary and secondary backup reading in recovery of multiple shared database data sets |
CN101212458A (zh) * | 2006-12-25 | 2008-07-02 | 中兴通讯股份有限公司 | 一种数据库系统备份方法 |
CN101751394B (zh) * | 2008-12-16 | 2011-11-16 | 青岛海信传媒网络技术有限公司 | 数据同步方法和数据同步系统 |
US8442962B2 (en) * | 2010-12-28 | 2013-05-14 | Sap Ag | Distributed transaction management using two-phase commit optimization |
CN102810111B (zh) * | 2012-05-07 | 2016-05-11 | 互动在线(北京)科技有限公司 | 一种保持Oracle数据库服务高可用的实现方法和系统 |
CN102968457B (zh) * | 2012-10-30 | 2015-09-30 | 北京奇虎科技有限公司 | 数据库间切换方法和系统 |
CN102945195B (zh) * | 2012-11-26 | 2015-11-18 | 国电南瑞科技股份有限公司 | 一种基于SQLite数据库的主备冗余复制方法 |
CN103019875B (zh) * | 2012-12-19 | 2015-12-09 | 北京世纪家天下科技发展有限公司 | 一种实现数据库双主改造的方法及装置 |
CN103220183A (zh) * | 2013-05-02 | 2013-07-24 | 杭州电子科技大学 | 一种基于双主机热备份的Hadoop高可用性系统实现方法 |
CN103226502B (zh) * | 2013-05-21 | 2015-08-19 | 中国工商银行股份有限公司 | 一种数据灾备控制系统及数据恢复方法 |
-
2015
- 2015-04-29 CN CN201510213694.1A patent/CN106202075B/zh active Active
- 2015-09-14 WO PCT/CN2015/089553 patent/WO2016173179A1/fr active Application Filing
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101729290A (zh) * | 2009-11-04 | 2010-06-09 | 中兴通讯股份有限公司 | 用于实现业务系统保护的方法及装置 |
CN103064860A (zh) * | 2011-10-21 | 2013-04-24 | 阿里巴巴集团控股有限公司 | 数据库高可用实现方法及其装置 |
CN103780638A (zh) * | 2012-10-18 | 2014-05-07 | 腾讯科技(深圳)有限公司 | 数据同步方法及系统 |
Cited By (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108984569A (zh) * | 2017-06-05 | 2018-12-11 | 中兴通讯股份有限公司 | 数据库切换方法、系统和计算机可读存储介质 |
CN108834179A (zh) * | 2018-05-31 | 2018-11-16 | 深圳市酷达通讯有限公司 | 调整心跳周期的方法、服务器和客户端 |
CN108834179B (zh) * | 2018-05-31 | 2021-07-09 | 深圳市酷达通讯有限公司 | 调整心跳周期的方法、服务器和客户端 |
CN109086292A (zh) * | 2018-06-11 | 2018-12-25 | 平安科技(深圳)有限公司 | 一种数据库的切换方法及系统 |
CN109086292B (zh) * | 2018-06-11 | 2023-11-28 | 平安科技(深圳)有限公司 | 一种数据库的切换方法及系统 |
CN111258823A (zh) * | 2020-01-17 | 2020-06-09 | 青梧桐有限责任公司 | 一种主从服务器的切换方法及系统 |
CN113297002A (zh) * | 2020-02-21 | 2021-08-24 | 北京京东振世信息技术有限公司 | 数据库工作模式的切换方法和装置 |
CN113297002B (zh) * | 2020-02-21 | 2023-12-05 | 北京京东振世信息技术有限公司 | 数据库工作模式的切换方法和装置 |
CN112363865A (zh) * | 2020-10-19 | 2021-02-12 | 深圳云天励飞技术股份有限公司 | 数据库故障恢复方法、装置及人脸图像搜索系统 |
CN114722114A (zh) * | 2020-12-22 | 2022-07-08 | 金篆信科有限责任公司 | 节点切换方法、电子设备和计算机可读存储介质 |
CN114679399A (zh) * | 2022-03-17 | 2022-06-28 | 浙江大华技术股份有限公司 | 主机切换的方法、装置、存储介质及电子装置 |
CN115361269A (zh) * | 2022-07-08 | 2022-11-18 | 福建新大陆通信科技股份有限公司 | 一种应急广播设备热备份方法 |
CN115361269B (zh) * | 2022-07-08 | 2023-05-30 | 福建新大陆通信科技股份有限公司 | 一种应急广播设备热备份方法 |
CN115941450A (zh) * | 2022-12-13 | 2023-04-07 | 深圳市瑞沃德生命科技有限公司 | 用于板卡堆叠拓展的通信切换方法、装置、系统及介质 |
Also Published As
Publication number | Publication date |
---|---|
CN106202075A (zh) | 2016-12-07 |
CN106202075B (zh) | 2021-02-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2016173179A1 (fr) | Procédé et dispositif pour commutation de base de données primaire et de base de données secondaire | |
WO2017177941A1 (fr) | Procédé et appareil de commutation de base de données active/en attente | |
WO2019154394A1 (fr) | Système en grappes de bases de données réparties, procédé de synchronisation de données et support de stockage | |
EP2790112B1 (fr) | Procédé et système pour la synchronisation des données et appareil d'accès aux données | |
EP3617886B1 (fr) | Système de sauvegarde à chaud, procédé de sauvegarde à chaud et dispositif informatique | |
US9582382B1 (en) | Snapshot hardening | |
US9189348B2 (en) | High availability database management system and database management method using same | |
US7996718B1 (en) | Techniques for continuous data protection | |
US20070083641A1 (en) | Using a standby data storage system to detect the health of a cluster of data storage servers | |
WO2021226905A1 (fr) | Procédé et système de stockage de données, et support de stockage | |
CN106933843B (zh) | 数据库心跳检测方法以及装置 | |
CN101706795A (zh) | 主备服务器上数据库数据同步方法 | |
WO2014101424A1 (fr) | Procédé et système permettant de synchroniser une base de données répartie | |
CN113987064A (zh) | 数据处理方法、系统及设备 | |
WO2022088861A1 (fr) | Procédé et appareil de gestion d'anomalies de bases de données | |
CN112153134A (zh) | 一种容灾云主机的容灾演练方法、装置、设备及存储介质 | |
WO2017014814A1 (fr) | Réplication de volumes de mémoire | |
CN113535665B (zh) | 一种主数据库与备数据库之间同步日志文件的方法及装置 | |
CN110011853B (zh) | 一种面向多平台和集群的交叉故障排查方法及装置 | |
CN109684130B (zh) | 一种机房间数据备份的方法及装置 | |
CN112650629B (zh) | 区块链索引数据恢复方法、装置、设备和计算机存储介质 | |
CN118018463A (zh) | 一种故障处理方法、装置、设备及可读存储介质 | |
US11016863B2 (en) | Self-contained disaster detection for replicated multi-controller systems | |
US20150227599A1 (en) | Management device, management method, and recording medium for storing program | |
CN116737462A (zh) | 一种数据处理方法、系统、装置及介质 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 15890554 Country of ref document: EP Kind code of ref document: A1 |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 15890554 Country of ref document: EP Kind code of ref document: A1 |