1/8

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 System Requirements and Preinstallation Instructions

• 1.1 Verifying Certification and System Requirements
• 1.2 Operating System Requirements
  • 1.2.1 Memory Requirements
  • 1.2.2 Disk Requirements
  • 1.2.3 Temporary Disk Requirements
  • 1.2.4 Network
  • 1.2.5 Operating System Privileges
  • 1.2.6 Console
  • 1.2.7 Other Programs
• 1.3 Database Requirements
  • 1.3.1 Supported Version
  • 1.3.2 Database Character Set
  • 1.3.3 Database Storage Engine
  • 1.3.4 Database User for Oracle GoldenGate Processes
  • 1.3.5 Supported MySQL Data Types
    • 1.3.5.1 Limitations and Clarifications
  • 1.3.6 Non-Supported MySQL Data Types
  • 1.3.7 Supported Objects and Operations for MySQL
  • 1.3.8 Non-Supported Objects and Operations for MySQL

2 Installing Oracle GoldenGate

• 2.1 Overview
• 2.2 Downloading Oracle GoldenGate
• 2.3 Setting Library Paths for Dynamic Builds on UNIX
• 2.4 Preparing to Install Oracle GoldenGate Within a Cluster
  • 2.4.1 Deciding Where to Install Oracle GoldenGate Binaries and Files in the Cluster
• 2.5 Installing Oracle GoldenGate on Linux and UNIX
• 2.6 Installing Oracle GoldenGate on Windows
  • 2.6.1 Installing the Oracle GoldenGate Files
  • 2.6.2 Specifying a Custom Manager Name
  • 2.6.3 Installing Manager as a Windows Service
• 2.7 Setting up Oracle GoldenGate for MySQL Cluster
  • 2.7.1 Step 1: Install MySQL Cluster
  • 2.7.2 Step 2: Start MySQL Cluster
  • 2.7.3 Step 3: Install and Run Oracle GoldenGate
• 2.8 Integrating Oracle GoldenGate into a Cluster
  • 2.8.1 General Requirements in a Cluster
  • 2.8.2 Adding Oracle GoldenGate as a Windows Cluster Resource

3 Preparing the System for Oracle GoldenGate

• 3.1 Ensuring Data Availability
• 3.2 Setting Logging Parameters
• 3.3 Adding Host Names
• 3.4 Setting the Session Character Set
• 3.5 Configuring Bi-Directional Replication
• 3.6 Other Oracle GoldenGate Parameters for MySQL
• 3.7 Preparing Tables for Processing
  • 3.7.1 Assigning Row Identifiers
    • 3.7.1.1 How Oracle GoldenGate Determines the Kind of Row Identifier to Use
    • 3.7.1.2 Tables with a Primary Key Derived from a Unique Index
    • 3.7.1.3 How to Specify Your Own Key for Oracle GoldenGate to Use
  • 3.7.2 Limiting Row Changes in Tables That Do Not Have a Key
  • 3.7.3 Disabling Triggers and Cascade Constraints
• 3.8 Positioning Extract to a Specific Start Point
• 3.9 Changing the Log-Bin Location

4 Uninstalling Oracle GoldenGate

• 4.1 Uninstalling Oracle GoldenGate from Linux or UNIX
• 4.2 Removing Oracle GoldenGate from Windows Cluster
• 4.3 Uninstalling Oracle GoldenGate from Windows (Non-Cluster)

A Oracle GoldenGate Installed Components

• A.1 Oracle GoldenGate Programs and Utilities
• A.2 Oracle GoldenGate Subdirectories
• A.3 Other Oracle GoldenGate Files
• A.4 Oracle GoldenGate Checkpoint Table