Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
お手軽にリージョン間DRができるAurora Global Databaseの実力を見てみた
Search
maroon1st
December 05, 2018
Programming
0
3.8k
お手軽にリージョン間DRができるAurora Global Databaseの実力を見てみた
本資料はre:Growth 2018の発表資料です。
https://dev.classmethod.jp/news/181205-re-growth/
maroon1st
December 05, 2018
Tweet
Share
More Decks by maroon1st
See All by maroon1st
[JAWS DAYS 2025] 最近の DB の競合解決の仕組みが分かった気になってみた
maroon1st
0
340
ハワイアン航空 ステータスへの道 #HAairstudy
maroon1st
0
260
[JAWS-UG横浜 #79] re:Invent 2024 の DB アップデートは Multi-Region!
maroon1st
1
240
[JAWS-UG横浜 #80] うわっ…今年のServerless アップデート、少なすぎ…?
maroon1st
1
270
【re:Growth 2024】 Aurora DSQL をちゃんと話します!
maroon1st
1
1.2k
[JAWS-UG横浜 #76] イケてるアップデートを宇宙いち早く紹介するよ!
maroon1st
0
750
【DevelopersIO 2024】AI 半可通なのにエッジ AI 機能を全力で解説してみる 〜Cloudflare の場合〜
maroon1st
0
490
Google Cloud の RDB を徹底比較! 選び方と最新機能紹介 #devio2024
maroon1st
0
1.7k
Google Cloud の AI を支える裏側のインフラを垣間見る!
maroon1st
0
850
Other Decks in Programming
See All in Programming
PipeCDのプラグイン化で目指すところ
warashi
1
280
dbt民主化とLLMによる開発ブースト ~ AI Readyな分析サイクルを目指して ~
yoshyum
3
1k
20250704_教育事業におけるアジャイルなデータ基盤構築
hanon52_
5
840
The Evolution of Enterprise Java with Jakarta EE 11 and Beyond
ivargrimstad
0
100
ソフトウェア品質を数字で捉える技術。事業成長を支えるシステム品質の マネジメント
takuya542
2
14k
“いい感じ“な定量評価を求めて - Four Keysとアウトカムの間の探求 -
nealle
2
11k
ふつうの技術スタックでアート作品を作ってみる
akira888
1
900
GPUを計算資源として使おう!
primenumber
1
170
ペアプロ × 生成AI 現場での実践と課題について / generative-ai-in-pair-programming
codmoninc
2
19k
レベル1の開発生産性向上に取り組む − 日々の作業の効率化・自動化を通じた改善活動
kesoji
0
240
なぜ「共通化」を考え、失敗を繰り返すのか
rinchoku
1
660
「テストは愚直&&網羅的に書くほどよい」という誤解 / Test Smarter, Not Harder
munetoshi
0
180
Featured
See All Featured
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
30
2.1k
Scaling GitHub
holman
460
140k
The Invisible Side of Design
smashingmag
301
51k
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.4k
Build The Right Thing And Hit Your Dates
maggiecrowley
36
2.8k
Rails Girls Zürich Keynote
gr2m
95
14k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
44
2.4k
Git: the NoSQL Database
bkeepers
PRO
430
65k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
126
53k
How GitHub (no longer) Works
holman
314
140k
Adopting Sorbet at Scale
ufuk
77
9.5k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
229
22k
Transcript
͓खܰʹϦʔδϣϯؒ%3͕Ͱ͖Δ "VSPSB(MPCBM%BUBCBTFͷ࣮ྗΛݟͯΈͨ "84%FFQ3BDFS-FBHVF%SJWFS )BKJNF0HVSJ #cmregrowth
8IPBN* *BN"84%FFQ3BDFS-FBHVF%SJWFS #cmregrowth
DeepRacerFedexͰຊૹͬͨͷͰ͕͢ શ͘࿈བྷ͕ͳ͍ͷͰෆ҆Ͱ͢ #cmregrowth
8IPBN* େ܀फʢ!NBSPPOTUʣ ϝʔΧʔܥ4*FSʹ΄Ͳࡏ੶ͯ͠ લʹΫϥεϝιουʹδϣΠϯ "84ಋೖίϯαϧςΟϯάΛϝΠϯʹ Πϯϑϥߏஙߦ͍ͬͯ·͢ ͖ͳαʔϏεɿ"NB[PO"VSPSB #cmregrowth
ࠓճ༷ʑͳൃද͕͋Γ·͕ͨ͠ %#ܥͷൃදଟ͋Γ·ͨ͠ #cmregrowth
DBܥ৽αʔϏε #cmregrowth
%#ܥΞοϓσʔτ w "84-BLF'PSNBUJPO ηΩϡΞͳ%BUB-BLFΛ؆୯ʹߏஙͰ͖Δ w "NB[PO2VBOUVN-FEHFS%BUBCBTF 2-%#
ෆมͰݕূՄೳͳݩாσʔλϕʔε w "NB[PO5JNFTUSFBN ΓஹΠϕϯτΛॲཧͰ͖Δ࣌ܥྻσʔλϕʔε #cmregrowth
DBܥΞοϓσʔτ #cmregrowth
%#ܥΞοϓσʔτ w "NB[PO%ZOBNP%#5SBOTBDUJPOT w "NB[PO3FETIJGU$PODVSSFODZ4DBMJOH w "NB[PO"VSPSB(MPCBM%BUBCBTF w
"NB[PO%ZOBNP%#3FBE8SJUF$BQBDJUZ0O%FNBOE w "NB[PO3%4PO7.XBSFͷύϒϦοΫϓϨϏϡʔ w "NB[PO"VSPSB1PTUHSF42-4FSWFSMFTT #cmregrowth
"HFOEB w "VSPSBͷجૅͷৼΓฦΓ w "VSPSB(MPCBM%BUBCBTFͱʁ w ࣮ࡍʹಈ͔࣮ͯ͠ྗΛ֬ೝ͢Δ w
·ͱΊ #cmregrowth
"VSPSBͷجૅͷৼΓฦΓ #cmregrowth
"VSPSB$MVTUFSͷશମ Availability Zone A "VSPSB4UPSBHF&OHJOF ཧతͳڞ༗ࢄετϨʔδ Availability Zone
B Availability Zone C $BDIF $BDIF $BDIF $BDIF $BDIF 4UPSBHF /PEF 4UPSBHF /PEF 4UPSBHF /PEF 4UPSBHF /PEF 4UPSBHF /PEF 4UPSBHF /PEF #cmregrowth
-PH4USVDUVSFE4UPSBHF w σʔλΛϩάͷΑ͏ʹઌ಄͔Βه͢Δ w ֤ʑͷϩάϨίʔυ-PH4FRVFODF/VNCFS ʢ-4/ʣΛ࣋ͪෆɾॏෳΛผͰ͖Δ w طଘͷσʔλ͕͋ΔϒϩοΫΛ্ॻ͖͠ͳ͍
ۭ͖εϖʔε EBUB EBUB EBUB EBUB EBUB ࣌ܥྻ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ8SJUFʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- 7$-7PMVNF$PNQMFUF-4/ʢϘϦϡʔϜྃ-4/ʣ 7%-7PMVNF%VSBCMF-4/ʢϘϦϡʔϜٱ-4/ʣ $1-$POTJTUFODZ1PJOU-4/ʢҰ؏ੑϙΠϯτ-4/ʣ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ8SJUFʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7$- 7%- $1- ॻ͖ࠐΈ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ8SJUFʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7%- $1- 7$- ॻ͖ࠐΈ ॻ͖ࠐΈ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ8SJUFʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7%- $1- 7$- ॻ͖ࠐΈ ॻ͖ࠐΈ σʔλͷิ ಉ";ͷσʔλΛ ίϐʔͯ͠ิ͢Δ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ$PNNJUʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7%- $1- ίϛοτ-4/ΑΓ7%-͕ਐΜͰ͍Ε ίϛοτ͕Ͱ͖Δ ॻ͖ࠐΈ ॻ͖ࠐΈ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ3FBEʣ ҰൠతͳσʔλΩϟγϡ ී௨μʔςΟϖʔδ͕͋Εஔ͖͑લʹ σΟεΫϑϥογϡ Zone-A 4FHNFOU" 4FHNFOU" 4$-
4$- Zone-B 4FHNFOU# 4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- Cache 7%- $1- $1- #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ3FBEʣ "VSPSBͷϖʔδΩϟγϡ Ωϟογϡ͕ϖʔδ-4/Λอ࣋ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$-
Zone-B 4FHNFOU# 4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- ページLSN Cache 7%- $1- $1- #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ3FBEʣ "VSPSBͷϖʔδΩϟγϡ Ωϟογϡ͕ϖʔδ-4/Λอ࣋ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$-
Zone-B 4FHNFOU# 4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- 7%- $1- $1- ϖʔδ-4/㱢7%-Ͱ ϖʔδΞτ ページLSN Cache #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ3FBEʣ "VSPSBͷϖʔδΩϟγϡ Ωϟογϡϛεͷ߹ 7%-Λཁٻ Zone-A 4FHNFOU" 4FHNFOU" 4$-
4$- Zone-B 4FHNFOU# 4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7%-Λཁٻ 7%- $1- ページLSN Cache #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ3FDPWFSZʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7%- $1- ॻ͖ࠐΈ ॻ͖ࠐΈ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ3FDPWFSZʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7%- $1- ॻ͖ࠐΈ ॻ͖ࠐΈ ॻ͖ࠐΈதʹ Ϋϥογϡ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ3FDPWFSZʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7%- $1- ॻ͖ࠐΈ ॻ͖ࠐΈ #cmregrowth
-PH4USVDUVSFE4UPSBHFʢ3FDPWFSZʣ Zone-A 4FHNFOU" 4FHNFOU" 4$- 4$- Zone-B 4FHNFOU#
4FHNFOU# 4$- 4$- Zone-C 4FHNFOU$ 4FHNFOU$ 4$- 4$- $1- 7%- $1- ॻ͖ࠐΈ ॻ͖ࠐΈ ॻ͖ࠐΈ 4FHNFOU" 4FHNFOU" 4FHNFOU# 4FHNFOU# 4FHNFOU$ 4FHNFOU$ LAL:LSN Allocation Limit(LSN割当上限) #cmregrowth
(ετϨʔδͷࡉ͔͍ಈ࡞Ͳ͏Ͱྑͯ͘) ͭ·ΓAuroraͷετϨʔδ هܕͷϩάߏʹͳ͍ͬͯΔ #cmregrowth
"VSPSB(MPCBM%BUBCBTFͱ #cmregrowth
"NB[PO"VSPSB(MPCBM%BUBCBTFͱ Amazon AuroraͷผϦʔδϣϯͷ ϨϓϦέʔγϣϯػೳͰ͢ #cmregrowth
ͦΕͬͯલ͔Βແ͔͚ͬͨͬʁ #cmregrowth
"VSPSBϦʔδϣϯؒϨϓϦέʔγϣϯ ࣮લʹಉ༷ͷػೳ͕ϦϦʔεࡁΈͰ͢ https://aws.amazon.com/jp/blogs/news/new-cross-region-read-replicas-for-amazon-aurora/ #cmregrowth
͡Ό͋Կ͕ҧ͏ͷʁʁʁ #cmregrowth
େ͖ͳҧ͍ϨϓϦέʔγϣϯํࣜ w طଘͷ$SPTT3FHJPO3FBE3FQMJDB.Z42-ϕʔεͷ ϨϓϦέʔγϣϯ w "VSPSB(MPCBM%BUBCBTF"VSPSBετϨʔδϕʔεͷ ϨϓϦέʔγϣϯ #cmregrowth
ϨϓϦέʔγϣϯํࣜ طଘͷ$SPTT3FHJPO3FBE3FQMJDB #cmregrowth
ϨϓϦέʔγϣϯํࣜ "VSPSB(MPCBM%BUBCBTF https://www.slideshare.net/AmazonWebServices/amazon-aurora-storage-demystified-how-it-all-works-dat363-aws-reinvent-2018/41 #cmregrowth
ػೳؒͷҧ͍ $SPTT3FHJPO 3FBE3FQMJDB "VSPSB(MPCBM %BUBCBTF ϨϓϦέʔγϣϯํࣜ .Z42-ͷCJOMPHϕʔε "VSPSBετϨʔδϕʔε
సૹσʔλͷ༰ ཧతʹมߋͨ͠ σʔλશମ ཧతʹมߋͨࠩ͠ ϥά ඵ͔Βेඵ ֓ͶඵҎʢ࠷େඵʣ CJOMPH ඞཁ ෆཁ ੑೳӨڹ ͋ΔఔԼ ͔ᷮͳԼ #cmregrowth
Aurora Global Database AuroraಠࣗͷϨϓϦέʔγϣϯํࣜͰ ߴͰੑೳӨڹ͕গͳ͍ RPO(ඪ෮چ)ɿ5ඵ RTO(ඪ෮چ࣌ؒ)ɿ1 #cmregrowth
࣮ࡍʹಈ͔࣮ͯ͠ྗΛ֬ೝ͢Δ #cmregrowth
σʔλೖͷ࣮ߦ࣌ؒ 3%#ͷ൚༻ෛՙςετπʔϧͷ+ECD3VOOFSͰ51$$ ༻σʔλͷϩʔυΛ࣮ߦͯ͠ɺ࣌ؒΛܭଌɻ ΤʔδΣϯτ ฒྻ ɿɺ4DBMF'BDUPSɿ
ΤʔδΣϯτ ฒྻ ɿɺ4DBMF'BDUPSɿ ถࠃ౦෦ όʔδχΞ෦ ˠถࠃ౦෦ ΦϋΠΦ #cmregrowth
σʔλϩʔυͷ࣮ߦ݁Ռ ϨϓϦέʔγϣϯ ແ͠ $SPTT3FHJPO 3FBE3FQMJDB "VSPSB(MPCBM %BUBCBTF ύλʔϯ̍
ύλʔϯ̎ #cmregrowth
ࠓճͷಈ࡞݅Ͱ ༗ҙͳ͕ࠩग़ͳ͔ͬͨɻɻɻ #cmregrowth
ͰAurora Global Databaseʹ େ͖ͳར͕͋Δ #cmregrowth
ϨϓϦέʔγϣϯํࣜ "VSPSB(MPCBM%BUBCBTF https://www.slideshare.net/AmazonWebServices/amazon-aurora-storage-demystified-how-it-all-works-dat363-aws-reinvent-2018/41 #cmregrowth
ϨϓϦέʔγϣϯํࣜ "VSPSB(MPCBM%BUBCBTF https://www.slideshare.net/AmazonWebServices/amazon-aurora-storage-demystified-how-it-all-works-dat363-aws-reinvent-2018/41 ✕ ✕ ✕ %3αΠτʹ%#Πϯελϯεͳͯ͘ ϨϓϦέʔγϣϯͰ͖ΔΜ͡Όͳ͍ʁ
#cmregrowth
ҙ ϚωʔδϝϯτίϯιʔϧͰΫϥελ ετϨʔδ ͱ %#Πϯελϯε͕ηοτͰىಈ͠·͕͢ɺ "84$-*͔Β࡞͢Δͱݸผʹ࡞Ͱ͖·͢ɻ #cmregrowth
ηΧϯμϦϦʔδϣϯͰ%#Πϯελϯεແ͠Ͱ ϨϓϦέʔγϣϯՄೳͰͨ͠ʂ https://www.slideshare.net/AmazonWebServices/amazon-aurora-storage-demystified-how-it-all-works-dat363-aws-reinvent-2018/41 ✕ ✕ ✕ #cmregrowth
ͭ·ΓDRαΠτͷػίετΛ ۃݶ·ͰՁ֨ʹ͑ΒΕ·͢ʂ #cmregrowth
·ͱΊ #cmregrowth
·ͱΊ w "VSPSBͷετϨʔδ͕هܕͷϩάߏετϨʔδ Ͱ͋Δ͜ͱͰ(MPCBM%BUBCBTF͕࣮ݱ͞Ε͍ͯΔ w "VSPSB(MPCBM%BUBCBTFετϨʔδϕʔεͷಠ ࣗϨϓϦέʔγϣϯͰߴͰੑೳӨڹ͕গͳ͍ w
ηΧϯμϦϦʔδϣϯʹ%#Πϯελϯε͕ͳͯ͘ ྑ͍ͷͰ%3ͷͨΊͷίετΛେ෯ʹԼ͛ΒΕΔ #cmregrowth
None