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
450
JAWS-UG横浜 #63 AWS re:Invent 2023 宇宙一早い Recap イケてるアップデートを宇宙いち早く紹介するよ!
maroon1st
0
6
Google Cloud Next '23 Recap AI 時代のデータベース関連のイケてるアップデートをお届け
maroon1st
0
760
Zaraz 試してみた #CloudflareUG #CloudflareUG_www
maroon1st
0
790
Cloudflare Application Service のサイト登録の種類を確認してみた #CloudflareUG #CloudflareUG_hnd
maroon1st
0
920
Cloudflare 概論 Cloudflare Meetup Kick Off! #CloudflareUG
maroon1st
1
1.5k
Cloudflare の画像最適化機能を紹介してみる
maroon1st
0
1.9k
データベースの発表には RDBMS 以外もありますよ
maroon1st
0
520
Aurora Serverless v2 のスケールの傾向を実際に確認してみた
maroon1st
0
170
Other Decks in Programming
See All in Programming
TypeScriptのパフォーマンス改善
yajihum
12
4.9k
slow types ってなんだろう?
karad
0
210
Native Federation: The Future of Micro Frontends in Angular
manfredsteyer
PRO
0
160
Revisiting the Hotwire Landscape after Turbo 8 @ RailsConf 2024, Detroit
marcoroth
3
590
Criando a Woovi em uma semana
daniloab
0
120
Effectで作る堅牢でスケーラブルなAPIゲートウェイ / Robust and Scalable API Gateway Built on Effect
yasaichi
7
1.2k
WinActorの勉強を継続する方法
tamai_63
0
130
Kotlin Multiplatform at Stable and Beyond (Android Makers 2024)
zsmb
0
600
Escolhendo (ou não) o melhor ORM para o seu projeto
andreiacsilva
1
140
Go製Webアプリケーションのエラーとの向き合い方大全、あるいはやっぱりスタックトレース欲しいやん / Kyoto.go #50
utgwkk
6
2k
TypeScript 関数型スタイルでバックエンド開発のリアル
naoya
49
16k
PHPコードの実行モデルを理解する / Understanding-the-PHP-Execution-Model
shin1x1
0
880
Featured
See All Featured
[RailsConf 2023] Rails as a piece of cake
palkan
28
4k
VelocityConf: Rendering Performance Case Studies
addyosmani
321
23k
Build The Right Thing And Hit Your Dates
maggiecrowley
25
2k
The Brand Is Dead. Long Live the Brand.
mthomps
49
30k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
228
16k
How to train your dragon (web standard)
notwaldorf
75
5.2k
Rebuilding a faster, lazier Slack
samanthasiow
74
8.3k
Scaling GitHub
holman
457
140k
Robots, Beer and Maslow
schacon
PRO
155
7.9k
Visualization
eitanlees
137
14k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
22
1.4k
RailsConf 2023
tenderlove
9
580
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