6.5.2. Installing MySQL to Amazon RDS Replication

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

shell> ./tools/tpm install alpha \
    --master=host1 \
    --install-directory=/opt/continuent \
    --replication-user=tungsten \
    --replication-password=password \
    --start

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.

tpm install
Executes tpm in install mode to create the service alpha.
--master=host1
Specifies which host will be the master.
--install-directory=/opt/continuent
Directory where Tungsten Replication will be installed.
--replication-user=tungsten
The user name that will be used to apply replication changes to the database on slaves.
--replication-password=password
The password that will be used to apply replication changes to the database on slaves.

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 RDS instance. Because the Amazon RDS 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:

shell> ./tools/tpm install alpha  \
  --members=host2 \
  --master-host=host1 \
  --datasource-host=rdshostname \
  --datasource-user=tungsten  \
  --datasource-password=password  \
  --privileged-slave=false \
  --install-directory=/opt/continuent \
  --skip-validation-check=InstallerMasterSlaveCheck \
  --skip-validation-check=MySQLPermissionsCheck \
  --skip-validation-check=MySQLBinaryLogsEnabledCheck \
  --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.

tungsten-installer --master-slave
Installs a default master/slave environment.
tpm install
Installs a service with tpm
--cluster-hosts=host2
The name of the host where the slave replicator will be installed.
--master-host=host1
Specifies which host will be the master.
--datasource-host=amazonrds
The full hostname of the Amazon RDS instance as provided by the Amazon console when the instance was created.
--install-directory=/opt/continuent
Directory where Tungsten Replication will be installed.
--replication-user=tungsten
The user name for the Amazon RDS instance that will be used to apply data to the Amazon RDS instance.
--replication-password=password
The password for the Amazon RDS instance that will be used to apply data to the Amazon RDS instance.
--service-name=alpha
The service name; this should match the service name of the master.
--privileged-slave=false
Disable privileged updates, which require the SUPER privilege that is not available within an Amazon RDS instance.
--skip-validation-check=InstallerMasterSlaveCheck
Disable the master/slave check; this is supported only on systems where the slave running the database can be accessed.
--skip-validation-check=MySQLPermissionsCheck
Disable the MySQL permissions check. Amazon RDS instances do not provide users with the SUPER which would fail the check and prevent installation.
--skip-validation-check=MySQLBinaryLogsEnabledCheck
Disables the check for whether the binary logs can be accessed, since these are unavailable within an Amazon RDS instance.
--start-and-report
Start the replicator and report the status after installation.

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

Prev	Up	Next
6.5.1. Preparing Hosts for Amazon RDS Replication	Home	6.5.3. Management and Monitoring of Amazon RDS Deployments