Database Replication and Clustering
| 6.5.2. Installing MySQL to Amazon RDS Replication | ||
|---|---|---|
| Prev | 6.5. Deploying MySQL to Amazon RDS Replication | Next |
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 \
--startThe 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.
Specifies which host will be the master.
--install-directory=/opt/continuent
Directory where Tungsten Replication will be installed.
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=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.
Installs a service with tpm
The name of the host where the slave replicator will be installed.
Specifies which host will be the master.
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.
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.
The service name; this should match the service name of the master.
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 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.