5.10.2. Installing Amazon Aurora to MySQL Replication

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:

  1. Change to the software staging parent directory:

    shell> cd /opt/replicator/software
  2. Download the latest version of Tungsten Replicator.

  3. Expand the release:

    shell> tar zxf tungsten-replicator-5.0.0-0
  4. Change to the extracted staging directory:

    shell> cd tungsten-replicator-5.0.0-0
  5. 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

    Edit the /etc/tungsten/tungsten.ini file:

    [alpha]
    install-directory=/opt/replicator
    master=db1
    direct-datasource-host=tester.cnlhon44f2wq.eu-west-1.aurora.amazonaws.com
    direct-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:

    shell> ./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.

  6. Finally, execute the tools/tpm command to install the replicator:

    shell> ./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”.