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.4k
お手軽にリージョン間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
Google Cloud の AI を支える裏側のインフラを垣間見る!
maroon1st
0
390
JAWS-UG横浜 #63 AWS re:Invent 2023 宇宙一早い Recap イケてるアップデートを宇宙いち早く紹介するよ!
maroon1st
0
6
Google Cloud Next '23 Recap AI 時代のデータベース関連のイケてるアップデートをお届け
maroon1st
0
750
Zaraz 試してみた #CloudflareUG #CloudflareUG_www
maroon1st
0
770
Cloudflare Application Service のサイト登録の種類を確認してみた #CloudflareUG #CloudflareUG_hnd
maroon1st
0
900
Cloudflare 概論 Cloudflare Meetup Kick Off! #CloudflareUG
maroon1st
1
1.5k
Cloudflare の画像最適化機能を紹介してみる
maroon1st
0
1.9k
データベースの発表には RDBMS 以外もありますよ
maroon1st
0
510
Aurora Serverless v2 のスケールの傾向を実際に確認してみた
maroon1st
0
160
Other Decks in Programming
See All in Programming
単体テストを書かない技術 #phpcon_odawara
o0h
PRO
27
8.5k
AppRouter Panel Talk
yosuke_furukawa
PRO
1
450
Fast JSX: Don't clone props object #28768
yossydev
1
160
Three ways to use AI on Android: The Good, the Bad and the Ugly
marxallski
0
100
CDKコントリビュートの最初の壁を越えよう! -簡単issueの見つけ方-
badmintoncryer
3
190
0→1と1→10の狭間で Javaという技術選定を振り返る/Reflecting on the Decision to Choose Java Between Scaling from 0 to 1 and 1 to 10
jaguar_imo
2
400
Tailwind CSSを本気でカスタマイズする方法
fsubal
14
5.5k
Scalable Customer Journey Orchestration (CJO)
lewuathe
0
410
Try creating your own orderedmap
kazamori
1
170
Code Reviews
bkuhlmann
4
900
使ってみよう Azure AI Document Intelligence
kosmosebi
2
360
Build Apps for iOS, Android & Desktop in 100% Kotlin With Compose Multiplatform (mDevCamp 2024)
zsmb
0
420
Featured
See All Featured
Code Review Best Practice
trishagee
56
15k
Building Effective Engineering Teams - LeadDev
addyosmani
32
1.9k
A Modern Web Designer's Workflow
chriscoyier
689
190k
The Straight Up "How To Draw Better" Workshop
denniskardys
228
130k
Producing Creativity
orderedlist
PRO
338
39k
Building Better People: How to give real-time feedback that sticks.
wjessup
356
18k
Imperfection Machines: The Place of Print at Facebook
scottboms
261
12k
Gamification - CAS2011
davidbonilla
77
4.6k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
20
1.7k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
14
1.5k
Designing on Purpose - Digital PM Summit 2013
jponch
111
6.5k
Embracing the Ebb and Flow
colly
80
4.2k
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