This tutorial provides a step-by-step example for setting up an one-way replication between Informix IDS databases.
0 Comments
Oracle GoldenGate for MySQL enables the near real-time data replication between MySQL databases and other databases supported by Oracle GoldenGate. The replication can be either one-way or bi-directional, and can replicates DML operations (including insert, update, delete, truncate) from MySQL binlog. Different from Oracle GoldenGate for Oracle, Oracle GoldenGate for MySQL doesn't provide DDL replication or BATCHSQL support.
The latest version of Oracle GoldenGate for MySQL is 12.1.2.1.1 (released on 10/15/2014) on OTN and eDelivery. Note This post is updated after the release of Oracle GoldenGate for MySQL 12.1.2.1.1 on 10/15/2014. Oracle GoldenGate for MySQL enables the near real-time data replication between MySQL databases and other databases supported by Oracle GoldenGate. The replication can be either one-way or bi-directional, and can replicates DML operations (including insert, update, delete, truncate) from MySQL binlog. Different from Oracle GoldenGate for Oracle, Oracle GoldenGate for MySQL doesn't provide DDL replication or BATCHSQL support. The latest version of Oracle GoldenGate for MySQL is 12.1.2.0.0. The latest patch is This version supports MySQL Enterprise Edition as well as MySQL Cluster shown as follows [2]:
For more information about Oracle GoldenGate for MySQL, please refer to the Oracle documentation. References
Let's discuss the configuration steps needed for Informix IDS database to enable Oracle GoldenGate replications. Informix 11.70 is used as the example here. Step 1: Installing Informix IDS Database
You can skip this step if an Informix IDS database is already installed. (1) Log in the root user and create a user called informix >groupadd informix >useradd -g informix -d /home/informix informix You can see the new group created in /etc/group: informx:x:501: The user information in /etc/passwd: informix:x:501:501::/home/informix:/bin/bash Set the user password as follows: >passwd informix Changing password for user informix. New UNIX password: BAD PASSWORD: it is based on a dictionary word Retype new UNIX password: passwd: all authentication tokens updated successfully. Log on as the informix user (or use su -l informix) to check the server has informix uid defined locally. (2) Log in as the informix user and unzip/untar the informix ship home (iif.11.70.FC7DE.linux-x86_64.tar) locally to $INFORMIX_SHIPHOME (i.e./home/informix/software/11.70) folder. tar -xvf iif.11.70.FC7DE.linux-x86_64.tar Run the following command to perform the installation as root user: ./ids_install In my setup, installation path is: /home/informix/ifx1170. For Informix 11.5 and 12.1, I use the following path:
Next, please check the available port numer in your system. An example Port# could be:
(3) Setup the Informix Database Environment Variable Informix installation creates the script to help setup the environment including:
. /home/informix/ifx1170/ol_informix1170.ksh export LD_LIBRARY_PATH=${INFORMIXDIR}/lib:${INFORMIXDIR}/lib/cli: ${INFORMIXDIR}/lib/esql:$LD_LIBRARY_PATH; export LIBPATH=${INFORMIXDIR}/lib:${INFORMIXDIR}/lib/cli:${INFORMIXDIR}/lib/esql:$LIBPATH; export ODBCINI=/etc/odbc.ini (3) Start the instance >oninit -v Note, the -ivy i only use for the initial setup. For the later setup, just use oninit -v. Check the database status: >onstat - IBM Informix Dynamic Server Version 11.70.FC7DE – On-Line – Up 04:28:19 – 173796 Kbytes You should also check the configuration for the DB: SHMVIRTSIZE 100000 # initial virtual shared memory segment size SHMADD 8192 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited Then, based on the article (http://kb.deister.net/index.php/Keeping_Your_Informix_rootdbs_Lean_and_Clean), you should also check the content in rootdbs with oncheck -pe >tempfile command (tempfile).
Check the version of the Informix IDS database. >onstat -l IBM Informix Dynamic Server Version 11.70.FC7DE -- On-Line -- Up 11:28:09 -- 173796 Kbytes Step 2: Create SYSCDC database Run the following SQL command with the informix user: dbaccess < $INFORMIXDIR/etc/syscdcv1.sql You have to keep all the logs in the logical log before Oracle GoldenGate complete the extraction. Therefore, you might increase logical log size and the number of logical log files with the LOGSIZE and LOGFILES configuration parameters. An example is shown as follows: onmode -wf LOGSIZE=1048576 11:21:14 Value of LOGSIZE has been changed to 1048576. Step 3: Download and Install Informix CSDK for Oracle GoldenGate Oracle GoldenGate for Informix requires CSDK 4.10FC4. You can install CSDK for Oracle GoldenGate in separate directory without changing the existing Informix database installation. Installing Oracle GoldenGate is very straight forward. You just need to unzip the downloaded file and run the create subdirs command in GGSCI to create the directory structure for the Oracle GoldenGate installation.To start the Oracle GoldenGate manager, you can configure the port and parameters of the manager by setting up the parameter file. This tutorial provides an example. Step 1: Unzip the Oracle GoldenGate software and start the GGSCI >./ggsci Why I get the "The program can't start because MSVCP100.dll is missing from your computer error? Answer: In searching for an answer to this, I was able to identify that this DLL is a part of the Microsoft Visual C++ 2010 Redistribution Package (x64) (download here). After installing the package, the GGSCI command will run successfully. Step 2: Create the directory structure.
GGSCI> create subdirs Creating subdirectories under current directory /home/informix/ogg Parameter files /home/informix/ogg/dirprm: already exists Report files /home/informix/ogg/dirrpt: created Checkpoint files /home/informix/ogg/dirchk: created Process status files /home/informix/ogg/dirpcs: created SQL script files /home/informix/ogg/dirsql: created Database definitions files /home/informix/ogg/dirdef: created Extract data files /home/informix/ogg/dirdat: created Temporary files /home/informix/ogg/dirtmp: created Credential store files /home/informix/ogg/dircrd: created Masterkey wallet files /home/informix/ogg/dirwlt: created Dump files /home/informix/ogg/dirdmp: created Step 3: Connect to Source Database GGSCI (ogg-1.pssa.us.oracle.com) 1> dblogin sourcedb syscdcv1 2013-10-25 11:42:23 INFO OGG-03036 Database character set identified as ISO-8859-1. Locale: en_US. 2013-10-25 11:42:23 INFO OGG-03037 Session character set identified as UTF-8. Successfully logged into database. Step 4: Configure and Start the Oracle GoldenGate Manager GGSCI> edit param mgr PORT 15000 DYNAMICPORTLIST 15010-15020 PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS AUTORESTART ER * GGSCI> start mgr Manager started. GGSCI> info mgr Manager is running (IP port brown.oracle.jp.15000, Process ID 18105). Now, the Oracle GoldenGate is ready for use. Oracle GoldenGate for Informix uses ODBC to talk to the source and target databases. Therefore, you need to setup the ODBC connections. This tutorial explains the steps needed for this setup.
Oracle GoldenGate for Informix 12.1.2.1.0 was released on OTN 9/17/2014. In this version, the support is available on the following platforms:
Summary Hot topics heard at OpenWorld 2014: Go global, digital, mobile,social; transform and simplify IT with Cloud & Big Data under low budget. Oracle OpenWorld is Oracle's most important yearly conference. Combining with the JavaOne, MySQL Connect conferences, it becomes one of the biggest events in the IT industry. This blog includes some of my notes from OpenWorld 2014 (September 21–25, 2014, San Francisco). |
Oracle GoldenGateThis blog has updates, tips and tricks for Oracle GoldenGate. Categories
All
Archives
April 2018
|
Jinyu's Blog |
|