Q: Can I directly access the binary logs for my Database Instance to manage my own replication?
Amazon RDS does not currently provide access to the binary logs for your Database Instance.
MySQL Replication on RDS:
1. Multi-AZ: high available
2. Read Replicas: raizsing ability for reading
MySQL Data Synchronization Tools
SQLyog Job Agent
http://code.google.com/p/sqlyog/downloads/list
这个工具只支持对有主键或唯一键设置的表进行同步，否则报错如下
mysql> desc imsi;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| imsi | varchar(20) | YES | | NULL | |
| country | varchar(100) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
WARNING: table imsi does not have a Primary Key or a Unique Key with columns defined NOT NULL. Data Sync will operate in a special mode. Refer to documentation for details.
Check sja.log for complete error details.
0 0 0
Total time taken - 1 sec(s)
同步两张带主键的表：
./sja job.xml
SQLyog Job Agent Version 10.3 Copyright(c) Webyog Inc. All Rights Reserved.