关于AWS的两个问题RDS 多可用区

发布于 2024-10-30 05:26:44 字数 155 浏览 0 评论 0原文

  1. 我了解到,当从单可用区升级到多可用区 rds 时,会发生“breef i/o freeze”。这到底是什么意思?

  2. 当升级到多可用区部署时(例如从小到大),生产数据库是否会受到影响?它能够使用备份数据库,然后进行故障转移吗?

  1. I understand that when upgrading to a Multi-AZ rds from a Single-AZ, there occurs a "breef i/o freeze". What exactly does that mean?

  2. When an upgrade is made to a Multi-AZ deployment, say from small to large, will the production database be impacted at all? Will it be able to use the backup databse, then failover?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

爱,才寂寞 2024-11-06 05:26:44

您的问题的答案已记录下来:

  1. 当您选择从单可用区移动到多可用区时,会发生短暂的 I/O 冻结。这意味着在一段时间内数据库将无法访问。不会对数据库执行任何读、写操作。大多数情况下,此过程的持续时间约为 3-4 分钟。

  2. 是的,当您调整计算大小(从小到大)时,生产数据库将会受到影响。执行调整大小操作的最佳方法是在计划的维护时段内。如果选择“立即应用”选项,有时数据库将无法访问(需要将控制权切换到备份服务器)。

问候,
桑克特·丹吉

Answers to your questions are written down :

  1. When you choose to move from Single AZ to Multi AZ, brief I/O freeze happens. It means that for some duration database won't be accessible. No read,write operations will be performed on the database. Mostly, the duration for this is around 3-4 minutes.

  2. Yeah, production database will be affected when you resize the compute(from small to large). The best idea to perform resize operation is during scheduled maintenance window. If select Apply Immediately option, for sometime the database won't be accessible(time to switch control to backup server).

Regards,
Sanket Dangi

菊凝晚露 2024-11-06 05:26:44

从单可用区转换为多可用区时的停机时间本质上是新实例启动并完全发挥作用所需的时间,正如 sanket 所说,可能需要几分钟。

扩展多可用区部署首先扩展从属实例,然后执行故障转移。停机时间是进行实际故障转移所需的时间 - 通常接近一分钟。

扩展多可用区部署是通过添加额外的只读副本(源自备用数据库)来完成的,这不会造成中断。请记住,添加只读副本会创建一个最终一致的系统,这可能是理想的,也可能不是理想的。

同样值得一提的是,您应该在所有多可用区实例中使用相同的实例类型,否则不平衡可能会导致副本延迟。

您可能已经意识到,最好从一开始就采用多可用区配置。它使扩展和扩展变得更加容易,并且停机时间更少。

the downtime when converting from single-AZ to multi-AZ is essentially the time it takes for a new instance to launch and become fully functional as sanket said, it may take a few mins.

scaling up a multi-AZ deployment first scales up the slave instance, then performs a failover. the downtime is the time it takes to do the actual failover - usually closer to a minute.

scaling out a multi-AZ deployment is done by adding additional read-replicas (sourced off of the standby) which incurs no interruption. keep in mind that adding read-replicas creates an eventually consistent system which may or may not be desirable.

it's also worth nothing that you should use the same instance types across all multi-AZ instances, otherwise the imbalance may incur replica lag.

as you're probably realizing, it's best to start with a multi-AZ configuration from the beginning. it makes scaling up and scaling out a lot easier and with less downtime.

滥情哥ㄟ 2024-11-06 05:26:44

问题1仍然有效吗?根据 AWS 文档 (2022),没有停机时间,但性能略有下降。

引用AWS文档:

将数据库实例从单可用区转换为多可用区时,Amazon RDS
创建数据库卷的快照并将其恢复到新的
不同可用区中的卷。虽然是新修复的
卷几乎立即可用,但未达到预期
指定的性能,直到复制底层存储块
从快照中。

因此,在从单可用区到多可用区的转换过程中,您可以
体验延迟增加和性能影响。这种影响是一个
卷类型、您的工作负载、实例和卷大小的函数,以及
可能很重要,可能会影响大型写入密集型数据库实例
在运营高峰时段。

Is question 1 still valid? According to AWS documentation (2022) there is no downtime, but there is a small decrease in performance.

Quoting AWS documentation:

When converting a DB instance from Single-AZ to Multi-AZ, Amazon RDS
creates a snapshot of the database volumes and restores these to new
volumes in a different Availability Zone. Although the newly restored
volumes are available almost immediately, they don’t reach their
specified performance until the underlying storage blocks are copied
from the snapshot.

Therefore, during the conversion from Single-AZ to Multi-AZ, you can
experience elevated latency and performance impacts. This impact is a
function of volume type, your workload, instance, and volume size, and
can be significant and may impact large write-intensive DB instances
during peak hour of operations.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文