5.5. 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 C.4.4, “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 5.6. 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.