Hacker News new | ask | show | jobs
by ptrf 4600 days ago
For MySQL RDS instances, it's most certainly possible to do offsite asynchronous replication without the use of read replicas, as described in their documentation here: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL....

The guide does mention using a read replica to replicate from, an intermediate RDS instance between your offsite, but I've had no trouble replicating directly from the master instance.

One thing they don't cover is replication over SSL. AWS has failed to mention this shortcoming in the docs last time I checked. To have MySQL replicate over SSL, the master and slave both need an SSL certificate signed by the same CA, which would require you to obtain a cert+key signed by the AWS RDS CA.

Of course you have the option of tunneling the replication connection into a haproxy or stunnel running on an ec2 instance, but that has it's other shortcomings. You can't use the ELBs, since you can't register the RDS instance with an ELB.