- Oracle GoldenGate 11g Implementer's guide
- John P Jeffries
- 434字
- 2021-04-13 16:39:47
The Oracle GoldenGate topology is a representation of the databases in a GoldenGate environment, the GoldenGate components configured on each server, and the flow of data between these components.
The flow of data in separate trails is read, written, validated and check-pointed at each stage. GoldenGate is written in C and because it is native to the operating system, can run extremely fast. The sending, receiving, and validation have very little impact on the overall machine performance. Should performance become an issue due to the sheer volumes of data being replicated, you may consider configuring parallel Extract and/or Replicat processes.
The following sections describe the process topology. Firstly discussing the rules that you must adhere to when implementing GoldenGate, followed by the order in which the processes must execute for end to end data replication.
When using parallel Extract and/or Replicat processes, ensure you keep related DDL and DML together in the same process group to ensure data integrity. The topology rules for configuring the processes are as follows:
- All objects that are relational to an object are processed by the same group as the parent object
- All DDL and DML for any given database object are processed by the same Extract group and by the same Replicat group
Should a referential constraint exist between tables, the child table with the foreign key must be included in the same Extract and Replicat group as the parent table having the primary key.
If an Extract group writes to multiple trails that are read by different Replicat groups, the Extract process sends all of the DDL to all of the trails. It is therefore necessary to configure each Replicat group to filter the DDL accordingly.
The following tables show the position of each link in the process topology for the two fundamental configuration types:
In terms of performance monitoring, the GGSCI tool provides real-time statistics as well as comprehensive reports for each process configured in the GoldenGate topology. In addition to reporting on demand, it is also possible to schedule reports to be run. This can be particularly useful when performance tuning a process for a given load and period.
The INFO ALL command provides a comprehensive overview of process status and lag, whereas the STATS option gives more detail on the number of operations. Both commands offer real-time reporting. This is demonstrated in the following screen shots:
From the screenshot you can see that the STATS command provides daily and hourly cumulative statistics for a given process, including the overall total and the latest real-time figures.
- 性能測試從零開始
- 中文版CorelDRAW X7基礎培訓教程（移動學習版）
- Maya影視動畫高級模型制作全解析
- Inkscape 0.48 Illustrator's Cookbook
- 人臉識別算法與案例分析
- 中文版AutoCAD 2014高手之道
- Photoshop CC 2017從入門到精通
- UI功夫：PC和APP界面設計全流程圖解
- 學摳圖：Photoshop專業摳圖技法案例教程
- 中文版Photoshop CS6從新手到高手（超值版）
- Building Websites with VB.NET and DotNetNuke 4
- 中文版CINEMA 4D R20 實用教程
- Refactoring with Microsoft Visual Studio 2010
- Revit建模進階標準教程（實戰微課版）
- NumPy 1.5 Beginner's Guide