ogg 从mysql同步oracle 可以实现ddl 同步吗?
写回答
提问于2021-03-01
ogg 从mysql同步oracle 可以实现ddl 同步吗?

ogg 从mysql同步oracle 可以实现ddl 同步吗?

问题补充
写回答
1条回答
默认
最新
你好我是李白
2021-03-01

下面摘自OGG 18.1官方文档,MySQL支持的对象以及操作,可以看到支持DDL,并不是所有DDL都支持,具体版本的同样可以参考相应版本官方文档。

https://docs.oracle.com/en/middleware/goldengate/core/18.1/hetergeneous-db/understanding-whats-supported-mysql.html#GUID-DA5CE4D3-8336-4EC8-8894-A86880D2066B

Oracle GoldenGate for MySQL supports the following objects and operations:

Basic extraction and replication of DDL (data definition language) operations for MySQL 5.7.10 and later. Only the CREATE TABLE, ALTER TABLE, and DROP TABLE operations are supported.

Oracle GoldenGate supports the extraction and replication of transactional tables.

Oracle GoldenGate supports transactional tables up to the full row size and maximum number of columns that are supported by MySQL and the database storage engine that is being used. InnoDB supports up to 1017 columns.

Oracle GoldenGate supports the AUTO_INCREMENT column attribute. The increment value is captured from the binary log by Extract and applied to the target table in a Replicat insert operation.

Oracle GoldenGate supports the following DML operations on source and target database transactional tables:

Insert operation

Update operation (compressed included)

Delete operation (compressed included); cascade delete queries result in the deletion of the child of the parent operation

Truncate operation

Oracle GoldenGate can operate concurrently with MySQL native replication.

Oracle GoldenGate supports the DYNSQL feature for MySQL.

0
0
0
回复问题
问题信息
请登录之后查看
邀请作答
暂无人订阅该标签,敬请期待~~
高分悬赏