Oracle GoldenGate Introduction Database Synchronous geo-replication scheme

oraclegoldengateIntroduction

GOLDENGATETDM (transaction data management) software is a log-based structured data replication software, which through the analysis of the source database online log or archive log to obtain data deletion and change, and then apply these changes to the target database, to achieve the source database and target database synchronization, dual-live. goldengatetdm software enables a large amount of data sub-second-level real-time replication between heterogeneous IT infrastructures, including almost all common operating system platforms and database platforms. The copying process is as follows:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/72/B6/wKiom1Xr0OXhI7nwAAG5qyimZ5A515.jpg "title=" 1.jpg " alt= "Wkiom1xr0oxhi7nwaag5qyimz5a515.jpg"/>

as shown, GoldenGate TDM The data replication process is as follows:

1

take advantage of the snapping process read on the source system side onlineredo Log or archive Log and then parse to extract only the changes in the data, such as add, delete, and change operations, and convert the relevant information to goldengatetdm The Custom intermediate format is stored in the queue file. The routing process is then used to pass the queue file through the tcp/ip Transferred to the target system. The capture process finishes reading log The data changes in and after the data is transferred to the target system, a checkpoint is written, recording the log location, the presence of checkpoints allows the capture process to continue copying from the checkpoint location after aborting and resuming;

2

the target system accepts data changes and caches them to GoldenGate TDM queue, the queue is a series of temporary storage data changes files, waiting for the delivery process to read data;

3

GoldenGate TDM The delivery process reads the data changes from the queue and creates the corresponding SQL statement, which executes through the local interface of the database, commits to the database after it has been successfully updated with its checkpoint, records the location where replication has completed, and the data replication process is finalized.

This shows that GoldenGate TDM is a software-based approach to data replication that parses data from a database's logs (the amount of data is only about One-fourth of the log). GOLDENGATETDM transforms data into its own format, directly over a TCP/IP network, without relying on the way the database itself is delivered, and by up to 9:1 Compression of the data, which can greatly reduce the bandwidth requirements. On the target side,GOLDENGATETDM can greatly accelerate the speed and efficiency of data delivery, reduce the resource consumption of target system, and realize the replication of large amount of data at sub-second level by means of trade reorganization, batch loading and other technology, and the target database is active

GoldenGate TDM provides a flexible application solution, based on its advanced, flexible technology architecture can be based on user requirements to form a variety of topologies:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/72/B2/wKioL1Xr0xnAzg7LAAHDTLbjwBc634.jpg "title=" 2.jpg " alt= "Wkiol1xr0xnazg7laahdtlbjwbc634.jpg"/>

GOLDENGATETDM can provide reliable data replication, mainly reflected in the following three points:  

Ensure transactional consistency

GOLDENGATETDM The Order of replication database transactions in the disaster recovery database is the same as in the Production Center database, and the same transactional environment commits to ensure the integrity and read consistency of the data on the target system, creating conditions for real-time query and transaction processing.  

Checkpoint mechanism ensures no loss of data.

GoldenGate TDM the extraction and replication process uses the checkpoint mechanism to record where the replication has completed. For the extraction process, its checkpoint records the location of the currently extracted log and the location of the write queue file, and for the delivery process, its checkpoint records the location of the current read queue file. The checkpoint mechanism ensures that no data is lost after a system, network, or GoldenGate TDM process failure restart.

Reliable data transfer mechanism

GOLDENGATETDM The transaction data is transmitted by the response mechanism, and the data transfer is not considered until the confirmation message is received, otherwise the transfer of the information will be automatically transferred, thus ensuring that all the extracted data can be sent to the backup side. The data transmission process supports both the encryption and compression functions.

Oracle the company's Goldengate products enable data capture, conversion, and delivery of a large amount of data in a second level across heterogeneous IT infrastructures. Goldengate can support almost all common operating systems such as and database platforms, as shown in the following table:

Operating system	Database
MS NT, +, XP, Linux, Sun Solaris, HP-UX, IBM AIX, HP NonStop, TRU64, IBM z/Os , os/390	Oracle, DB2, MS SQL Server, MySQL, Enscribe, SQL/MP, Sql/mx, Sybase, Teradata, other ODBC-compatible databases

This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://pizibaidu.blog.51cto.com/1361909/1691878

Oracle GoldenGate Introduction Database Synchronous geo-replication scenario