RDS Blue/Green Deployment

0

I have setup a Blue/Green Deployment for the DB instance restored from the production. The replication from Blue to Green works when I created a table in Blue, Green got it. According to the documentation (Overview of Amazon RDS Blue/Green Deployments)[https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html#blue-green-deployments-major-steps]

You can make changes to the RDS DB instances in the green environment without affecting production workloads.

But I am not able to make schema changes on the Green as it is set to read-only. If I am to set the Green to read-only=0, should I also turn off the replication so that the schema change will not be overwritten? But if the replication is turned off, when I switch over the changes made to Blue Production will be lost.

profile picture
Lottie
preguntada hace 2 meses219 visualizaciones
1 Respuesta
0

I assume this is mysql or Aurora mysql? You can make changes to green by setting read_only=OFF. This is by design to allow for common maintenance tasks on green (such as converting a PK from int to bigint). However you also have to be careful not to make any changes that would otherwise break the binlog replication. Example if you dropped a table on green that might break replication to green.

AWS
MODERADOR
philaws
respondido hace 2 meses
profile picture
EXPERTO
revisado hace 2 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas