$30 off During Our Annual Pro Sale. View details »

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

ekanai
February 23, 2019

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

ekanai

February 23, 2019
Tweet

More Decks by ekanai

Other Decks in Technology

Transcript

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

  2. ࣗݾ঺հ

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

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

  5. None
  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. ͋Γ͕ͱ͏͍͟͝·ͨ͠