By Irem Radzik-Oracle on Oct 25, 2011
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.