First, Oracle GoldenGate for MySQL provides the real-time data replication to capture and deliver data for MySQL databases. The data repliation has the following main features:
- It can capture and deliver DML (Insert,update and delete) and truncate operations.
- It can capture and deliver data for MySQL databases and MySQL clusters.
- It can capture from both the primary and slave databases in a MySQL replication group.
- It is supported by GoldenGate Studio and Oracle GoldenGate Monitor.
Second, different from Oracle GoldenGate for DB2 which uses DB2 APIs to retrieve data, Oracle GoldenGate for MySQL captures data directly from MySQL binary log. It then delivers the data via connecting to MySQL database and applying the SQL commands.
The current version of Oracle GoldenGate for MySQL is 12.2. This version supports MySQL 5.5, 5.6 and 5.7 (certification matrix). You can download the latest version at support.oracle.com.