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
320
ハワイアン航空 ステータスへの道 #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
740
【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
「ElixirでIoT!!」のこれまでとこれから
takasehideki
0
370
プロダクト志向ってなんなんだろうね
righttouch
PRO
0
160
Result型で“失敗”を型にするPHPコードの書き方
kajitack
4
500
Create a website using Spatial Web
akkeylab
0
310
git worktree × Claude Code × MCP ~生成AI時代の並列開発フロー~
hisuzuya
1
500
既存デザインを変更せずにタップ領域を広げる方法
tahia910
1
240
Code as Context 〜 1にコードで 2にリンタ 34がなくて 5にルール? 〜
yodakeisuke
0
110
PHPで始める振る舞い駆動開発(Behaviour-Driven Development)
ohmori_yusuke
2
230
Beyond Portability: Live Migration for Evolving WebAssembly Workloads
chikuwait
0
390
Node-RED を(HTTP で)つなげる MCP サーバーを作ってみた
highu
0
100
「Cursor/Devin全社導入の理想と現実」のその後
saitoryc
0
240
AIコーディング道場勉強会#2 君(エンジニア)たちはどう生きるか
misakiotb
1
250
Featured
See All Featured
Large-scale JavaScript Application Architecture
addyosmani
512
110k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
252
21k
Documentation Writing (for coders)
carmenintech
72
4.9k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
29
9.5k
Building Better People: How to give real-time feedback that sticks.
wjessup
367
19k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
367
26k
StorybookのUI Testing Handbookを読んだ
zakiyama
30
5.8k
Docker and Python
trallard
44
3.4k
Producing Creativity
orderedlist
PRO
346
40k
Designing Experiences People Love
moore
142
24k
Testing 201, or: Great Expectations
jmmastey
42
7.5k
Agile that works and the tools we love
rasmusluckow
329
21k
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