Method and device for deploying active-active mechanism of ORACLE database

Abstract

The invention discloses an ORACLE database active-active mechanism deployment method and device, which can be used in the technical field of data processing, and the method comprises the following steps: building a second database; creating Topic which needs to be subjected to table synchronization by utilizing distributed message service; setting a database synchronization component, and introducing a transaction application in a Maven mode; according to a transaction generated by the transaction application, judging a transaction generation park, a database table and an operation type, and selecting a database for access according to a judgment result; after the transaction generated by the transaction application is executed, querying full-amount information of data to be synchronized by quoting an annotation provided by a database synchronization component, and writing the data to be synchronized into a specified Topic by the database synchronization component; creating a to-be-synchronized data consumer group, subscribing the specified Topic by the consumer group, pulling the to-be-synchronized message, and persisting the message to the current database according to the data in the current database and the data timestamp in the to-be-synchronized message.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for deploying an active-active mechanism of an Oracle database. Background technique [0002] At present, transaction applications launched by banks use Oracle databases when storing application transaction data, such as ICBC's "Merchant Home". refer to Figure 6 , which is a schematic diagram of merchant home deployment in the prior art. Among them, the database is usually deployed in the master-standby mode, and the database synchronization between the master database and the standby database is realized through Oracle DataGuard. When the primary database system or the hardware in the resource domain is abnormal, the primary-standby switchover mechanism provided by Oracle is used to complete the primary-standby switchover. It takes at least 30 minutes from the start of the emergency primary-standby switchover to the normal provision of services by t...

AI Technical Summary

Problems solved by technology

The present invention realizes the quasi-real-time data synchronization from the first database to the newly-built second database by building the second database and utilizing the characteristics of high concurrency, high throughput and high efficiency of distributed messages based on the bank's distributed message service platform; the application side By extending the MyBatis database access middleware, the transaction-level database access read-write separation is realized, the problem of service interruption caused by database abnormalities is solved, the business impact of service interruptions caused by database software and hardware abnormalities to users is reduced, and the stability and availability are effectively improved.

Images