使用oracle GoldenGate 实现mysql5.5到 db210.5 单向复制?

小弟不才,求指教。需求如题。请分析下是哪里配置错了,希望可以做一个简单的demo学习一下
目前两端运行状态都为RUNNING,两端ggserr.log都没有error信息,检查路径都正确,就是无法复制数据
mysql 源端
捕获和投递进程配置如下:
GGSCI (mysql_s DBLOGIN as root) 6> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTR01 00:00:00 02:10:04
EXTRACT RUNNING PUMP01 00:00:00 00:00:03

GGSCI (mysql_s DBLOGIN as root) 7> view param mgr

PORT 7809
--autorestart extract *,waitminutes 2,resetminutes 5
lagreporthours 1
laginfominutes 30
lagcriticalminutes 45
PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, MINKEEPHOURS 1

GGSCI (mysql_s DBLOGIN as root) 8> view param extr01

extract extr01
setenv (MYSQL_HOME="/usr/local/mysql")
tranlogoptions altlogdest /data/mysql/mysql-bin.index
sourcedb yqdb@192.168.0.123:3306,userid root,password 123456
exttrail /usr/local/ogg_mysql/dirdat/e2
--dynamicresolution
gettruncates
table yqdb.ecs_order_info;

GGSCI (mysql_s DBLOGIN as root) 9> view param pump01

extract pump01
rmthost 192.168.0.122,mgrport 7809
rmttrail /usr/local/ogg_db2/dirdat/r2
--rmttask replicat,group repl01
passthru
gettruncates
table yqdb.ecs_order_info;

add extract extr01,tranlog,begin now
add exttrail /usr/local/ogg_mysql/dirdat/e2,extract extr01

add extract pump01,exttrailsource /usr/local/ogg_mysql/dirdat/e2,BEGIN now
add rmttrail /usr/local/ogg_db2/dirdat/r2,extract pump01

查资料异构需要配置defgen,也完成了生成和传输到目标端的步骤
view param defgen

defsfile /usr/local/ogg_mysql/dirdef/defgen.prm
sourcedb yqdb@192.168.0.123:3306, userid root,password 123456
table yqdb.ecs_order_info;

db2 目标端
GGSCI (db2_t) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING REPL01 00:00:00 00:00:04

view param mgr

PORT 7809

GGSCI (db2_t) 2> view param repl01

replicat repl01
targetdb aedw userid etlusr,password 123456
discardfile /usr/local/ogg_db2/dirrpt/repl01.dsc,append,megabytes 50
--dynamicresolution
map yqdb.ecs_order_info, target etlusr.ecs_order_info;

参与3

1同行回答

zftangzftang其它小白一枚
看下mysql的binlog日志显示全部

看下mysql的binlog日志

收起
互联网服务 · 2020-04-30
浏览1003

提问者

yq0211
数据仓库工程师mll

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2018-05-09
  • 关注会员:2 人
  • 问题浏览:1713
  • 最近回答:2020-04-30
  • X社区推广