- Oracle GoldenGate 11g Implementer's guide
- John P Jeffries
- 505字
- 2021-04-13 16:39:47
The first thing to consider and probably one of the most important steps in any IT project is the design. If you get this wrong, your system will neither perform nor be scalable, and ultimately the project will fail. The next project may be to address all the design issues and start again from scratch! Not ideal.
So how do you design our GoldenGate implementation? Where do you start? What is important in the design? There are obviously lots of questions, so let's try and answer them.
You have already seen the different solutions GoldenGate has to offer at the beginning of this chapter. You need to choose the most appropriate architecture based on the business requirements. To do this it is necessary to first understand the requirements of the system and what the system has to achieve. These requirements' are both functional and non-functional. Examples of non-functional requirements are performance and scalability.
To address the functional requirements you need to know:
- The overall system architecture and all of its components and interfaces. Ask yourself the question "what data do we need to replicate and to where?"
For the non-functional requirements, you need to know:
- The maximum latency that is acceptable. Again, ask yourself the question "how far behind the source can the target system(s) be?"
These are all important factors when considering a design. In the earlier section "Oracle GoldenGate Topology" in this chapter, we mentioned the use of parallel Extract and Replicate processes to increase data throughput. The number of parallel trails is largely dependent on the hardware footprint. How many CPU cores do I have? How much memory is available? Etc.
Other areas to consider are the Network and Database Schema design. Starting with the Network, this is fundamental to a data replication solution. If you have a slow network, you will not be able to replicate high volumes of data in real-time. Furthermore, should your network be unreliable, you need to consider the cost of retransmission or transmitting a backlog of trail files. Redundant networks are very important too and can help to alleviate this problem. If you can avoid the network outage altogether by routing data over a backup network, it will save a number of problems.
Database Schema design is another important consideration. Imagine a schema where every table is related to nearly every other table, and the cascading referential constraints are so complex, that it would be impossible to logically separate groups of related tables for data extract. GoldenGate does provide a solution to this problem by using the @RANGE
function. However, this is not ideal. Apart from the complex configuration, GoldenGate has to spend more CPU processing the configuration filters and artificially "splitting" the data into a pre-defined number of trails. A good schema design would be to ensure that logical separation exists between table groups, allowing a simple, effective configuration that performs well. The number of table groups being directly proportional to the number of Extract processes configured.
- Beginning Swift
- VR、AR與MR項目開發(fā)實戰(zhàn)
- AJAX and PHP: Building Modern Web Applications 2nd Edition
- 從零開始學(xué)LATEX
- OpenStack實戰(zhàn)指南
- SolidWorks 2019快速自學(xué)寶典
- VRP11/3ds Max虛擬現(xiàn)實制作標準實訓(xùn)教程
- 中文版After Effects CC 2018 動漫、影視特效后期合成秘技
- 新印象:CINEMA 4D電商設(shè)計基礎(chǔ)與實戰(zhàn)(全視頻微課版)
- 音樂日記:Studio One 6場景×風(fēng)格編曲實用教程
- Photoshop 2020實戰(zhàn)從入門到精通(超值版)
- Photoshop-CorelDRAW 基礎(chǔ)培訓(xùn)教程
- AI寫實人物繪畫關(guān)鍵詞圖鑒(Stable Diffusion版)
- Inkscape Starter (Microcontent)
- UG NX 9.0模具設(shè)計工廠實訓(xùn)