Changing "primary" replication database

Question

Im trying to follow this guide https://workmarket.tech/zero-downtime-maintenances-on-mysql-rds-ba13b51103c2 , for \*active\*-\*active\* replication.

But on command
`CHANGE *active* TO *active*_HOST=....`
i get error: 
`ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or REPLICATION_*secondary*_ADMIN privilege(s) for this operation`

As i understood AWS forbids this kind of access via command line access.
So, how do i then do this change? i assume via `parameters group`... but how?

\*active\* = some non inclusive word

\*secondary\* = some other non inclusive word

Accepted Answer

So, the "active-active" replication worked, there is just a some things that needs to be configured.
As far as i understood those values in `parameter groups` of RDS DB must be configured:
```
auto_increment_increment
auto_increment_offset
log_bin_trust_function_creators
```
Then you also need to set the retention period

`aws rds modify-db-instance --backup-retention-period 1 --db-instance-identifier  --apply-immediately`

And then, just following any common guide of setup-ing the "active-active" replication should work.

Answer

There is a better option. RDS now support managed blue green deployment to make maintenance operations easier: https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-rds-blue-green-deployments-safer-simpler-faster-updates/

Changing "primary" replication database

Relevanter Inhalt