5.5.2. Install: Oracle to Hadoop Replication

An Oracle to Hadoop deployment can be installed using the following methods.

5.5.2.1. Installing an Oracle to Hadoop Topology (Staging Use Case)

Important

The VMware Redo Reader feature is only available in a specific commercial release of the Continuent Replicator. Please ensure you have downloaded the correct build (must begin with vmware-continuent-replication-oracle-source-), otherwise these procedures will fail.

  1. Install the Tungsten Replicator package or download the Tungsten Replicator tarball, and unpack it:

    shell> cd /opt/continuent/software
    shell> tar zxf vmware-continuent-replication-oracle-source-5.2.1-263.tar.gz
  2. Change to the Tungsten Replicator directory:

    shell> cd vmware-continuent-replication-oracle-source-5.2.1-263
  3. To create a master/slave using tpm:

    shell> ./tools/tpm install alpha\
        --topology=master-slave \
        --master=host1 \
        --replication-user=tungsten \
        --replication-password=password \
        --install-directory=/opt/continuent \
        --members=host1,host2,host3 \
        --start

    The description of each of the options is shown below; click the icon to hide this detail:

    Click the icon to show a detailed description of each argument.

    If the MySQL configuration file cannot be located, the --datasource-mysql-conf option can be used to specify it's location:

    shell> ./tools/tpm install alpha\
        --topology=master-slave \
        --master=host1 \
        --replication-user=tungsten \
        --replication-password=password \
        --datasource-mysql-conf=/etc/mysql/my.cnf \
        --install-directory=/opt/continuent \
        --members=host1,host2,host3 \
        --start-and-report

Once the installation has been completed, the service will be started and ready to use. For information on checking the running service, see Section 5.5.3.1, “Management and Monitoring of Oracle to Hadoop Deployments”.

For information on starting and stopping Tungsten Replication see Section 2.5, “Starting and Stopping Tungsten Replicator”; configuring init scripts to startup and shutdown when the system boots and shuts down, see Section 2.6, “Configuring Startup on Boot”.

5.5.2.2. Installing an Oracle to Hadoop Topology (INI Use Case)

Important

The VMware Redo Reader feature is only available in a specific commercial release of the Continuent Replicator. Please ensure you have downloaded the correct build (must begin with vmware-continuent-replication-oracle-source-), otherwise these procedures will fail.

Content Being Written

This section of the documentation is currently being produced and may be incomplete and/or subject to change.

  1. On all member hosts, install the Tungsten Replicator™ package (.rpm), or download the compressed tarball and unpack it:

    shell> cd /opt/continuent/software
    shell> tar zxf vmware-continuent-replication-oracle-source-5.2.1-263.tar.gz
  2. Change to the Tungsten Replicator directory:

    shell> cd vmware-continuent-replication-oracle-source-5.2.1-263
  3. Create /etc/tungsten/tungsten.ini with the following configuration:

    [alpha]
    user=tungsten
    topology=master-slave
    install-directory=/opt/continuent
    master=host1
    members=host1,host2,host3
    replication-user=tungsten
    replication-password=password
    replication-port=3306
    datasource-mysql-conf=/etc/mysql/my.cnf
    start-and-report=true
    profile-script=~/.bash_profile
    

    The description of each of the options is shown below; click the icon to hide this detail:

    Click the icon to show a detailed description of each argument.

  4. Run tpm on all member hosts to install the software with the INI-based configuration:

    shell > ./tools/tpm install

    During the startup and installation, tpm will notify you of any problems that need to be fixed before the service can be correctly installed and started. If start-and-report is set and the service starts correctly, you should see the configuration and current status of the service.

  5. Initialize your PATH and environment.

    shell > source /opt/continuent/share/env.sh

Once the installation has been completed, the service will be started and ready to use. For information on checking the running service, see Section 5.5.3.1, “Management and Monitoring of Oracle to Hadoop Deployments”.

For information on starting and stopping Tungsten Replicator see Section 2.5, “Starting and Stopping Tungsten Replicator”; configuring init scripts to startup and shutdown when the system boots and shuts down, see Section 2.6, “Configuring Startup on Boot”.