Goldengate minimum version supported for MySQL 5.1.5

goldengate ' indicates that goldengate Span style= "font-family: ' The song body '; color: #1f497d;" You need to mysql binlog_format ) set to row , the other two formats ( mixed or STATEMENT "is not supported.

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

Binlog_format : This parameter sets the format of the logs. It must is 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.

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

butMySQLin version5.1.5before is not supportedROWand theMIXEDFormat (MySQL 5.1.5introducedROW,5.1.8introducedMIXED)

####   The official description is as follows: http://dev.mysql.com/doc/refman/5.1/en/binary-log-formats.html

Support for row-based logging is 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 is changed back to STATEMENT For compatibility with MySQL 5.0.

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

the current customer's MySQL version is 5.0.6-beta version:

D:\MySQL Server 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 is not supported Binlog_format=row , so the installation is good golengate when you start the extraction process, the process Abend

######################################################################## The following is an error message:

2014-09-16 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!>

So if you want to use goldengate to achieve real-time synchronization of MySQL data, you need to upgrade the MySQL version to 5.1.5.

This article is from the "cheney.yu" blog, make sure to keep this source http://cheneyyu.blog.51cto.com/173219/1553525

Goldengate minimum version supported for MySQL 5.1.5