The Ultimate Guide to High Availability with MariaDB

Comments - Oracle GoldenGate cannot Extract Mariadb 10.2.9 binlog to Oracle 12c

4 years, 11 months ago Chris Calender
Re: Oracle GoldenGate cannot Extract Mariadb 10.2.9 binlog to Oracle 12c

"For MariaDB version 10.2 and later, Oracle GoldenGate works in the same as for MySQL but a new variable user needs to be configured in the my.cnf or my.ini file. The variable that needs to be added is "binlog-annotate-row-events=OFF". Restart MariaDB after configuring this variable and then start the Extract process."

https://docs.oracle.com/en/middleware/goldengate/core/18.1/hetergeneous-db/preparing-and-configuring-system-oracle-goldengate.html#GUID-883B54B6-6FD1-49CB-B11B-C041CF075363

 
3 years, 2 months ago Chris Calender
Re: Oracle GoldenGate cannot Extract Mariadb 10.2.9 binlog to Oracle 12c [Answer]

To be clear, you should have all of the following set:

log-bin
binlog-format=ROW
binlog-row-image=FULL
binlog-annotate-row-events=OFF
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.