Install Vertica Applier
Before installing the applier, the following additions need adding to the extractor configuration. Apply the following parameter to the extractor configuration before installing the applier
Add the following to
/etc/tungsten/tungsten.ini[alpha]...Existing Replicator Config...enable-heterogeneous-service=trueshell> tpm updateNoteThe above step is only applicable for standalone extractors. If you are configuring replications from an existing Tungsten Cluster (Cluster-Extractor), follow the steps outlined here to ensure the cluster is configured correctly: "Replicating Data Out of a Cluster"
The applier can now be configured.
Unpack the Tungsten Replicator distribution in staging directory:
shell> tar zxf tungsten-replicator-8.0.4-132.tar.gzChange into the staging directory:
shell> cd tungsten-replicator-8.0.4-132Locate the Vertica JDBC driver. This can be downloaded separately from the Vertica website. The driver will need to be copied into the Tungsten Replicator
libdirectory.shell> cp vertica-jdbc-7.1.2-0.jar tungsten-replicator-8.0.4-132/tungsten-replicator/lib/Create the
/etc/tungsten/tungsten.inifile using the example below as a template. Once created to suit your needs, runtpmto perform the installation:Example tungsten.ini[defaults]user=tungsteninstall-directory=/opt/continuentprofile-script=~/.bash_profileskip-validation-check=HostsFileCheckskip-validation-check=InstallerMasterSlaveCheckrest-api-admin-user=apiuserrest-api-admin-password=secretreplicator-rest-api-address=0.0.0.0[alpha]topology=master-slavemaster=sourcehostmembers=localhostdatasource-type=verticareplication-user=dbadminreplication-password=passwordvertica-dbname=devbatch-enabled=truebatch-load-template=vertica6batch-load-language=jsreplication-port=5433svc-applier-filters=dropstatementdatasvc-applier-block-commit-interval=30ssvc-applier-block-commit-size=25000disable-relay-logs=trueShow argument definitions
user=tungstenOS System User, for example tungsten. DO NOT use root.install-directory=/opt/continuentInstallation directory.profile-script=~/.bash_profileAppend commands to include env.sh in this profile script.skip-validation-check=InstallerMasterSlaveCheckDo not run the specified validation check.skip-validation-check=InstallerMasterSlaveCheckDo not run the specified validation check.rest-api-admin-user=apiuserSpecify the initial Admin Username for API access.Available from v7.0.0rest-api-admin-password=secretSpecify the initial Admin User Password for API access.rest-api-admin-passwordalias only available from version 7.1.2 onwards.Available from v7.0.0replicator-rest-api-address=0.0.0.0Address for the API to bind too.Available from v7.0.0shell> ./tools/tpm install
If you encounter problems during the installation, check the output of the /tmp/tungsten-configure.log file for more information about
the root cause.
Once the service is configured and running, the service can be monitored as normal using the trepctl command. See "Management and Monitoring of Vertica Deployments" for
more information.