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
数十億レコードのRDS MySQL5.6を1週間程でAurora MySQL5.7へ移行した時の話 #jawsdays
Search
ekanai
February 23, 2019
Technology
0
3.1k
数十億レコードのRDS MySQL5.6を1週間程でAurora MySQL5.7へ移行した時の話 #jawsdays
ekanai
February 23, 2019
Tweet
Share
More Decks by ekanai
See All by ekanai
TimeTree の SRE が海外展開においてやったこと&やってないこと by【TimeTree × みてね勉強会】 グローバル対応への挑戦 〜SRE/インフラ編〜
3utama
1
290
1日でSSHをやめることができた話 #jawsdays
3utama
10
16k
Other Decks in Technology
See All in Technology
KubeConにproposalを送りたい人へのアドバイス
sat
PRO
3
220
MapLibreとAmazon Location Service
dayjournal
1
140
2024/4/26 コンピュータ歴史博物館解説告知
toshi_atsumi
0
220
ワールドカフェI /チューターを改良する / World Café I and Improving the Tutors
ks91
PRO
0
120
Reducing Cross-Zone Egress at Spotify with Custom gRPC Load Balancing Recap
koh_naga
0
190
LLM とプロンプトエンジニアリング/チューターをビルドする / LLM and Prompt Engineering and Building Tutors
ks91
PRO
0
250
「スニダン」開発組織の構造に込めた意図 ~組織作りはパッションや政治ではない!~
rinchsan
3
520
推しは推せるときに推せ! プロダクトにフィードバックしていこう
nakasho
0
280
Cloud Native Java with Spring Boot (CNCF Aarhus, April 2024)
thomasvitale
1
160
生産性向上チームの紹介
cybozuinsideout
PRO
1
860
ServiceNow Knowledge 24の歩き方 EYストラテジー・アンド・コンサルティング
manarobot
0
180
Postman v10リリース後を振り返る / Looking back at Postman v10 after release
yokawasa
1
150
Featured
See All Featured
The Cost Of JavaScript in 2023
addyosmani
16
3.8k
What the flash - Photography Introduction
edds
64
11k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
9
8.3k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
34
8.9k
Documentation Writing (for coders)
carmenintech
60
3.9k
Happy Clients
brianwarren
92
6.4k
BBQ
matthewcrist
80
8.8k
Atom: Resistance is Futile
akmur
259
25k
In The Pink: A Labor of Love
frogandcode
138
21k
Practical Orchestrator
shlominoach
182
9.7k
Building an army of robots
kneath
300
41k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
17
1.4k
Transcript
ेԯϨίʔυͷ3%4.Z42-Λ िؒఔͰ"VSPSB.Z42-Ҡ ߦͨ࣌͠ͷ KBXTEBZT
ࣗݾհ
ۚҪӫت ,BOBJ&JLJ גࣜձࣾ+6#*-&&803,4
T i m e T r e e ΧϨϯμʔγΣΞαʔϏε
None
ʮڵຯɺؔ৺͕͋Δʯ ͰऴΘΒͤͳ͍ɻ TimeTreeࠂίϯςϯπͷ1ͭͱͯ͠ଊ͑ ͍ͯΔͨΊɺࠂΛదͳϢʔβʔʹదͳ λΠϛϯάͰ৴͢Δ͜ͱͰɺϢʔβʔɺ ࠂओͱʹՁͷ͋ΔϚονϯάϓϥοτ ϑΥʔϜͰ͋Γ͍ͨͱߟ͍͑ͯ·͢ɻ
ຊ
wҠߦ༰ w"84%.4Ͱେࣦഊ w࠶ܭը wͦͯ͠Ҡߦྃ
㾎Ҡߦ༰ w "84%.4Ͱେࣦഊ w ࠶ܭը w ͦͯ͠Ҡߦྃ
w3%4.Z42-"VSPSB.Z42- w̎ͭͷεΩʔϚ౷߹ w૯Ϩίʔυ͕ेԯʢdԯϨίʔυ͋Δςʔϒ ϧ͕ෳଘࡏʣΛશͯҠߦ Ҡߦ༰
w Ҡߦ༰ w"84%.4Ͱେࣦഊ w ࠶ܭը w ͦͯ͠Ҡߦྃ
w4BOECPY w୯७ͳҠߦ֬ೝͱςετ w1SPEVDUJPO w1SPEVDUJPOͷσʔλΛར༻ͨ͠Ϧϋͱςετ w࠷ऴҠߦ "84%.4Ͱେࣦഊ Ҡߦܭը
w%.4 Ҡߦํ๏ ࠶ܭը
"84%.4Ͱେࣦഊ 4BOECPY εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- Τϥʔͳ͔ͬ ͨͰ Αͬ͠Ό
"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- શવऴΘΒΜ ͳΜͯ
"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- αϒλεΫ ΠϯσοΫεແޮ ίϛοτϨʔτ
"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- Τϥʔ ͳΜͯ
"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42-
"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ ͝ΊΜͯ
wυΩϡϝϯτͪΌΜͱಡ͏ "84%.4Ͱେࣦഊ ڭ܇
"84%.4Ͱେࣦഊ
w Ҡߦ༰ w "84%.4Ͱେࣦഊ w࠶ܭը w ͦͯ͠Ҡߦྃ
w4BOECPY wσʔλछྨΛ༻ҙ w1SPEVDUJPO w1SPEVDUJPOͷσʔλΛར༻ͨ͠Ϧϋͱςετ w࠷ऴҠߦ ࠶ܭը Ҡߦܭըʢ৽ʣ
wNZTRMEVNQ Ҡߦํ๏ ࠶ܭը
w%#ߏ͚ͩNZTRMEVNQ wσʔλ4&-&$5 w4&-&$5݁ՌΛTQMJU w-0"%%"5"*/'*-& wҠߦલޙͷݕࡧ݁ՌΛ%*'' Ҡߦํ๏ ࠶ܭը
w Ҡߦ༰ w "84%.4Ͱେࣦഊ w ࢼߦࡨޡ wͦͯ͠Ҡߦྃ
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica ❌
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica ❌ %#ߏΛEVNQ
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica ❌ શ݅4&-&$5 HPPGZT
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica ❌ TQMJUͯ͠4 HPPGZT
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica ❌ -0"%%"5" */'*-& HPPGZT
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica ❌ HPPGZT શ݅4&-&$5
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica ❌ HPPGZT EJ⒎
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica HPPGZT ϨϓϦέʔγϣϯ ࠶։
ͦͯ͠Ҡߦྃ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance
.Z42- PO &$ DB Instance DB instance read replica
1SPEVDUJPOʢpOBMʣ 3%4.Z42- "VSPSB.Z42- DB Instance Γସ͑ ͦͯ͠Ҡߦྃ
·ͱΊ
wυΩϡϝϯτͪΌΜͱಡ͏ wΠϯϙʔτ͕݅ϙΠϯτ wҠߦ࣌ͷϦιʔεαΠζένΒͣʹ wແཧ͠ͳ͍
͋Γ͕ͱ͏͍͟͝·ͨ͠