blocks|key|2910298|text|根据this+link的说法，您不能升级就地数据库，您需要恢复现有数据库的快照，并在此过程中更改引擎版本。这些限制似乎只是暂时的，以后可能会取消，以便就地升级|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2910299|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/AuroraMySQL.Updates.20180206.html^0|2|9|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

According to <a href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/AuroraMySQL.Updates.20180206.html" rel="noreferrer">this link</a>, you cannot upgrade an in-place database, you will need to restore a snapshot of the existing database and change the engine version during that process. These restrictions appear to be only temporary and may be lifted at a later point to allow for in-place upgra

blocks|key|5024726|text|上面的评论是正确的；5.6到5.7的升级仍然没有到位；尽管这个过程仍然很容易；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5024727|1)转到RDS仪表板，在左侧菜单中有一个名为‘Snapshot’的菜单项；如果您可以使用最近的快照，则可以单击此菜单项；否则，请选择您的数据库&在actions下拉列表中选择'Take+Snapshot‘|5024728|2)在快照中，只需选择您的快照并从操作下拉列表中选择“恢复快照”；它将自动复制您以前的一系列设置。此时，您可以选择5.7的新数据库引擎|5024729|最重要的是，您应该为整个过程留出至少半小时的停机时间。为了安全起见可能需要几个小时。|5024730|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

The comments above are true; there is still no in place upgrade for 5.6 to 5.7; the process is still pretty easy though;

1) Go to the RDS dashboard, in the left hand menu there is a menu item called 'Snapshots'; you can either click on this if you are ok using a recent snapshot; otherwise select your database &amp; on the actions drop down &amp; choose 'Take Snapshot' 

2) In snapshots simply select your snapshot &amp; choose 'Restore Snapshot' from the actions drop down; it will automatically duplicate a bunch of your previous settings. Its at this juncture you can select the new database engine of 5.7

All and all you should allow for at least a half an hour of downtime for the whole process. Probably a couple of hours to be on the safe side.

blocks|key|2077391|text|您现在可以执行从Aurora+MyQSL+5.6到5.7的就地升级|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2077392|只需调用modify-db-cluster或modify-global-cluster+(当然，如果您使用的是全局集群)。|offset|length|2077393|有关docs的更多信息(包括如何使用亚马逊网络服务控制台完成此操作)。|2077394|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.aws.amazon.com/cli/latest/reference/rds/modify-db-cluster.html|1|https://docs.aws.amazon.com/cli/latest/reference/rds/modify-global-cluster.html|2|https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.MajorVersionUpgrade.html^0|0|4|H|0|M|L|1|0|2|4|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]|$D|Y|E|Z|1|10]]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|H|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]|R|$5|K|L|M|A|$N|S]]]]

You can now perform in-place upgrade from Aurora MyQSL from 5.6 to 5.7
Only a matter of invoking <a href="https://docs.aws.amazon.com/cli/latest/reference/rds/modify-db-cluster.html" rel="nofollow noreferrer">modify-db-cluster</a> or <a href="https://docs.aws.amazon.com/cli/latest/reference/rds/modify-global-cluster.html" rel="nofollow noreferrer">modify-global-cluster</a> (if you are using global clusters of course).
More in the <a href="https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.MajorVersionUpgrade.html" rel="nofollow noreferrer">docs</a> (including how to do this using the AWS console).

blocks|key|5024752|text|最简单的方法是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5024753|5024754|首先手动拍摄Aurora+MySQL+5.6群集的快照。|ordered-list-item|5024755|5024756|然后，|5024757|使用步骤1|5024758|中拍摄的手动快照创建新的Aurora+MySQL+5.7|5024759|5024760|您的凭据将与较早的5.6群集的凭据相同。|5024761|5024762|5024763|验证数据是否正确。|5024764|5024765|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Y|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|E|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|14|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|R|3|S|5|E|7|17|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|V|$]]

Easiest way is:
<ol>
<li>Take a manual snapshot first of Aurora MySQL 5.6 cluster.
</li>
<li>Then, create a new Aurora MySQL 5.7 using that manual snapshot which was taken in step 1
</li>
<li>Your credentials would be same as that of the older 5.6 cluster.
</li>
<li>Verify if data is correct.
</li>
</ol>

blocks|key|2910426|text|需要将AWS+RDS+Aurora+MySQL从5.6升级到5.7，而不会对我们的生产造成任何停机。作为一个SaaS解决方案，我们承担不起任何停机时间。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2910427|背景|offset|length|style|BOLD|2910428|我们有基于在AWS+Fargate和AWS+Lambda中运行的微服务的分布式架构。对于数据持久性，使用了AWS+RDS+Aurora+MySQL。虽然还在使用其他服务，但这些服务在此用例中并不重要。|2910429|方法|2910430|通过声明停机时间和维护窗口对就地升级进行了很好的考虑之后，我们意识到有必要进行零停机升级。因为如果没有它，我们就会为我们创建一个处理积压。高级方法是：|2910431|2910432|创建具有所需版本的AWS+RDS群集，并将数据从现有RDS群集复制到此新群集|ordered-list-item|2910433|设置这两个群集|2910434|之间的AWS+DMS(数据迁移服务)复制完成并正在进行中，然后切换应用程序以指向新数据库。在我们的案例中，运行在AWS+Fargate中的微服务必须使用新的端点进行升级，并且它要注意排除旧的端点并使用新的端点。|2910435|2910436|有关完整的文章，请访问查看|2910437|https://bharatnainani1997.medium.com/aws-rds-major-version-upgrade-with-zero-downtime-5-6-to-5-7-b0aff1ea1f4|2910438|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2|0|0|0|2|0|0|0|0|0|0|0|0|0|30|0|30|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@$D|19|E|1A|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|1B|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1C|8|@$D|1D|E|1E|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1F|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|O|3|P|5|Q|7|1H|8|@]|9|@]|A|$]]|$1|R|3|S|5|Q|7|1I|8|@]|9|@]|A|$]]|$1|T|3|U|5|Q|7|1J|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1L|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1M|8|@$D|1N|E|1O|F|G]]|9|@$D|1P|E|1Q|1|1R]]|A|$]]|$1|10|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|Z]]]]

