5.4.1. Preparing Hosts for Amazon RDS Replication
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 instance
and take a note of the IP address (Endpoint) reported. This
information will be required when configuring the replicator service.
Also take a note of the user and password used for connecting to the
Check your security group configuration.
The host used as the slave for applying changes to the Amazon RDS
instance must have been added to the security groups. Within Amazon
RDS, security groups configure the hosts that are allowed to connect
to the Amazon RDS instance, and hence update information within the
database. The configuration must include the IP address of the slave
replicator, whether that host is within Amazon EC2 or external.
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
may need to be increased.
For more information on changing parameters, see
Section 5.4.4, “Changing Amazon RDS Instance Configurations”.