Database multi-activity method and device

Abstract

The invention provides a database multi-activity method and a device. The method comprises the steps of obtaining to-be-multi-activity database nodes in a database architecture; for each database nodeto be active, obtaining data to be written; storing the to-be-written data to a to-be-active database node; synchronizing the to-be-written data to other to-be-activated database nodes of the database architecture in real time; data synchronization among the database nodes to be active is realized; according to the method, through obtaining to-be-written data of each to-be-active database node; storing the data to be written into a database node to be active, synchronizing the to-be-written data to other to-be-activated database nodes of the database architecture in real time, data synchronization between the database nodes to be active is realized, the situation that the whole service or part of the service is unavailable due to the failure of a single database is avoided, multiple activities of simultaneously providing the service by multiple database nodes are realized, and the disaster tolerance capability is improved.

Description

Technical field [0001] This application relates to the field of database technology, and in particular to a method and device for multiple active databases. Background technique [0002] With the development of the company's business, based on the consideration of disaster tolerance and business scalability, business systems have more and more requirements for the database. For example, for a certain business, if one or a single database system fails, it will cause the entire business to access abnormally, resulting in business interruption; on the other hand, the read and write capabilities of a single database are restricted by the server hardware resources. Continuous expansion also requires more sets of databases to provide corresponding read and write services. [0003] In related technologies, for centralized-architecture databases, through the establishment of a backup database method, the main library reads and writes, and the standby database is read-only to achieve read-...

AI Technical Summary

Problems solved by technology

However, for a database with a centralized architecture, once the main database fails, services related to the writing scenario will not be able to continue to provide services, and it will not be possible to achieve true "database multi-active", and the disaster recovery capability is poor; for databases with a distributed architecture, If a node fails, other nodes can still provide corresponding database services, but the data of the failed node is different from that of other nodes, and the business services related to the failed database node will not be available, and it is impossible to achieve the real "multiple databases". Live", poor disaster tolerance

Images