We are doing a migration from Amazon RDS to EC2 with a customer.
This, unfortunately, involves some downtime – if you are an RDS
user, you probably know you can’t replicate an RDS instance to an
external server (or even EC2). While it is annoying, this post
isn’t going to be a rant on how RDS can make you feel locked in.
Instead, I wanted to give you a quick tip.
So here’s the thing – you can’t stop replication on RDS read
replica, because you don’t have (and won’t get) privileges to do
that:
replica> STOP SLAVE;
ERROR 1045 (28000): Access denied for user 'usr'@'%' (using password: YES)
Normally, you don’t want to do that, however we wanted to run
some pt-upgrade checks before we migrate and for
that we needed the read replica to stop replicating. Here’s one
way to do it:
WARNING! …
[Read more]