{"id":392,"date":"2023-02-05T22:26:31","date_gmt":"2023-02-05T22:26:31","guid":{"rendered":"http:\/\/joonim.ca\/?p=392"},"modified":"2025-08-15T21:58:08","modified_gmt":"2025-08-16T01:58:08","slug":"aws-rds-instance-changes-in-the-cluster-with-no-much-less-downtime","status":"publish","type":"post","link":"https:\/\/waterloobae.com\/blog\/2023\/02\/05\/aws-rds-instance-changes-in-the-cluster-with-no-much-less-downtime\/","title":{"rendered":"[AWS] RDS Instance changes in the cluster with no (much less?) Downtime."},"content":{"rendered":"\n

(Source: https:\/\/stackoverflow.com\/questions\/54708210\/how-to-change-aws-rds-instance-type-without-downtime)<\/p>\n\n\n\n

Instead of changing the instance type of the current instance, Add a new instance first. Then, you can delete the old instance in the cluster. There is no way to add the writer instance,<\/strong> So. <\/p>\n\n\n\n

\n

In order to change the type of a writer instance.<\/h2>\n\n\n\n
    \n
  1. Add an Aurora reader<\/strong> with the desired new instance type (for example db.t2.medium) to the cluster. Be sure to assign the reader the best priority<\/strong> so that it will be promoted to writer during failover (see Aurora Documentation<\/a> for more in-depth information).<\/li>\n\n\n\n
  2. Wait until the new instance is up and running.<\/li>\n\n\n\n
  3. Then failover the cluster<\/strong> so that the new reader gets promoted to a writer.<\/li>\n\n\n\n
  4. Finally delete the previous Aurora instance of the old instance type.<\/li>\n<\/ol>\n<\/div>\n\n\n\n

    This way you will have nearly no downtime.<\/p>\n\n\n\n

    \n

    If you want to change the type of a reader<\/strong> instance:<\/h2>\n\n\n\n
      \n
    1. Add an Aurora reader with the desired new instance type.<\/li>\n\n\n\n
    2. Wait until it’s up and running.<\/li>\n\n\n\n
    3. Delete the previous reader instance.<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      (Source: https:\/\/stackoverflow.com\/questions\/54708210\/how-to-change-aws-rds-instance-type-without-downtime) Instead of changing the instance type of the current instance, Add a new instance first. Then, you can delete the old instance in the cluster. There is no way to add the writer instance, So. In order to change the type of a writer instance. This way you will have nearly no downtime. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,4],"tags":[],"class_list":["post-392","post","type-post","status-publish","format-standard","hentry","category-aws","category-it-tips"],"_links":{"self":[{"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/posts\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/comments?post=392"}],"version-history":[{"count":1,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/posts\/392\/revisions"}],"predecessor-version":[{"id":873,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/posts\/392\/revisions\/873"}],"wp:attachment":[{"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/media?parent=392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/categories?post=392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/tags?post=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}