Need was to upgrade the AWS RDS Aurora MySQL from 5.6 to 5.7 without causing any downtime to our production. Being a SaaS solution, we could not afford any downtime.
Background
We have distributed architecture based on micro services running in AWS Fargate and AWS Lambda. For data persistency AWS RDS Aurora MySQL is used. While there are other services being used, those are not of interest in this use case.
Approach
After a good deliberation on in place upgrade by declaring a downtime and maintenance window, we realized that having zero downtime upgrade is the need. As without which we would have created a processing backlog for us.
High level approach was:
<ol>
<li>Create an AWS RDS Cluster with the required version and copy the data from the existing RDS Cluster to this new Cluster</li>
<li>Setup AWS DMS(Data Migration Service) between these two clusters</li>
<li>Once the replication is done and is ongoing then switch the application to point to the new DB. In our case, the micro-services running in AWS Fargate has to upgraded with the new end point and it took care of draining the old and using the new.</li>
</ol>
For Complete post please check out
<a href="https://bharatnainani1997.medium.com/aws-rds-major-version-upgrade-with-zero-downtime-5-6-to-5-7-b0aff1ea1f4" rel="nofollow noreferrer">https://bharatnainani1997.medium.com/aws-rds-major-version-upgrade-with-zero-downtime-5-6-to-5-7-b0aff1ea1f4</a>

blocks|key|2910322|text|管理数据库实例或数据库群集的更新|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2910323|登录亚马逊网络服务管理控制台，然后在https://console.aws.amazon.com/rds/上打开Amazon+RDS控制台。|offset|length|2910324|在导航窗格中，选择实例以管理数据库实例的更新，或选择群集以管理Aurora+DB群集的更新。|2910325|选中具有所需更新的DB实例或DB集群的复选框。|2910326|为数据库实例选择实例操作，或为数据库集群选择操作，然后选择以下选项之一：|2910327|2910328|Upgrade+now|unordered-list-item|2910329|Upgrade+at+next+window|2910330|2910331|备注：如果您选择在下一个窗口升级，并且以后想要延迟更新，您可以选择延迟升级。|style|BOLD|2910332|entityMap|0|LINK|mutability|MUTABLE|url|https://console.aws.amazon.com/rds/^0|0|I|Z|0|0|0|0|0|0|0|0|0|0|2|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@$D|16|E|17|1|18]]|A|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1A|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1B|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|1D|8|@]|9|@]|A|$]]|$1|P|3|Q|5|O|7|1E|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1G|8|@$D|1H|E|1I|U|V]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

To manage an update for a DB instance or DB cluster

Sign in to the AWS Management Console and open the Amazon RDS console at <a href="https://console.aws.amazon.com/rds/" rel="nofollow noreferrer">https://console.aws.amazon.com/rds/</a>.

In the navigation pane, choose Instances to manage updates for a DB instance, or Clusters to manage updates for an Aurora DB cluster.

Select the checkbox for the DB instance or DB cluster that has a required update.

Choose Instance actions for a DB instance, or Actions for a DB cluster, and then choose one of the following:

<ul>
<li>Upgrade now</li>
<li>Upgrade at next window</li>
</ul>

Note: If you choose Upgrade at next window and later want to delay the update, you can select Defer upgrade.

We are using AWS RDS Aurora MySQL 5.6 for our production database. 
AWS launched MySQL 5.7 compatible Aurora engine on 6th Feb, 2018.

I dont see any option in "modify instance" to change engine to MySQL 5.7
I dont see any option in restore snapshot to database with MySQL 5.7 either.

We want to do this upgrade with least downtime. Pls suggest what could be done here.

How to upgrade AWS RDS Aurora MySQL 5.6 to 5.7

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我们使用AWS RDS Aurora MySQL 5.6作为我们的生产数据库。亚马逊网络服务于2018年2月6日发布了兼容MySQL 5.7的极光引擎。我没有在“修改实例”中看到任何将引擎更改为MySQL 5.7的选项，我也没有在使用MySQL 5.7将快照还原到数据库中看到任何选项。我们希望在最短的停机时间内完成此升级。请建议在这里可以做些什么。

问如何将AWS RDS Aurora MySQL 5.6升级到5.7
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将AWS RDS Aurora MySQL 5.6升级到5.7EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将AWS RDS Aurora MySQL 5.6升级到5.7
EN