Using AWS Blue/Green deployment, how do I modify the staging database?

Paranoid Altoid

3/21/24, 8:57 PM

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.

193

1 + 0

mysql

mysql-replication

amazon-web-services

amazon-rds

Score:0

Server

skupjoe

9/1/24, 1:01 AM

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?

+ 1

proteus

9/2/24, 9:24 PM

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)

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Using AWS Blue/Green deployment, how do I modify the staging database?

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.