6.12.2. Installing PostgreSQL Applier Replication

Installation of a MySQL to PostgreSQL replication topology is handled in two parts. First, set up a MySQL heterogeneous master, as described in Section 6.1.2.2, “Deploying a Heterogeneous MySQL Master for Direct Appliers”. Once that has been completed, you can configure and install the PostgreSQL applier as described using the steps below.

  • Unpack the Tungsten Replicator distribution in staging directory:

    shell> tar zxf tungsten-replicator-6.0.tar.gz
  • Change into the staging directory:

    shell> cd tungsten-replicator-6.0
  • To configure the slave replicators:

    shell> tools/tpm configure alpha \
    --datasource-type=postgresql \
    --install-directory=/opt/continuent \
    --master=host1 \
    --members=pgslave \
    --postgresql-dbname=tungsten \
    --replication-password=password \
    --replication-port=5433 \
    --replication-user=tungsten

    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 installation process fails, check the output of the /tmp/tungsten-configure.log file for more information about the root cause.

Once the replicators have started, the status of the service can be checked using trepctl. See Section 6.12.3, “Management and Monitoring of PostgreSQL Deployments” for more information.