0

AWS has rolled out a Blue/Green Deployment feature for RDS, allow you to create a staging (green) database that's in parallel with your production (blue) database. Their documentation specifically says you can make changes and test them out, however:

  • It's readonly by default
  • It's got replication, syncing the green to the blue
  • I can't create a SUPER user to disable readonly mode or disable replication.

I understand why they'd default to those, changes could mess up replication, and without replication you'd lose data unless you manually copy data over in a way that's compatible with whatever changes you make to the green. I'm willing to manage that, but can't actually figure out how to modify the database! With no SUPER user I can't run:

STOP REPLICA;
set GLOBAL read_only = false;

And apparently AWS RDS doesn't allow SUPER users, and there's no way in the console to disable either of these.

What am I missing? Does green/blue only allow you to upgrade MySQL versions? Seems like a big limitation, not really spelled out anywhere.

Paranoid Altoid
  • 21
  • 1

1 Answers1

0

I am wondering the same exact thing. Their documentation clearly states that making schema modifications to the green staging instance should be doable. Did you ever find a solution for this?

skupjoe
  • 1
  • This does not really answer the question. If you have a different question, you can ask it by clicking [Ask Question](https://serverfault.com/questions/ask). To get notified when this question gets new answers, you can [follow this question](https://meta.stackexchange.com/q/345661). Once you have enough [reputation](https://serverfault.com/help/whats-reputation), you can also [add a bounty](https://serverfault.com/help/privileges/set-bounties) to draw more attention to this question. - [From Review](/review/late-answers/563118) – proteus Sep 02 '23 at 21:24