Created
November 29, 2023
Created by
D
DaEun KimTags
AWS
Property
Global Database
- primary cluster in region A
- secondary cluster in region B
Swichover
- μ΄λ€ 리μ λ΄μ μλ primary ν΄λ¬μ€ν°κ° μ£½μΌλ©΄ λ€λ₯Έ 리μ μ μλ secondary ν΄λ¬μ€ν°κ° primary μΌλ‘ μΉκ²© β λμ in-flight replicated λ°μ΄ν°λ μ μ€λ μ μλ€.
- ν΄λ¬μ€ν° κ° λ³΅μ λ₯Ό μν΄ replication agent/server κ° μλ€.
- lag μ΅μννκΈ° μν΄ μ£Όλ‘ κ°κΉμ΄ 리μ μ secondary λ₯Ό λ§λ λ€.
Write fowarding
- primary ν΄λ¬μ€ν° λ΄ primary μΈμ€ν΄μ€μ μ°κΈ° μννλ©΄ secondary ν΄λ¬μ€ν° λ΄ primary/replica κΉμ§ λ°μ΄ν° 볡μ λ₯Ό μν
Fast clones
Export to S3 via clone
- parallel export available
Enhanced binlog
- two phase commit μ 볡μ‘νλ€ β two phase commit ꡬ쑰λ₯Ό κ°μ
pgvector (for postgresql)
- embedding vendor ν€μλλ‘ λ²‘ν° μ¬μ© κ°λ₯
Aurora serverless
- μ ν리μΌμ΄μ μλ²κ° scale in/out νλ μ λμ λ°λΌ Aurora μλ²λ scale in/out νλ€. (CPU/memory resizing)
- λ©λͺ¨λ¦¬ 리μ¬μ΄μ§ = buffer pool resizing (κΈ°λ³ΈμΌλ‘ μ μ λλ λ©λͺ¨λ¦¬ λΉμ¨ : λ²νΌ ν 75%, ν 25% β λ²νΌμ νμ λΉμ¨μ μλμΌλ‘ μ‘°μ )
- λ¨λ λ©λͺ¨λ¦¬κ° μμΌλ©΄ λ©λͺ¨λ¦¬ μ¬μ©μ μλμΌλ‘ μ€μΈλ€.
Blue/Green deployment
- blue β green ν΄λ¬μ€ν° μΌλ‘ λ°μ΄ν° 볡μ λ₯Ό νκΈ° λλ¬Έμ cutover / rollback κ°λ₯?
- cutover μ΄νμλ νμ¬ next λ ν΄λ¬μ€ν°λ₯Ό λλ?
- μ¬μ© λͺ©μ
- DBMS λ²μ μ λ°μ΄νΈ
- DDL ν¬ν¨ν νΌμ² λ°°ν¬
Zero-ETL
- by data streaming from Aurora to Redshift
New Aurora Storage Type
- I/O-optimized
- predictable price
- improved price performance for IO-heavy workload
- apply to cluster unit (ν΄λ¬μ€ν° λ¨μλ‘ μ μ© κ°λ₯)
- how it works : optimized reads with tiered cache
- λλΉ λ΄ λ¨μμκ° λΉ λμ€ν¬ IO νμλ₯Ό μ€μΈλ€. β μΊμ ννΈμ¨μ λμ¬μΌ κ°λ₯.
- μΊμ ννΈμ¨μ λμ΄λ €λ©΄ νν°μ λμ μ ν΄μΌ.
- μΊμ ννΈμ¨μ λμ΄λ €λ©΄ μΈλ±μ±μ μ ν΄μΌ. (ν νΈλ¦¬ ꡬ쑰 λ΄ νΉμ μΈλ±μ€ λΈλ‘μ μμ£Ό μ κ·Όνλ λ§νΌ ν΄λΉ μΈλ±μ€μ λν μΊμ ννΈμ¨μ΄ λμμ§ κ²μ)
Limitless Database
- scale β managed sharding
- μ€λ©μ μ μ©νλ©΄ μ§λ©΄νλ κ³Όμ λ€
- inconsistency
- DDL μν μ μ€λ μ€μ μΌλΆκ° μ€ν¨νλ κ²½μ°
- λμΌ μΏΌλ¦¬λ₯Ό μννμΌλ μ€λ μ€μ μΌλΆκ° 쿼리 μ§μ°μΌλ‘ μΈν΄ λ€λ₯Έ κ²°κ³Όλ₯Ό μ‘°ννλ κ²½μ°
- capacity managment
- single database gets bigger β shard μ§ν β μ€λ© λΆκ· ν λ°μ β λ‘λκ° λ§μ μ€λλ μ¬μ λλ¦Ό (κ·Όλ° λ‘λ μ μ μΈμ€ν΄μ€λ€λ κ°μ΄ λλ €μΌ λ¨?) β λΆνμν κΈμ μ λΉμ©μΌλ‘ λμμ΄
- limitless λ μ€λ©μμ λ°μκ°λ₯ν λ¬Έμ λ€μ κ°μ νλ€.
- 2λ°±λ§ TPS 보μ₯
- how?
- automated re-sharding (λ΄λΆμ μΌλ‘ νΉμ μ€λμ λ°μ΄ν°κ° λͺ°λ¦¬λ©΄ ν΄λΉ μ€λ λμμΌλ‘ λ€μ μ€λ© μ§ν)
- serverless capacity (νΈλν½μ΄ λ§κ³ μ μμ λ°λΌ μ¬μμ λλ Έλ€ μ€μλ€)
- consistent DDL/Query/Backup
- λ΄λΆμ μΌλ‘ global clock μ κ°μ§κ³ μμ
- cross-shard transaction μ κ²½μ° global clock + κ° μ€λμ μ€λ μ·μ μ¬μ©νμ¬ μκ°μ μ§μ° μμ΄ consistent read κ°λ₯