postgreSQL RDS vs Aurora

[가격 - r5.4xlarge 기준]

1. RDS-postgreSQL/r5.4xlarge(16c, 128G)/Multi-AZ
    인스턴스 : $ 1756 * 2
2. Aurora-PostgreSQL/r5.4xlarge(16c, 128G)/ReadReplica 1개 추가
    인스턴스 : $ 2049 * 2

 

[가용성 - DB Instance]

1. postgreSQL RDS
    Active-Standby 구성

2. Aurora
    Primary-Replica(0-15) 구성
    - Primary : Read/Write
    - Replica : Read Only

 

[가용성 - Disk]

1. postgreSQL RDS (Multi-AZ)
    - 2개의 AZ에 데이터 유지/관리
    - 최대 1개 데이터 사본 손실 -> Read/Write 영향 없음

2. Aurora
    - 3개의 AZ에 6개 데이터 복사본을 유지/관리함 (AZ당 2개 복사본)
    - 최대 2개 데이터 사본 손실 -> Read/Write 영향 없음
    - 최대 3개 데이터 사본 손실 -> Read 영향 없음

 

[장애조치시간]

1. postgreSQL RDS (Multi-AZ)
    일반적으로 60-120 초

2. Aurora
    (Replica 있는 경우) 일반적으로 30초 이내

 

[성능]
Amazon Aurora PostgreSQL은 PostgreSQL보다 3배 뛰어난 성능을 제공

postgreSQL vs Amazon Aurora 성능 비교 (PPT 뒷부분)

www.slideshare.net/awskorea/2-amazonaurora-migration-usecase

 

[백업]

1. postgreSQL RDS
    자동 백업 비활성화 가능
    (Multi-AZ) 백업은 Standby를 이용하므로 I/O 중단 없음

2. Aurora
    자동 백업 비활성화 불가능
    백업은 데이터베이스 성능에 영향을 미치지 않음 (FAQ)

3. 공통
    자동 백업 보존 기간은 1~35일
    (자동 백업 활성화된 경우) 최근 복구 시간은 일반적으로 현재 시간에서 5분 이내

 

[참고]

aws.amazon.com/ko/rds/aurora/faqs/

Amazon Aurora FAQ – Amazon Web Services

 

Amazon Aurora Storage 엔진 소개

aws.amazon.com/ko/blogs/korea/databaseintroducing-the-aurora-storage-engine/

Amazon Aurora Storage 엔진 소개 | Amazon Web Services

 

www.slideshare.net/awskorea/amazon-aurora-deep-dive

Amazon Aurora 100% 활용하기

-- Amazon Aurora as an Alternative to Oracle RAC 

aws.amazon.com/ko/blogs/database/amazon-aurora-as-an-alternative-to-oracle-rac/

Amazon Aurora as an Alternative to Oracle RAC | Amazon Web Services

 

aws.amazon.com/ko/blogs/korea/failover-with-amazon-aurora-postgresql/

Amazon Aurora – PostgreSQL을 통한 장애 복원 기능 활용하기 | Amazon Web Services

 

# HA (Multi-AZ) for Amazon RDS

docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZ.html