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へ移行し...
Search
ekanai
February 23, 2019
Technology
0
3.7k
数十億レコードのRDS MySQL5.6を1週間程でAurora MySQL5.7へ移行した時の話 #jawsdays
ekanai
February 23, 2019
Tweet
Share
More Decks by ekanai
See All by ekanai
[Modern App Summit '25] 200 億レコードを超える Aurora を Cloud Spanner へ移行
3utama
0
76
TimeTree のデータベースを Aurora から Cloud Spanner へ移行
3utama
1
470
[TimeTree] Aurora から Spanner への 移行の決断と背景
3utama
2
4k
TimeTree の SRE が海外展開においてやったこと&やってないこと by【TimeTree × みてね勉強会】 グローバル対応への挑戦 〜SRE/インフラ編〜
3utama
1
600
1日でSSHをやめることができた話 #jawsdays
3utama
10
17k
Other Decks in Technology
See All in Technology
Introduction to Sansan for Engineers / エンジニア向け会社紹介
sansan33
PRO
5
43k
HonoとJSXを使って管理画面をサクッと型安全に作ろう
diggymo
0
130
速習AGENTS.md:5分で精度を上げる "3ブロック" テンプレ
ismk
6
1.9k
OCIjp_Oracle AI World_Recap
shinpy
1
110
新規事業におけるGORM+SQLx併用アーキテクチャ
hacomono
PRO
0
430
Data Hubグループ 紹介資料
sansan33
PRO
0
2.2k
ソフトウェアエンジニアの生成AI活用と、これから
lycorptech_jp
PRO
0
620
今この時代に技術とどう向き合うべきか
gree_tech
PRO
2
2.1k
AIエージェント入門 〜基礎からMCP・A2Aまで〜
shukob
0
110
Azureコストと向き合った、4年半のリアル / Four and a half years of dealing with Azure costs
aeonpeople
1
230
技育祭2025【秋】 企業ピッチ/登壇資料(高橋 悟生)
hacobu
PRO
0
120
Digitization部 紹介資料
sansan33
PRO
1
5.6k
Featured
See All Featured
Making the Leap to Tech Lead
cromwellryan
135
9.6k
GitHub's CSS Performance
jonrohan
1032
470k
BBQ
matthewcrist
89
9.8k
A designer walks into a library…
pauljervisheath
209
24k
Into the Great Unknown - MozCon
thekraken
40
2.1k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
190
55k
What’s in a name? Adding method to the madness
productmarketing
PRO
24
3.7k
YesSQL, Process and Tooling at Scale
rocio
173
14k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
31
9.7k
Building a Scalable Design System with Sketch
lauravandoore
463
33k
The World Runs on Bad Software
bkeepers
PRO
72
11k
Thoughts on Productivity
jonyablonski
70
4.9k
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ແཧ͠ͳ͍
͋Γ͕ͱ͏͍͟͝·ͨ͠