18

Amazon RDS 支援 readonly instance 當作 Multi AZ 的機器了

 3 years ago
source link: https://blog.gslin.org/archives/2021/11/28/10438/amazon-rds-%e6%94%af%e6%8f%b4-readonly-instance-%e7%95%b6%e4%bd%9c-multi-az-%e7%9a%84%e6%a9%9f%e5%99%a8%e4%ba%86/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Amazon RDS 支援 readonly instance 當作 Multi AZ 的機器了

從來沒在用 RDS 的 Multi AZ，所以根本沒注意到居然沒這個功能：「New Multi-AZ deployment option for Amazon RDS for PostgreSQL and for MySQL; increased read capacity, lower and more consistent write transaction latency, and shorter failover time (Preview)」。

看起來 (加上印象中) 之前的 Multi AZ 是另外一台機器先開著但不能用：

In the case of an infrastructure failure, Amazon RDS performs an automatic failover to the standby, so that database operations resume as soon as the failover is complete.

現在則是開著的機器可以跑 readonly 模式：

The standby DB instances act as automatic failover targets and can also serve read traffic to increase throughput without needing to attach additional read replica DB instances.

這樣做除了省成本外，另外因為這些 instance 平常就有 query 的量，當真的遇到 failover 切換時，warmup 的時間也會短很多 (尤其是服務夠大的時候)。

不過有些限制，首先看起來只支援 Graviton2 (ARM-based) 的機種？

The readable standby option for Amazon RDS Multi-AZ deployments works with AWS Graviton2 R6gd and M6gd DB instances (with NVMe-based SSD instance storage) and Provisioned IOPS Database Storage.

然後是支援的區域：

The Preview is available in the US East (N. Virginia), US West (Oregon), and Europe (Ireland) regions.

以及夠新的版本，MySQL 8 與 PostgreSQL 13.4 才有提供：

Amazon RDS for MySQL supports the Multi-AZ readable standby option for MySQL version 8.0.26. Amazon RDS for PostgreSQL supports the Multi-AZ readable standby option for PostgreSQL version 13.4.

但看起來還不錯，畢竟這比較接近以前在地端機房時的作法...

Related

Amazon RDS 推出了 Connection Pool 的產品

Amazon RDS 推出了 Connection Pool 的產品，叫做 Amazon RDS Proxy：「Introducing Amazon RDS Proxy (Preview)」。 目前支援 MySQL (包括了傳統的與 Aurora 版本的)： Amazon RDS Proxy supports Amazon RDS for MySQL and Amazon Aurora with MySQL compatibility, with support for additional RDS database engines coming soon. 定價策略看起來是依照後端資料庫的 vCPU 計算： Pricing is simple and predictable: you…

December 9, 2019

In "AWS"

Amazon RDS 支援 PostgreSQL 了...

AWS 的官方公告出來了：「Amazon RDS for PostgreSQL - Now Available」。 而且 AWS 上 MySQL 有的 feature，PostgreSQL 都有： Multi-AZ Deployments Provisioned IOPS Virtual Private Cloud Automated Backups Point-in-time Recovery Cross-Region Snapshot Copy 而且是 PostgreSQL 9.3 (雖然是 9.3.0)，如果本來自己用 EC2 搞 PostgreSQL 的都可以切過去了 :p

November 15, 2013

In "AWS"

Amazon RDS 支援 ARM 架構的 t4g 與 x2g

這兩篇剛好一起看，Amazon RDS 支援了 ARM 架構的 t4g 與 x2g：「Amazon RDS now supports X2g instances for MySQL, MariaDB, and PostgreSQL databases.」與「Amazon RDS now supports T4g instances for MySQL, MariaDB, and PostgreSQL databases.」。 目前主要是關注 t4g，因為目前量的關係反而是大量使用 t4g 類的機器，如果上面的 PostgreSQL 可以跑 t4g 的話，看起來只要沒有買 RI 的可以換過去，主要是比 t3 再省一些錢：以新加坡區的 PostgreSQL 來說，db.t4g.micro 目前是 $0.025/hr，而 db.t3.micro 則是 $0.028/hr，差不多是九折。 沒意外的話效能應該也會提昇一些，不過用…

September 18, 2021

In "AWS"

a611ee8db44c8d03a20edf0bf5a71d80?s=49&d=identicon&r=gAuthor Gea-Suan LinPosted on November 28, 2021Categories AWS, Cloud, Computer, Database, Murmuring, MySQL, Network, PostgreSQL, Service, SoftwareTags amazon, aws, az, cloud, database, db, failover, instance, multi, mysql, only, postgresql, preview, rdbms, rds, read, readonly, service

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Notify me of follow-up comments by email.

Notify me of new posts by email.

Post navigation


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK