The configuration of Tungsten Replicator for RDS 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 RDS instance:
Download the latest version of Tungsten Replicator.
Expand the release:
tar zxf tungsten-replicator-4.0.7-696
Change to the staging directory:
Run tpm to install the replicator:
./tools/tpm install alpha \ --install-directory=/opt/continuent \ --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.rds.amazonaws.com\ --direct-datasource-user=rds_user \ --direct-datasource-password=rds_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 RDS 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 RDS 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 RDS instance.
The username of the RDS server where the data will be read from.
The password of the RDS server where the data will be read from.
Disable privileged updates, which require the
SUPER privilege that is
not available within an Amazon RDS instance.
Disable checks for the mysqldump command, which is not available within Amazon RDS.
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.6.3, “Management and Monitoring Deployment from Amazon RDS”.