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

Transcript

1. ਺ेԯϨίʔυͷ3%4
   .Z42-Λ िؒఔͰ"VSPSB
   .Z42-΁Ҡ ߦͨ࣌͠ͷ࿩ KBXTEBZT
   
2. ࣗݾ঺հ
3. ۚҪ
   ӫت ,BOBJ
   &JLJ גࣜձࣾ+6#*-&&
   803,4
4. T i m e T r e e ΧϨϯμʔγΣΞαʔϏε
6. ʮڵຯɺؔ৺͕͋Δʯ Ͱ͸ऴΘΒͤͳ͍ɻ TimeTree͸޿ࠂ΋ίϯςϯπͷ1ͭͱͯ͠ଊ͑ ͍ͯΔͨΊɺ޿ࠂΛద੾ͳϢʔβʔʹద੾ͳ λΠϛϯάͰ഑৴͢Δ͜ͱͰɺϢʔβʔɺ޿ ࠂओͱ΋ʹՁ஋ͷ͋ΔϚονϯάϓϥοτ ϑΥʔϜͰ͋Γ͍ͨͱߟ͍͑ͯ·͢ɻ
7. ຊ୊
8. wҠߦ಺༰
   w"84
   %.4Ͱେࣦഊ
   w࠶ܭը
   wͦͯ͠Ҡߦ׬ྃ΁
9. 㾎Ҡߦ಺༰
   w "84
   %.4Ͱେࣦഊ
   w ࠶ܭը
   w ͦͯ͠Ҡߦ׬ྃ΁
10. w3%4
    .Z42-
    
    
    "VSPSB
    .Z42-
    
    w̎ͭͷεΩʔϚ౷߹
    w૯Ϩίʔυ͕਺ेԯʢ໿dԯϨίʔυ͋Δςʔϒ ϧ͕ෳ਺ଘࡏʣΛશͯҠߦ Ҡߦ಺༰
11. w Ҡߦ಺༰
    w"84
    %.4Ͱେࣦഊ
    w ࠶ܭը
    w ͦͯ͠Ҡߦ׬ྃ΁
12. w4BOECPY
    w୯७ͳҠߦ֬ೝͱςετ
    w1SPEVDUJPO
    w1SPEVDUJPOͷσʔλΛར༻ͨ͠Ϧϋͱςετ
    w࠷ऴҠߦ "84
    %.4Ͱେࣦഊ Ҡߦܭը
13. w%.4 Ҡߦํ๏ ࠶ܭը
14. "84
    %.4Ͱେࣦഊ 4BOECPY εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- Τϥʔͳ͔ͬ ͨͰ Αͬ͠Ό
15. "84
    %.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- શવऴΘΒΜ ͳΜ΍ͯ
16. "84
    %.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- αϒλεΫ ΠϯσοΫεແޮ ίϛοτϨʔτ
17. "84
    %.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- Τϥʔ΍ ͳΜ΍ͯ
18. "84
    %.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42-
19. "84
    %.4Ͱେࣦഊ 1SPEVDUJPOʢQIBTFʣ ͝ΊΜͯ
20. wυΩϡϝϯτ͸ͪΌΜͱಡ΋͏ "84
    %.4Ͱେࣦഊ ڭ܇
21. "84
    %.4Ͱେࣦഊ
22. w Ҡߦ಺༰
    w "84
    %.4Ͱେࣦഊ
    w࠶ܭը
    w ͦͯ͠Ҡߦ׬ྃ΁
23. w4BOECPY
    wσʔλछྨΛ༻ҙ
    w1SPEVDUJPO
    w1SPEVDUJPOͷσʔλΛར༻ͨ͠Ϧϋͱςετ
    w࠷ऴҠߦ ࠶ܭը Ҡߦܭըʢ৽ʣ
24. wNZTRMEVNQ Ҡߦํ๏ ࠶ܭը
25. w%#ߏ੒͚ͩNZTRMEVNQ
    wσʔλ͸4&-&$5
    w4&-&$5݁ՌΛTQMJU
    w-0"%
    %"5"
    */'*-&
    wҠߦલޙͷݕࡧ݁ՌΛ%*'' Ҡߦํ๏ ࠶ܭը
26. w Ҡߦ಺༰
    w "84
    %.4Ͱେࣦഊ
    w ࢼߦࡨޡ
    wͦͯ͠Ҡߦ׬ྃ΁
27. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica   
28. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica ❌
29. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica ❌ %#ߏ੒ΛEVNQ
30. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica ❌ શ݅4&-&$5 HPPGZT
31. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica ❌ TQMJUͯ͠4 HPPGZT
32. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica ❌ -0"%
    %"5"
    */'*-& HPPGZT
33. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica ❌ HPPGZT શ݅4&-&$5
34. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica ❌ HPPGZT EJ⒎
35. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica HPPGZT ϨϓϦέʔγϣϯ ࠶։
36. ͦͯ͠Ҡߦ׬ྃ΁ 1SPEVDUJPOʢpOBMʣ εΩʔϚ" εΩʔϚ# εΩʔϚ" 3%4
    .Z42- "VSPSB
    .Z42- DB on Instance .Z42-
    PO
    &$
    DB Instance DB instance read replica   
37. 1SPEVDUJPOʢpOBMʣ 3%4
    .Z42- "VSPSB
    .Z42- DB Instance ੾Γସ͑ ͦͯ͠Ҡߦ׬ྃ΁
38. ·ͱΊ
39. wυΩϡϝϯτ͸ͪΌΜͱಡ΋͏
    wΠϯϙʔτ݅਺͕ϙΠϯτ
    wҠߦ࣌ͷϦιʔεαΠζ͸ένΒͣʹ
    wແཧ͸͠ͳ͍
40. ͋Γ͕ͱ͏͍͟͝·ͨ͠