Oracle GoldenGate's Advanced Features and Best Practices: A Recap from OpenWorld
By Steve Wilkes on Oct 13, 2011
I was joined by Shan Nawaz of Verisign last Thursday morning for a great session covering best practices and advanced features of Oracle GoldenGate. Despite the rain; people recovering from the previous nights festivities; and coinciding with a whole bunch of cloud sessions and demos; we had pretty amazing attendance.
I kicked off by giving an overview of Oracle Data Integration and a quick crash course on Oracle GoldenGate for the few in the audience not familiar with out technology.
After that, I handed over to Shan, who did a terrific job covering some of the best practices for getting optimal performance out of Oracle GoldenGate. He started off with an image that truly summarizes the difference GoldenGate can make to an enterprise:
Shan then moved on to cover a number of philosophies and techniques that he had used successfully to maximize the potential of Verisign’s investment in Oracle GoldenGate, including:
- Making sure you understand what the data integration requirements are before you start. What is the primary objective of using GoldenGate? What is the maximum throughput you expect, and maximum latency you can accept? If you don’t know these things, you won’t be able to measure success.
- Learning when you might need to consider parallel data streams to handle maximum load, and what functionality is available to help you achieve that.
- Determining the impact of I/O on GoldenGate processes and architecting solutions to minimize this.
- Improving the performance of the GoldenGate Capture, Pump and Delivery processes and optimal tuning of network components.
This was followed by my Advanced Features portion of the session, in which I highlighted some of the less commonly known aspects of Oracle GoldenGate functionality. I covered:
- The Event Marker Infrastructure – which allows GoldenGate processes to take specific actions whenever they encounter certain database records
- Flat File Integration – which adds micro-batch file delivery capabilities to GoldenGate
- Java Integration – which enables GoldenGate to invoke Java APIs based on database events; and provides capture and delivery of data using a JMS message bus
Finally, I gave a preview of some future (next calendar year) functionality that aims to enable Oracle GoldenGate to directly integrate with Oracle Coherence and Oracle TopLink to allow database changes to immediately trigger cache changes. This should help solve a number of use-cases where cached data may become stale if the underlying data changes.
With so much content, we didn’t have much time for Q&A, but still managed to have quite a lively, if brief, Q&A session. Shan had to leave quickly to catch an international flight, but still graciously answered some in-depth questions and swapped contact information with another customer so they could continue the conversation off-line.
It was a pleasure to present with Shan, and I am looking forward to similar sessions at Oracle OpenWorld 2012.