Database Storage Engine
Requirements for the database storage engine are as follows:
-
Oracle GoldenGate supports the InnoDB storage engine for a source MySQL database.
-
All the components of Oracle GoldenGate for MySQL, including Extract, Replicat, and Admin Client connect to the database using the MySQL native API.
-
Oracle GoldenGate supports capture and apply from and to the InnoDB engine. Apply to MyISAM engine works, but there might be data integrity issues as MyISAM engine in non-transactional.