5.9.1. Preparing Hosts for Amazon Aurora Replication

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 Amazon Aurora:

  • 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 Amazon Aurora, fix the timezone configuration to use UTC within the configuration file (my.cnf):

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

Amazon Aurora Host

  • Create the Amazon Aurora Instance

    If the instance does not already exist, create the Amazon Aurora 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.

  • Check your security group configuration.

    The host used as the slave for applying changes to the Amazon Aurora instance must have been added to the security groups. Within Amazon Aurora, security groups configure the hosts that are allowed to connect to the Amazon Aurora 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 Aurora 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.

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