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
2024春 注目のWeb系 OSS & SaaS 3選
makies
0
110
DMM.com アルファ室採用案内資料
hsugita
1
170
ワールドカフェI /チューターを改良する / World Café I and Improving the Tutors
ks91
PRO
0
130
Python と Snowflake はズッ友だょ!~ Snowflake の Python 関連機能をふりかえる ~
__allllllllez__
2
130
require(ESM)とECMAScript仕様
uhyo
4
860
エンジニアのキャリアをちょっと楽しくする3本の軸/Three Pillars to Make an Engineer's Career More Enjoyable
kwappa
0
2.8k
よく聞くけど使ったことないソフトウェアNo.1 KafkaとSnowflake
foursue
4
370
GrafanaMeetup_AmazonManagedGrafanaのアクセス制御機能とマルチテナント環境下でのアクセス制御について
daitak
0
320
プラットフォームってつくることより計測することが重要なんじゃないかという話 / Platform Engineering Meetup #8
taishin
1
380
Reducing Cross-Zone Egress at Spotify with Custom gRPC Load Balancing Recap
koh_naga
0
210
Além do else! Categorizando Pokemóns com Pattern Matching no JavaScript
wmsbill
0
660
Azureの基本的な権限管理の勉強会
yhana
1
1.3k
Featured
See All Featured
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
221
21k
A designer walks into a library…
pauljervisheath
200
23k
Art, The Web, and Tiny UX
lynnandtonic
289
19k
Pencils Down: Stop Designing & Start Developing
hursman
117
11k
For a Future-Friendly Web
brad_frost
172
9k
Web development in the modern age
philhawksworth
202
10k
10 Git Anti Patterns You Should be Aware of
lemiorhan
648
58k
Six Lessons from altMBA
skipperchong
21
3k
Unsuck your backbone
ammeep
663
57k
Why You Should Never Use an ORM
jnunemaker
PRO
51
8.6k
Creatively Recalculating Your Daily Design Routine
revolveconf
210
11k
Thoughts on Productivity
jonyablonski
58
3.8k
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ແཧ͠ͳ͍
͋Γ͕ͱ͏͍͟͝·ͨ͠