Oracle Blog

Inside Oracle's Data Integration community

Tuesday 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.