4 ms·
RDS/EBS snapshots being bound to their region is a big stumbling block. Especially for RDS, because the only solution is mysqldump (or similar) and that not onl
by sehugg 14y ago
RDS/EBS snapshots being bound to their region is a big stumbling block. Especially for RDS, because the only solution is mysqldump (or similar) and that not only blocks the production database but takes hours for databases above 10 GB. So at the end of this you have a very out-of-date backup that you can transfer to the other region.
Cross-region snapshot mirroring would be a great enhancement feature for AWS.
- blantonl 14y agoYou might just consider setting up a dedicated slave MySQL database on a smaller instance in the west region just for the eventuality that you need to spin up a master there. Then you can just snapshot, copy to ephemeral, and go from there.
- rhizome 14y agoGiven that the alternative is being down for days, turning a site read-only while the dump-move is happening seems like a reasonable compromise.