Skip to content

Instantly share code, notes, and snippets.

@iamcaleberic

iamcaleberic/aurora.md

Created July 5, 2019 17:18
Show Gist options
  • Save iamcaleberic/9a639c9f30840cdbb43a92a0f7dcd171 to your computer and use it in GitHub Desktop.
Save iamcaleberic/9a639c9f30840cdbb43a92a0f7dcd171 to your computer and use it in GitHub Desktop.
Download ZIP
Reducing or increasing instance size on Amazon Aurora RDS
Raw
aurora.md
  • Select aurora cluster
  • Create a reader making sure all the options are correct and they are in the same db parameter group
  • Make sure the reader completes setup and the replica lag is withing acceptable range 13 - 20 ms
  • Set the highest failover priority for the reader after its completely setup usually failover-0
  • Make sure there are no pending changes
  • Select writer and select failover and accept prompts
  • Wait for the failover process to complete (30 - 60 seconds)
  • You should have the reader promoted to a writer

Reference:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment