mysql_to_mysql的gg簡單配置

測試gg版本：Oracle GoldenGate Command Interpreter for MySQL Version 12.1.2.0.0
源端MySQL需要修改：binlog_format=row

源端執行:
GGSCI (host100) 15> view param e_test

extract e_test
sourcedb tttt@localhost:3388, userid root, password xxxx
TranLogOptions AltLogDest /data/mysql5.5/mysql/mysql-bin.index
RMTHOST 192.168.1.101, MGRPORT 7809
RMTTRAIL ./dirdat/nn

table tttt.zgp;

add extract e_test tranlog, begin now

add rmttrail ./dirdat/nn, extract e_test, megabytes 20

目標端：
GGSCI (host101) 58> view param r_test

replicat r_test
targetdb test@127.0.0.1:3306,userid root, password xxxx
ASSUMETARGETDEFS                  
reperror default,abend
discardfile /data/ggs_mysql/r_test.dsc,append,megabytes 10

map tttt.zgp, target test.zgp;

add replicat r_test, exttrail ./dirdat/nn, nocheckpoint

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20625855/viewspace-1110279/，如需轉載，請註明出處，否則將追究法律責任。