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
330
ハワイアン航空 ステータスへの道 #HAairstudy
maroon1st
0
230
[JAWS-UG横浜 #79] re:Invent 2024 の DB アップデートは Multi-Region!
maroon1st
1
230
[JAWS-UG横浜 #80] うわっ…今年のServerless アップデート、少なすぎ…?
maroon1st
1
260
【re:Growth 2024】 Aurora DSQL をちゃんと話します!
maroon1st
1
1.2k
[JAWS-UG横浜 #76] イケてるアップデートを宇宙いち早く紹介するよ!
maroon1st
0
750
【DevelopersIO 2024】AI 半可通なのにエッジ AI 機能を全力で解説してみる 〜Cloudflare の場合〜
maroon1st
0
480
Google Cloud の RDB を徹底比較! 選び方と最新機能紹介 #devio2024
maroon1st
0
1.6k
Google Cloud の AI を支える裏側のインフラを垣間見る!
maroon1st
0
850
Other Decks in Programming
See All in Programming
Code as Context 〜 1にコードで 2にリンタ 34がなくて 5にルール? 〜
yodakeisuke
0
120
PipeCDのプラグイン化で目指すところ
warashi
1
240
20250628_非エンジニアがバイブコーディングしてみた
ponponmikankan
0
620
dbt民主化とLLMによる開発ブースト ~ AI Readyな分析サイクルを目指して ~
yoshyum
2
250
ペアプロ × 生成AI 現場での実践と課題について / generative-ai-in-pair-programming
codmoninc
0
510
Deep Dive into ~/.claude/projects
hiragram
10
2.2k
CursorはMCPを使った方が良いぞ
taigakono
1
210
20250704_教育事業におけるアジャイルなデータ基盤構築
hanon52_
4
260
都市をデータで見るってこういうこと PLATEAU属性情報入門
nokonoko1203
1
590
今ならAmazon ECSのサービス間通信をどう選ぶか / Selection of ECS Interservice Communication 2025
tkikuc
21
3.8k
0626 Findy Product Manager LT Night_高田スライド_speaker deck用
mana_takada
0
140
明示と暗黙 ー PHPとGoの インターフェイスの違いを知る
shimabox
2
390
Featured
See All Featured
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
252
21k
Making Projects Easy
brettharned
116
6.3k
4 Signs Your Business is Dying
shpigford
184
22k
How to Think Like a Performance Engineer
csswizardry
24
1.7k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
45
7.5k
Designing for Performance
lara
609
69k
A better future with KSS
kneath
239
17k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
657
60k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
46
9.6k
Visualization
eitanlees
146
16k
Build your cross-platform service in a week with App Engine
jlugia
231
18k
Raft: Consensus for Rubyists
vanstee
140
7k
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