Upgrading Aurora MySQL from 5.7 to 8.x with minimal downtime

0

IHAC who is planning to upgrade their Aurora MySQL engine from 5.7 to 8.x. The Aurora MySQL clusters are fronted by RDS Proxy which currently doesn't support Blue/Green Deployment. They are looking for a solution that would allow them to perform this upgrade with minimal downtime.

AWS
질문됨 9달 전864회 조회
1개 답변
0

A list of prechecks for moving from Aurora SQL 5.7 to 8.x

To minimize downtime during a major version upgrade, use blue-green upgrade Please note, using blue-green upgrade, source cluster should be binary log enabled. To do this, perform engine restart to enable binary log and may cause some performance impact due to additional resource consumption by writing and shipping binary log.

Another option is in-place upgrade You can estimate upgrade time by create cloned cluster and upgrade it for measuring upgrade time.

Please accept this answer if it is helpful so re:Post community will benefit. Thank you!

profile pictureAWS
답변함 9달 전
  • I understand Blue-green is an option, however, the concern here is that the Clusters are fronted by an RDS Proxy which currently doesn't support Blue-Green Deployment. So with a cluster that is fronted with RDS Proxy, how would a blue-green implementation work?

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인