The configuration of Tungsten Replicator for Aurora involves installing a single replicator on the destination server, whether in Amazon EC2 or your own server installation. The replicator reads the binary log data from the remote Aurora instance:
Change to the software staging parent directory:
Download the latest version of Tungsten Replicator.
Expand the release:
tar zxf tungsten-replicator-4.0.7-696
Change to the extracted staging directory:
There are two ways to configure the software, either via an INI file or via the command line. Both ways are shown below.
Configure via INI file
[alpha] install-directory=/opt/replicator master=db1 direct-datasource-host=
tester.cnlhon44f2wq.eu-west-1.aurora.amazonaws.comdirect-datasource-password=aurora_secret direct-datasource-user=aurora_user direct-replication-port=3306 privileged-master=false replication-user=tungsten replication-password=secret replication-port=3306 topology=direct start-and-report=true
Configure via the command line
Run the tools/tpm command to configure the replicator:
./tools/tpm configure alpha \ --install-directory=/opt/replicator \ --replication-user=tungsten \ --replication-password=secret \ --replication-port=3306 \ --direct-replication-port=3306 \ --privileged-master=false \ --skip-validation-check=MySQLDumpCheck \ --topology=direct \ --master=db1 \ --direct-datasource-host=
tester.cnlhon44f2wq.eu-west-1.aurora.amazonaws.com\ --direct-datasource-user=aurora_user \ --direct-datasource-password=aurora_password \ --start-and-report
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.
Installs a service with tpm
Specifies which host will be the master; since this is a direct configuration, a single replicator instance operates as both master and slave.
The full hostname of the Amazon Aurora instance as provided by the Amazon console when the instance was created.
Directory where Tungsten Replicator will be installed.
The port number for the slave portion of the replicator. This is the port of the MySQL host where the data will be written.
The port number of the Amazon Aurora instance where data will be read from.
The user name for the local MySQL server into which the data will be written.
The password for the local MySQL server into which the data will be written.
The hostname of the Aurora instance.
The username of the Aurora server where the data will be read from.
The password of the Aurora server where the data will be read from.
Disable privileged updates, which require the
SUPER privilege that is
not available within an Amazon Aurora instance.
Disable checks for the mysqldump command, which is not available within Amazon Aurora.
Finally, execute the tools/tpm command to install the replicator:
./tools/tpm install -i
If the installation process fails, check the output of the
/tmp/tungsten-configure.log file for
more information about the root cause.
Once the replicator has been installed, the replicator can be monitored using the trepctl tool. For specific guidance on managing and monitoring the deploymnet, see Section 5.10.3, “Management and Monitoring Deployment from Amazon Aurora”.