5.5.1. Preparing Hosts for Replicating from Amazon RDS
The data replicated from MySQL can be any data, although there are some
known limitations and assumptions made on the way the information is
The following are required for replication to
Table format should be updated to UTF8 by updating the MySQL
To prevent timezone configuration storing zone adjusted values and
exporting this information to the binary log and AmazonRDS, fix the
timezone configuration to use UTC within the configuration file
Amazon RDS Host
Create the Amazon RDS Instance
If the instance does not already exist, create the Amazon RDS
MySQL-based instance and take a note of the IP address (Endpoint)
reported. This information will be required when configuring the
Also take a note of the user and password used for connecting to the
instance. This can be set and configured when the instance is created.
Check your security group configuration.
Ensure that the port and IP configuration within the security group
configuration are set correctly so that the host can be connected to
the remote MySQL instance.
Change RDS instance properties
Depending on the configuration and data to be replicated, the
parameter of the running instance may need to be modified. For
max_allowed_packet parameter may
need to be increased.
In addition, the
hours setting may need to be extended to ensure that the
binary log information is available for reading by Tungsten Replicator
For more information on changing parameters, see
Section 5.5.4, “Changing Amazon RDS Instance Configurations”.