6.13.2. Installing MySQL to Amazon Aurora Replication

The configuration of your Amazon Aurora replication is in two parts, the master/extractor (which may be an existing database host) and the slave/applier that writes the data into the Amazon Aurora instance.

To configure the master replicator on host1 which will read from MySQL:

shell> ./tools/tpm install alpha \
    --master=host1 \
    --members=host1 \
    --install-directory=/opt/replicator \
    --replication-user=tungsten \
    --replication-password=secret \
    --start-and-report=true

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.

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

The slave applier will read information from the master and write database changes into the Amazon Aurora instance. Because the Amazon Aurora instance does not provide SUPER privileges, the instance must be created using a access mode that does not require privileged updates to the system. Aside from this setting, no other special configuration requirements are needed.

To configure the slave replicator on host2 which will write into Aurora::

shell> ./tools/tpm install alpha  \
  --master=host1 \
  --members=host2 \
  --datasource-host=tester.cnlhon44f2wq.eu-west-1.aurora.amazonaws.com \
  --datasource-password=aurora_secret  \
  --datasource-user=aurora_user  \
  --install-directory=/opt/replicator \
  --privileged-slave=false \
  --skip-validation-check=MySQLConfFile \
  --skip-validation-check=MySQLPermissionsCheck \
  --start-and-report=true

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.

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