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.6k
数十億レコードの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
55
TimeTree のデータベースを Aurora から Cloud Spanner へ移行
3utama
1
380
[TimeTree] Aurora から Spanner への 移行の決断と背景
3utama
2
3.9k
TimeTree の SRE が海外展開においてやったこと&やってないこと by【TimeTree × みてね勉強会】 グローバル対応への挑戦 〜SRE/インフラ編〜
3utama
1
560
1日でSSHをやめることができた話 #jawsdays
3utama
10
17k
Other Decks in Technology
See All in Technology
赤煉瓦倉庫勉強会「Databricksを選んだ理由と、絶賛真っ只中のデータ基盤移行体験記」
ivry_presentationmaterials
2
300
AWS認定を取る中で感じたこと
siromi
1
160
Geminiとv0による高速プロトタイピング
shinya337
0
240
あなたの声を届けよう! 女性エンジニア登壇の意義とアウトプット実践ガイド #wttjp / Call for Your Voice
kondoyuko
4
560
ネットワーク保護はどう変わるのか?re:Inforce 2025最新アップデート解説
tokushun
0
180
改めてAWS WAFを振り返る~業務で使うためのポイント~
masakiokuda
2
230
ビズリーチが挑む メトリクスを活用した技術的負債の解消 / dev-productivity-con2025
visional_engineering_and_design
3
6.2k
Yamla: Rustでつくるリアルタイム性を追求した機械学習基盤 / Yamla: A Rust-Based Machine Learning Platform Pursuing Real-Time Capabilities
lycorptech_jp
PRO
4
230
AI導入の理想と現実~コストと浸透〜
oprstchn
0
190
Core Audio tapを使ったリアルタイム音声処理のお話
yuta0306
0
180
Operating Operator
shhnjk
1
470
AI専用のリンターを作る #yumemi_patch
bengo4com
5
4k
Featured
See All Featured
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
29
9.5k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
229
22k
Making the Leap to Tech Lead
cromwellryan
134
9.4k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
8
680
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
181
53k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
35
2.4k
Visualization
eitanlees
146
16k
RailsConf 2023
tenderlove
30
1.1k
Building an army of robots
kneath
306
45k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
161
15k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.7k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
281
13k
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ແཧ͠ͳ͍
͋Γ͕ͱ͏͍͟͝·ͨ͠