- Installing and Configuring Oracle GoldenGate for Oracle Database (12.1.2) - Configuring DDL Support
- Oracle GoldenGate for Teradata Installation and Setup Guide (11.2.1)- Configuring DDL Synchronization for a Teradata Database (PDF) (Teradata Capture support till TD 14.10 in GoldenGate 12.1.2.
No, Only GoldenGate for Oracle and Teradata support DDL replication. The following are document for references:
0 Comments
Note: This is the current version of GoldenGate for MySQL.
Oracle GoldenGate for MySQL enables the near real-time data replication between MySQL databases and other databases supported by Oracle GoldenGate. The replication can be either one-way or bi-directional, and can replicates DML operations (including insert, update, delete, truncate) from MySQL binlog. Different from Oracle GoldenGate for Oracle, Oracle GoldenGate for MySQL doesn't provide DDL replication or BATCHSQL support.
This version supports MySQL Enterprise Edition and Community Edition as well as MySQL Cluster shown as follows:
Note: GoldenGate for MySQL 12.1.2.1.1 was released 10/15/2014.This version is no longer the latest version after GoldenGate 12.2.0.1 version in October 2015.
Oracle GoldenGate for MySQL enables the near real-time data replication between MySQL databases and other databases supported by Oracle GoldenGate. The replication can be either one-way or bi-directional, and can replicates DML operations (including insert, update, delete, truncate) from MySQL binlog. Different from Oracle GoldenGate for Oracle, Oracle GoldenGate for MySQL doesn't provide DDL replication or BATCHSQL support.
This version supports MySQL Enterprise Edition and Community Edition as well as MySQL Cluster shown as follows [2] [3]:
Resources
(Created 10/15/2014)
Timestamp - Microseconds are getting trimmed When replicating from Oracle to MySQL with OGG 11.2.1 (Doc ID 1595655.1)
Details: The error is shown as follows:
GGSCI (oraclelinux6.localdomain) 5> dblogin sourcedb test@localhost:3305 userid root Password: 2014-07-22 15:13:33 WARNING OGG-00769 MySQL Login failed: . SQL error (2002). Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). ERROR: Failed to connect to MySQL database engine for HOST localhost, DATABASE test, USER root, PORT 3305.
Answer: The reason is the file doesn't exist in the /tmp folder. Oracle Golden Gate for MySQL by default requires the access of the MySQL socket file. By default, it is /tmp/mysql.scok If the file is not in the folder you can create a symbolic link as follows:
ln -s /home/oracle/software/mysql_5.5.38/data/mysql.sock /tmp/mysql.sock
If you have multiple MySQL instances on the same server (For example, in my environment, I have MySQL 5.5, 5.6 and 5.7 setup in one machine). you can set the MYSQL_UNIX_PORT environment variable as follows:
MYSQL_UNIX_PORT=/home/oracle/software/mysql_5.6.19/data/mysql.sock export MYSQL_UNIX_PORT
When using Oracle GoldenGate you can use the SETENV set as follows:
SETENV (MYSQL_UNIX_PORT='/home/oracle/software/mysql_5.6.19/data/mysql.sock')
This will address the issue.
References
(Created: 7/2/2014 Last Reviewed: 6/14/2015)
|
GoldenGate for MySQLOracle GoldenGate for MySQL replicates DML operations for MySQL databases. Here, I discuss Oracle GoldenGate for MySQL, MySQL database and MySQL replication. Top Posts
Resources
Buzzwords
Heterogeneity Security High Performance Real-Time DML Globalization Archives
February 2018
Categories
All
|