6.6.1. Preparing Hosts for Replicating from Amazon RDS

MySQL Host

The data replicated from MySQL can be any data, although there are some known limitations and assumptions made on the way the information is transferred.

The following are required for replication to AmazonRDS:

  • Table format should be updated to UTF8 by updating the MySQL configuration (my.cnf):

    character-set-server=utf8
    collation-server=utf8_general_ci
  • 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 (my.cnf):

    default-time-zone='+00:00'

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 replicator service.

    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 example, the max_allowed_packet parameter may need to be increased.

    In addition, the binlog retention hours setting may need to be extended to ensure that the binary log information is available for reading by Tungsten Replication

    For more information on changing parameters, see Section 6.6.4, “Changing Amazon RDS Instance Configurations”.