By Jinyu Wang on Dec 28, 2013
Author: Nick Wagner, Director of Product Management for Oracle GoldenGate
Oracle GoldenGate 22.214.171.124.7 cumulative patch release is now generally available and can be downloaded from the My Oracle Support website. This patch includes support for MySQL NDB Cluster 7.1 and 7.2, as well as Sybase ASE 15.7 support. There are number of fixes and stabilization enhancements in this release, especially for those using the Oracle GoldenGate Management Pack to monitor GoldenGate.
The full list of fixed tickets
in each release can be found in the release notes available here.
One of the key differentiators of Oracle GoldenGate in the real-time data integration and data replication technology space is its heterogeneity. It provides log-based change data capture, routing, transformation, and delivery between heterogeneous systems. MySQL is one of the heterogeneous platforms that GoldenGate can support both as source and target.
The most common ways Oracle GoldenGate is used with MySQL are real-time data warehousing, real-time reporting, and query offloading. In real-time data warehousing use case, Oracle GoldenGate feeds online transaction data from Web properties running on MySQL databases to the data warehouse in real time, to enable a complete and reliable view of the business operations. Oracle GoldenGate can feed all major data warehouses including Oracle Exadata, Teradata, IBM Netezza, Greenplum etc.
MySQL is heavily used for departmental enterprise applications including analytical systems. Oracle GoldenGate can deliver real-time data from production OLTP systems to data marts running on MySQL to support operational reporting and analytical applications. This enables analytical systems to have access to up-to-date information when supporting operational decision making.
Last but not least, GoldenGate can enable query offloading from production OLTP systems that may be on a mainframe (such as DB2 z/Series) or open systems (such as MSFT SQL Server or Sybase ASE). Oracle GoldenGate can move all or a portion of transactional data in real time from production databases to MySQL databases to allow the end users to run their queries and reports on the dedicated server rather than on the production server. This approach is a great way to reduce TCO and maximize the performance of production OLTP systems. In addition, it allows to optimize the database for reporting purposes. Especially in travel and ecommerce industry it helps reduce browsing activity related overhead on OLTP systems.
To read more about how to leverage Oracle GoldenGate please check out our new MySQL and Oracle GoldenGate spotlight document and check the additional resources provided.
Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality