Tungsten Replicator

Install MySQL Applier

The applier will read information from the Extractor and write database changes into the target instance.

To configure the Applier replicator for either local or remote MySQL or for a cloud-managed instance, the process is the same, but with a slightly different configuration, this is outlined below:

Unpack the Tungsten Replicator distribution in a staging directory:
```
shell> tar zxf tungsten-replicator-8.0.4-132.tar.gz
```
Change into the staging directory:
```
shell> cd tungsten-replicator-8.0.4-132
```
Use the appropriate template config for your target
- "Local and Remote MySQL Targets"
- "Cloud-Managed Targets"
Once the prerequisites and configuring of the installation has been completed, the software can be installed:
```
shell> ./tools/tpm install
```

If the installation process fails, check the output of the /tmp/tungsten-configure.log file for more information about the root cause.

The replicators can now be started using the replicator command.

The status of the replicator can be checked and monitored by using the trepctl command.

Local and Remote MySQL Targets

Example tungsten.ini
[defaults]
install-directory=/opt/continuent
user=tungsten
mysql-allow-intensive-checks=true
profile-script=~/.bash_profile
rest-api-admin-user=apiuser
rest-api-admin-password=secret
replicator-rest-api-address=0.0.0.0

[alpha]
master=sourcehost
members=localhost,sourcehost
datasource-type=mysql
replication-user=tungsten
replication-password=secret
replication-host=remotedbhost

Show argument definitions

install-directory=/opt/continuentInstallation directory.

user=tungstenOS System User, for example tungsten. DO NOT use root.

mysql-allow-intensive-checks=trueFor MySQL installation, enables detailed checks on the supported data types within the MySQL database to confirm compatibility.

profile-script=~/.bash_profileAppend commands to include env.sh in this profile script.

rest-api-admin-user=apiuserSpecify the initial Admin Username for API access.Available from v7.0.0

rest-api-admin-password=secretSpecify the initial Admin User Password for API access. rest-api-admin-password alias only available from version 7.1.2 onwards.Available from v7.0.0

replicator-rest-api-address=0.0.0.0Address for the API to bind too.Available from v7.0.0

replication-host should only be added to the above configuration if the target MySQL Database is on a different host to the applier installation.

Cloud-Managed Targets

Example tungsten.ini
[defaults]
install-directory=/opt/continuent
user=tungsten
mysql-allow-intensive-checks=true
profile-script=~/.bash_profile
skip-validation-check=InstallerMasterSlaveCheck
skip-validation-check=MySQLPermissionsCheck
skip-validation-check=MySQLBinaryLogsEnabledCheck
skip-validation-check=MySQLMyISAMCheck
skip-validation-check=RowBasedBinaryLoggingCheck
rest-api-admin-user=apiuser
rest-api-admin-password=secret
replicator-rest-api-address=0.0.0.0
cloud-install=true

[alpha]
master=sourcehost
members=localhost,sourcehost
datasource-type=mysql
datasource-mysql-conf=/dev/null
replication-user=rdsuser
replication-password=secret
privileged-slave=false
replication-host=rds-endpoint-url
service-type=remote