数十億レコードのRDS MySQL5.6を1週間程でAurora MySQL5.7へ移行した時の話 #jawsdays

by ekanai

Slide 1

Slide 1 text

਺ेԯϨίʔυͷ3%4.Z42-Λ िؒఔͰ"VSPSB.Z42-΁Ҡ ߦͨ࣌͠ͷ࿩ KBXTEBZT

Slide 2

Slide 2 text

ࣗݾ঺հ

Slide 3

Slide 3 text

ۚҪӫت ,BOBJ&JLJ גࣜձࣾ+6#*-&&803,4

Slide 4

Slide 4 text

T i m e T r e e ΧϨϯμʔγΣΞαʔϏε

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

ʮڵຯɺؔ৺͕͋Δʯ Ͱ͸ऴΘΒͤͳ͍ɻ TimeTree͸޿ࠂ΋ίϯςϯπͷ1ͭͱͯ͠ଊ͑ ͍ͯΔͨΊɺ޿ࠂΛద੾ͳϢʔβʔʹద੾ͳ λΠϛϯάͰ഑৴͢Δ͜ͱͰɺϢʔβʔɺ޿ ࠂओͱ΋ʹՁ஋ͷ͋ΔϚονϯάϓϥοτ ϑΥʔϜͰ͋Γ͍ͨͱߟ͍͑ͯ·͢ɻ

Slide 7

Slide 7 text

ຊ୊

Slide 8

Slide 8 text

wҠߦ಺༰ w"84%.4Ͱେࣦഊ w࠶ܭը wͦͯ͠Ҡߦ׬ྃ΁

Slide 9

Slide 9 text

㾎Ҡߦ಺༰ w "84%.4Ͱେࣦഊ w ࠶ܭը w ͦͯ͠Ҡߦ׬ྃ΁

Slide 10

Slide 10 text

w3%4.Z42-"VSPSB.Z42- w̎ͭͷεΩʔϚ౷߹ w૯Ϩίʔυ͕਺ेԯʢ໿dԯϨίʔυ͋Δςʔϒ ϧ͕ෳ਺ଘࡏʣΛશͯҠߦ Ҡߦ಺༰

Slide 11

Slide 11 text

w Ҡߦ಺༰ w"84%.4Ͱେࣦഊ w ࠶ܭը w ͦͯ͠Ҡߦ׬ྃ΁

Slide 12

Slide 12 text

w4BOECPY w୯७ͳҠߦ֬ೝͱςετ w1SPEVDUJPO w1SPEVDUJPOͷσʔλΛར༻ͨ͠Ϧϋͱςετ w࠷ऴҠߦ "84%.4Ͱେࣦഊ Ҡߦܭը

Slide 13

Slide 13 text

w%.4 Ҡߦํ๏ ࠶ܭը

Slide 14

Slide 14 text

"84%.4Ͱେࣦഊ 4BOECPY εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- Τϥʔͳ͔ͬ ͨͰ Αͬ͠Ό

Slide 15

Slide 15 text

"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- શવऴΘΒΜ ͳΜ΍ͯ

Slide 16

Slide 16 text

"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- αϒλεΫ ΠϯσοΫεແޮ ίϛοτϨʔτ

Slide 17

Slide 17 text

"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- Τϥʔ΍ ͳΜ΍ͯ

Slide 18

Slide 18 text

"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42-

Slide 19

Slide 19 text

"84%.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ ͝ΊΜͯ

Slide 20

Slide 20 text

wυΩϡϝϯτ͸ͪΌΜͱಡ΋͏ "84%.4Ͱେࣦഊ ڭ܇

Slide 21

Slide 21 text

"84%.4Ͱେࣦഊ

Slide 22

Slide 22 text

w Ҡߦ಺༰ w "84%.4Ͱେࣦഊ w࠶ܭը w ͦͯ͠Ҡߦ׬ྃ΁

Slide 23

Slide 23 text

w4BOECPY wσʔλछྨΛ༻ҙ w1SPEVDUJPO w1SPEVDUJPOͷσʔλΛར༻ͨ͠Ϧϋͱςετ w࠷ऴҠߦ ࠶ܭը Ҡߦܭըʢ৽ʣ

Slide 24

Slide 24 text

wNZTRMEVNQ Ҡߦํ๏ ࠶ܭը

Slide 25

Slide 25 text

w%#ߏ੒͚ͩNZTRMEVNQ wσʔλ͸4&-&$5 w4&-&$5݁ՌΛTQMJU w-0"%%"5"*/'*-& wҠߦલޙͷݕࡧ݁ՌΛ%*'' Ҡߦํ๏ ࠶ܭը

Slide 26

Slide 26 text

w Ҡߦ಺༰ w "84%.4Ͱେࣦഊ w ࢼߦࡨޡ wͦͯ͠Ҡߦ׬ྃ΁

Slide 27

Slide 27 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica

Slide 28

Slide 28 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica ❌

Slide 29

Slide 29 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica ❌ %#ߏ੒ΛEVNQ

Slide 30

Slide 30 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica ❌ શ݅4&-&$5 HPPGZT

Slide 31

Slide 31 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica ❌ TQMJUͯ͠4 HPPGZT

Slide 32

Slide 32 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica ❌ -0"%%"5" */'*-& HPPGZT

Slide 33

Slide 33 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica ❌ HPPGZT શ݅4&-&$5

Slide 34

Slide 34 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica ❌ HPPGZT EJ⒎

Slide 35

Slide 35 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica HPPGZT ϨϓϦέʔγϣϯ ࠶։

Slide 36

Slide 36 text

ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4.Z42- "VSPSB.Z42- DB on Instance .Z42- PO &$ DB Instance DB instance read replica

Slide 37

Slide 37 text

1SPEVDUJPOʢpOBMʣ 3%4.Z42- "VSPSB.Z42- DB Instance ੾Γସ͑ ͦͯ͠Ҡߦ׬ྃ΁

Slide 38

Slide 38 text

·ͱΊ

Slide 39

Slide 39 text

wυΩϡϝϯτ͸ͪΌΜͱಡ΋͏ wΠϯϙʔτ݅਺͕ϙΠϯτ wҠߦ࣌ͷϦιʔεαΠζ͸ένΒͣʹ wແཧ͸͠ͳ͍

Slide 40

Slide 40 text

͋Γ͕ͱ͏͍͟͝·ͨ͠