Upgrade to Pro — share decks privately, control downloads, hide ads and more …

400万個のユーザー画像をサーバー移設した話

hypermkt
July 21, 2016

 400万個のユーザー画像をサーバー移設した話

400万個のユーザー画像をサーバー移設した話
PHP BLT #5
https://phpblt.connpass.com/event/35070/

hypermkt

July 21, 2016
Tweet

More Decks by hypermkt

Other Decks in Technology

Transcript

  1. όʔνʔ(.01&1"#0JOD
    1)1#-5
    ສݸͷϢʔβʔը૾Λ
    αʔόʔҠઃͨ͠࿩

    View Slide

  2. 1)1FSͷ
    όʔνʔͰ͢

    View Slide

  3. ϗʔϜϖʔδ࡞੒αʔϏεʮάʔϖʯ

    View Slide

  4. ࣄͷൃ୺

    View Slide

  5. ͦΖͦΖΦϯϓϨϛεͷαʔόʔͷ
    ࿝ٺԽ͕ݶքͩʂ

    View Slide

  6. ͦ
    ͏
    ͩ
    Ҡ

    ͠
    Α
    ͏

    View Slide

  7. ౰࣌ͷঢ়گ

    View Slide

  8. ɾը૾αʔόʔͷ༰ྔ͕ͦΖͦΖݶք
    ɾ୯ମͰҠઃͰ͖Δ
    ɾ͕͔͔࣌ؒΓͦ͏ͳͷͰ·ͣઌʹ

    View Slide

  9. ౰࣌ͷը૾؅ཧ
    "QBDIF1FSMCBM
    %# ը૾αʔόʔ
    wը૾਺໿ສݸ(#
    wϢʔβʔ͞Μ͕Ξοϓϩʔυͨ͠
    ϗʔϜϖʔδ༻ͷը૾
    w.PHJMF'4 ෼ࢄϑΝΠϧετϨʔ
    δ
    Ͱը૾؅ཧ

    View Slide

  10. ΞϓϦέʔγϣϯঢ়ଶ
    wେ෦෼͸1)1ͷಠࣗϑϨʔϜϫʔΫ
    wը૾Ξοϓϩʔυɾ࡟আϩδοΫ͸໿Օॴʹ෼ࢄ
    wؔ਺ͷίϐϖɾɾɾ
    w࣮૷ͷࠩҟ΋༗Γ
    wϑϨʔϜϫʔΫແ͠
    wϢχοτςετແ͠
    w΄ΜͷҰ෦͚ͩ3BJMTΛ"1*ͱͯ͠ར༻

    View Slide

  11. ը૾ͷҠߦઌ
    wࣾ಺༻ΦϒδΣΫτετϨʔδ
    w4ޓ׵"1*༗Γ
    IUUQXXXTMJEFTIBSFOFUMBNBOPUSBNBNPHJMFGTQSJWBUFT

    View Slide

  12. ΰʔϧ

    View Slide

  13. ΰʔϧ
    wຊ֨తͳશαʔόʔͷҠઃ࡞ۀΛ࢝ΊΔલʹɺը૾αʔόʔ୯ମͰҠઃ͍ͨ͠
    w͓٬༷ͷϗʔϜϖʔδ͸ఀࢭͤͣɺϊʔϝϯςͰҠߦ͍ͨ͠

    View Slide

  14. ܭը

    View Slide

  15. ͓͓·͔ʹݴ͏ͱ

    View Slide

  16. Ξοϓϩʔυ
    ࡟আ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    ᶃҠߦઌΛ༻ҙ

    View Slide

  17. Ξοϓϩʔυ
    ࡟আ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    ᶄಉظΛऔΔ

    View Slide

  18. Ξοϓϩʔυ
    ࡟আ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    ᶅ੾Γସ͑Δ

    View Slide

  19. ۩ମతʹ͸

    View Slide

  20. ࡞ઓ
    ɹը૾Ξοϓϩʔυɾ࡟আϩδοΫΛू໿
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    ɹطଘը૾ΛҠߦ͢Δ
    ɹࠩ෼νΣοΫπʔϧͰ࿙ΕΛνΣοΫ
    ɹը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦઌͷΈʹ͢Δ

    View Slide

  21. ɹը૾Ξοϓϩʔυɾ࡟আϩδοΫΛू໿
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    ɹطଘը૾ΛҠߦ͢Δ
    ɹࠩ෼νΣοΫπʔϧͰ࿙ΕΛνΣοΫ
    ɹը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦઌͷΈʹ͢Δ

    View Slide

  22. ը૾Ξοϓϩʔυɾ࡟আϩδοΫΛू໿
    w஍ಓʹϦϑΝΫλϦϯά໿ճ
    wϢχοτςετΛಋೖ
    wϲ݄͔͔ͬͨ
    wطଘ࢓༷Λ೺Ѳ͢Δͷ͕େม
    w్தͰ๞͖΋

    View Slide

  23. ΫϥεਤετϥςδʔύλʔϯΛ࠾༻

    View Slide

  24. ɹը૾Ξοϓϩʔυɾ࡟আϩδοΫΛू໿
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    ɹطଘը૾ΛҠߦ͢Δ
    ɹࠩ෼νΣοΫπʔϧͰ࿙ΕΛνΣοΫ
    ɹը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦઌͷΈʹ͢Δ

    View Slide

  25. ը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    Ξοϓϩʔυ
    ࡟আ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU

    View Slide

  26. ը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    Ξοϓϩʔυ
    ࡟আ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    ͪΐͬͱͣͭҠߦઌʹը૾͕૿͍͑ͯ͘

    View Slide

  27. ɹը૾Ξοϓϩʔυɾ࡟আϩδοΫΛू໿
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    ɹطଘը૾ΛҠߦ͢Δ
    ɹࠩ෼νΣοΫπʔϧͰ࿙ΕΛνΣοΫ
    ɹը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦઌͷΈʹ͢Δ

    View Slide

  28. طଘը૾ΛҠߦ͢Δ
    Ξοϓϩʔυ
    ࡟আ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    wࢼߦࡨޡ͠ͳ͕Β

    ̎ि͔͚ؒͯҠߦ
    w࣮࣭͸਺೔ͰҠߦͰ͖
    ͨͷ͕ͩௐ੔ʹ͕࣌ؒ
    ͔͔ͬͨɻ
    ฒྻॲཧͰҠߦ͢ΔεΫϦϓτΛ࣮૷ɻ໰୊ى͖·͘ΓͰେมͰͨ͠ɾɾɾɻ

    View Slide

  29. Ҡߦ࣌ʹۤ࿑ͨ͠ॴ
    w࣮ߦ଎౓͕஗͍
    wαʔόʔͷϝϞϦ௒ա
    wը૾ͷҠߦ࿙Εʢ࢓༷೺Ѳ࿙Εʣ
    wશ͘૝ఆ֎ͷϑΝΠϧ໊
    wͲ͏΍ͬͯόϦσʔγϣϯΛ͢Γൈ͚ͨΜͩʁʁ

    View Slide

  30. ɹը૾Ξοϓϩʔυɾ࡟আϩδοΫΛू໿
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    ɹطଘը૾ΛҠߦ͢Δ
    ɹࠩ෼νΣοΫπʔϧͰ࿙ΕΛνΣοΫ
    ɹը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦઌͷΈʹ͢Δ

    View Slide

  31. ࠩ෼νΣοΫπʔϧͰ࿙ΕΛνΣοΫ
    wࠩ෼νΣοΫπʔϧΛ࣮૷
    wҠߦݩΛج४ʹҠߦઌʹը૾͕͋Δ͔νΣοΫ
    wϑΝΠϧͷ༗Γແ͠
    w༰ྔ
    w΋͠Ҡߦઌʹແ͚Ε͹଍Γͳ͍෼ΛΞοϓϩʔ
    υ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    Ұக͍ͯ͠Δ͔ʁ

    View Slide

  32. ɹը૾Ξοϓϩʔυɾ࡟আϩδοΫΛू໿
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    ɹطଘը૾ΛҠߦ͢Δ
    ɹࠩ෼νΣοΫπʔϧͰ࿙ΕΛνΣοΫ
    ɹը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦઌͷΈʹ͢Δ

    View Slide

  33. ը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    ͓٬༷ͷϗʔϜϖʔδ
    ϗʔϜϖʔδ಺ͷΞοϓϩʔυը૾͸
    چ؀ڥΛࢀর͍ͯ͠Δ

    View Slide

  34. ը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    wը૾63-͸%#Ͱ؅ཧ
    wόονॲཧͰঃʑʹൣғΛ޿͛ͯ੾Γସ͑Δɻ൒೔ɻ
    ϗʔϜϖʔδ಺ͷΞοϓϩʔυը૾Λ
    ৽؀ڥʹ੾Γସ͑Δ

    View Slide

  35. ɹը૾Ξοϓϩʔυɾ࡟আϩδοΫΛू໿
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦݩɾઌ྆ํʹ͢Δ
    ɹطଘը૾ΛҠߦ͢Δ
    ɹࠩ෼νΣοΫπʔϧͰ࿙ΕΛνΣοΫ
    ɹը૾63-Λஈ֊తʹҠߦઌʹ੾Γସ͑Δ
    ɹը૾ͷΞοϓϩʔυɾ࡟আΛҠߦઌͷΈʹ͢Δ

    View Slide

  36. ৽نϢʔβʔͷը૾ૢ࡞ΛҠߦઌͷΈར༻ʹ͢Δ
    طଘϢʔβʔ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    ৽نϢʔβʔ

    View Slide

  37. ৽نϢʔβʔͷը૾ૢ࡞ΛҠߦઌͷΈར༻ʹ͢Δ
    طଘϢʔβʔ
    Ҡߦݩ
    .PHJMF'4
    Ҡߦઌ
    #BZU
    ৽نϢʔβʔ

    View Slide

  38. ͜ΕΒͷҠߦ࡞ۀʹΑΓ
    ϊʔϝϯςͰը૾αʔόʔͷҠߦ͕ग़དྷͨ

    View Slide

  39. ·ͱΊ

    View Slide

  40. ·ͱΊ
    wαʔόʔҠઃ͸طଘ࢓༷ΛҰؾʹ೺Ѳ͢Δνϟϯε
    wϢχοτςετͷಋೖͱಉ࣌ʹϦϑΝΫλϦϯά΋ଟ਺Ͱ͖ͨ
    wେมͳ࡞ۀͰ͸͋Δ͕ٕज़తͳνϟϨϯδ߲໨͕ଟ਺͋Γ΍Γ
    ͕͍΋͋ͬͨ

    View Slide