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.5k
数十億レコードのRDS MySQL5.6を1週間程でAurora MySQL5.7へ移行した時の話 #jawsdays
ekanai
February 23, 2019
Tweet
Share
More Decks by ekanai
See All by ekanai
TimeTree のデータベースを Aurora から Cloud Spanner へ移行
3utama
1
210
[TimeTree] Aurora から Spanner への 移行の決断と背景
3utama
2
3.7k
TimeTree の SRE が海外展開においてやったこと&やってないこと by【TimeTree × みてね勉強会】 グローバル対応への挑戦 〜SRE/インフラ編〜
3utama
1
480
1日でSSHをやめることができた話 #jawsdays
3utama
10
17k
Other Decks in Technology
See All in Technology
[OpsJAWS Meetup33 AIOps] Amazon Bedrockガードレールで守る安全なAI運用
akiratameto
1
140
エンジニアのキャリアパスと、 その中で自分が大切にしていること
noteinc
3
310
職位にかかわらず全員がリーダーシップを発揮するチーム作り / Building a team where everyone can demonstrate leadership, regardless of position
madoxten
18
9.1k
20250304_赤煉瓦倉庫_DeepSeek_Deep_Dive
hiouchiy
2
130
AIエージェント元年@日本生成AIユーザ会
shukob
1
260
MIMEと文字コードの闇
hirachan
2
1.5k
LINE NEWSにおけるバックエンド開発
lycorptech_jp
PRO
0
390
ExaDB-XSで利用されているExadata Exascaleについて
oracle4engineer
PRO
3
300
開発者のための FinOps/FinOps for Engineers
oracle4engineer
PRO
2
260
User Story Mapping + Inclusive Team
kawaguti
PRO
3
470
Amazon Athenaから利用時のGlueのIcebergテーブルのメンテナンスについて
nayuts
0
120
【5分でわかる】セーフィー エンジニア向け会社紹介
safie_recruit
0
19k
Featured
See All Featured
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
11
1.3k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
100
18k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
280
13k
Fireside Chat
paigeccino
35
3.2k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
666
120k
What's in a price? How to price your products and services
michaelherold
244
12k
Side Projects
sachag
452
42k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
13
1k
The Language of Interfaces
destraynor
156
24k
A Tale of Four Properties
chriscoyier
158
23k
Reflections from 52 weeks, 52 projects
jeffersonlam
348
20k
Rails Girls Zürich Keynote
gr2m
94
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ແཧ͠ͳ͍
͋Γ͕ͱ͏͍͟͝·ͨ͠