Installation of a MySQL to PostgreSQL replication topology is handled in two parts. First, set up a MySQL heterogeneous master, as described in Section 22.214.171.124, “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:
tar zxf tungsten-replicator-6.0.tar.gz
Change into the staging directory:
To configure the slave replicators:
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.
Specifies which host will be the master.
Specifies which hosts will be the slaves running PostgreSQL.
The user name that will be used to apply replication changes to the database on slaves.
Directory where Tungsten Replication will be installed.
The password that will be used to apply replication changes to the database on slaves.
Defines the port to be used when communicating with the PostgreSQL server.
The name of the top-level PostgreSQL database that data will be replicated into.
Configures the target datasource as PostgreSQL.
This starts the replicator service once the replicator has been configured and installed.
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.