暂无图片
ogg 从mysql同步oracle 可以实现ddl 同步吗?
我来答
分享
Jiang
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
暂无图片
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