GoldenGate supports the lowest MySQL version 5.1.5

GoldenGate supports the lowest MySQL version 5.1.5

GoldenGate's official documentation clearly states that GoldenGate needs to set the MySQL Log format (binlog_format) to ROW, and the other two formats (MIXED or STATEMENT) are not supported.

######################################## ################################ The official description is as follows:

Binlog_format: This parameter sets the format of the logs. it must be set to the value of ROW, which directs the database to log DML statements in binary format. any other log format (MIXED or STATEMENT) causes Extract to abend.

######################################## ################################

However, MySQL versions earlier than 5.1.5 do not support ROW and MIXED formats (MySQL 5.1.5 introduces ROW and 5.1.8 introduces MIXED)

#### Official description: http://dev.mysql.com/doc/refman/5.1/en/binary-log-formats.html

Support for row-based logging was added in MySQL 5.1.5. mixed logging is available beginning with MySQL 5.1.8. in MySQL 5.1.12, MIXED become the default logging mode; in 5.1.29, the default was changed back to STATEMENT for compatibility with MySQL 5.0.

######################################## ################################

Currently, the customer's MySQL version is 5.0.6-beta:

D: \ mysqlserver 5.0 \ bin> MySQL-u root-p

Enter password :*****

Welcome to the MySQL monitor. Commands end with; or \ g.

Your MySQL connection id is 111 to server version: 5.0.6-beta-nt-log

 

Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.

 

Mysql> select version ();

+ ------------------- +

| Version () |

+ ------------------- +

| 5.0.6-beta-nt-log |

+ ------------------- +

1 row in set (0.02 sec)

 

This version does not support binlog_format = ROW. Therefore, after GolenGate is installed, when the extraction process is started, the process abend

######################################## ################################ The following error message is displayed:

16:55:16 ERROR OGG-00146 VAM function VAMRead returned unexpected result: error 600-VAM Client Report <cause of failure: STATEMENT or MIXED level logging found so abending

When failed: While reading log event from binary log

Where failed: MySQLBinLog Reader Module

Context of failure: No Information Available!>

Therefore, if you want to use GoldenGate for real-time MySQL Data Synchronization, You need to upgrade the MySQL version to 5.1.5 or later.

GoldenGate unidirectional table DML Synchronization

Oracle GoldenGate series: restoration principles of Extract processes

Oracle GoldenGate installation Configuration

OGG-01004 OGG-1296 error for Oracle goldengate

Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations

This article permanently updates the link address: