Shulou(Shulou.com)06/01 Report--

This article is mainly about how GoldenGate helps data from MySQL to Oracle to achieve real-time synchronization. If you are interested, let's take a look at this article. I believe that after reading GoldenGate to help MySQL to Oracle data to achieve real-time synchronization, it is of some reference value to everyone.

Step 1: configure mysql

Modify the configuration file my.ini

# for goldengate

Log-bin = "C:\ mysql\ logbin\ logbin.log"

Binlog-format = ROW

Log-bin-index = "C:\ mysql\ logindex"

Binlog_cache_size=32m

Max_binlog_cache_size=512m

Max_binlog_size=512m

Add database user ggs with DBA permission

Step 2: install and configure GoldenGate on mysql CVM

Create mgr.prm

PORT 7809

DYNAMICPORTLIST 7840-7914

STARTUPVALIDATIONDELAY 5

PURGEOLDEXTRACTS C:\ ogg\ dirdat\ *, USECHECKPOINTS, MINKEEPDAYS 7

LAGREPORTHOURS 1

LAGINFOMINUTES 30

LAGCRITICALMINUTES 45

Create the extraction process parameter ext1.prm

-- ext1.prm

EXTRACT ext1

SOURCEDB test@localhost:3306, USERID ggs, PASSWORD 123

DISCARDROLLOVER ON FRIDAY

DISCARDFILE C:\ ogg\ dirrpt\ ext1.dsc, APPEND, MEGABYTES 1024

WARNLONGTRANS 2h, CHECKINTERVAL 3m

REPORTCOUNT EVERY 30 MINUTES, RATE

EXTTRAIL C:\ ogg\ dirdat\ ex

DYNAMICRESOLUTION

NUMFILES 5000

TABLE test.test1

Add extraction process ext1

ADD EXTRACT ext1, tranlog, begin now

ADD EXTTRAIL C:\ ogg\ dirdat\ ex, EXTRACT ext1, megabytes 100

Create the propagation process parameter dp1.prm

-- dp1.prm

EXTRACT dp1

RMTHOST 172.27.35.28, MGRPORT 7809,COMPRESS

RMTTRAIL d:\ ogg\ dirdat\ ex

PASSTHRU

NUMFILES 5000

DYNAMICRESOLUTION

TABLE test.*

Add extraction process dp1

ADD EXTRACT dp1, EXTTRAILSOURCE C:\ ogg\ dirdat\ ex

ADD RMTTRAIL d:\ ogg\ dirdat\ ex, EXTRACT dp1, MEGABYTES 100

Step 3: configure defgen

Create a defgen parameter

-- defgen.prm

Defsfile C:\ ogg\ dirdef\ defgen.prm

Sourcedb test@localhost:3306, userid ggs,password 123

Table test.test1

Generate defgen file

Defgen paramfile C:\ ogg\ dirprm\ defgen.prm

Copy the file defgen.prm in the C:\ ogg\ dirdef directory to the appropriate directory on the target side, that is, the directory.\ dirdef.

Step 4: Oracle environment preparation

Create a database user

Create tablespace ggs datafile'. Size 200m

Create user ggs identified by 123 default tablespace ggs

Grant dba to ggs

Step 5: install and configure GoldenGate on Oracle CVM

Create a mgr parameter

-- mgr.prm

PORT 7809

DYNAMICPORTLIST 7840-7914

STARTUPVALIDATIONDELAY 5

PURGEOLDEXTRACTS d:\ ogg\ dirdat\ *, USECHECKPOINTS, MINKEEPDAYS 7

LAGREPORTHOURS 1

LAGINFOMINUTES 30

LAGCRITICALMINUTES 45

Create the replication process parameter rep1.prm

-- rep1.prm

Replicat rep1

Sourcedefs D:\ ogg\ dirdef\ defgen.prm

Userid ggs,password ggs

Reperror default,discard

Discardfile D:\ ogg\ dirrpt\ rep1.dsc,append,megabytes 50

Dynamicresolution

Map test.test1, target test.test1

Add replication process

Dblogin userid ggs password 123

Add checkpointtable chkpnttab

Add replicat rep1,exttrail D:\ ogg\ dirdat\ ex, checkpointtable chkpnttab

Is the above details about GoldenGate helping to synchronize data from MySQL to Oracle in real time? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.