6.6. Deploying Amazon RDS to MySQL Replication

Replicating from Amazon RDS operates by directly accessing the binary log provided by Amazon RDS and enables you to take advantage of the Amazon Web, either replicating from the remote RDS instance, or to a standard EC2 instance within AWS. The complexity with RDS is that there is no access to the host that is running the RDS instance, or the MySQL binary logs.

To use this service, two aspects of the Tungsten Replicator are required, direct mode and unprivileged user support. Direct mode reads the MySQL binary log over the network, rather than accessing the binlog on the filesystem. The unprivileged mode enables the user to access and update information within RDS without requiring SUPER privileges, which are unavailable within an RDS instance. For more information, see Section B.4.6, “MySQL Unprivileged Users”.

  • Service Alpha extracts the binary log information directly from the Amazon RDS instance and loads into the THL.

  • The replicator then writes the information from the THL and writes the data to the target database.

Figure 6.6. Topologies: Amazon RDS to MySQL

Topologies: Amazon RDS to MySQL

The replicator can be installed either within a standard (non-RDS) Amazon EC2 instance or on another host with writes to a local MySQL instance.