急成長するマルチテナント SaaSの技術戦略を支えるAWS / X-Tech JAWS 2

急成長するマルチテナントSaaSの技術戦略を支えるAWS
X-Tech JAWS #2 9割のX-Techと1割の優しさで切り拓く未来
SmartHR ソフトウェアエンジニア ぷりんたい

Transcript

1. 95FDI+"84dׂͷ95FDIͱׂͷ༏͠͞Ͱ੾Γ୓͘ະདྷd
   ٸ੒௕͢ΔϚϧνςφϯτ
   4BB4ͷٕज़ઓུΛࢧ͑Δ"84
   8FE
   ΀ΓΜ͍ͨ
   ιϑτ΢ΣΞΤϯδχΞ
   

   View Slide

2. CONFIDENTIAL
   αʔϏε֓ཁ
   4NBSU)3ͷ͝঺հ
   

   View Slide

3. CONFIDENTIAL
   4NBSU)3͸
   ਓࣄɾ࿑຿ͷखଓ͖ΛΧϯλϯʹ͢Δ
   Ϋϥ΢υܕιϑτ΢ΣΞͰ͢ɻ
   4NBSU)3ͱ͸
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔˔˔˔˔
   WWW
   

   View Slide

4. 
   4
   Copyright © 2015 KUFU, Inc. All Rights Reserved
   ࿑຿͸ΞφϩάͰϝϯυ΢
   

   View Slide

5. ೉ղͳॻྨͷࢁ
   

   View Slide

6. ໾ॴʹߦ͖ͨ͘ͳ͍
   

   View Slide

7. CONFIDENTIAL
   ࣾอɾޏอॻྨΛ
   ࣗಈ࡞੒
   ैۀһ৘ใΛ
   σʔλϕʔεԽ
   ࡞੒ͨ͠ॻྨΛ
   8FC͔Βਃ੥
   ਓࣄ৘ใΛ
   Χϯλϯʹऩू
   4NBSU)3ͱ͸
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   ˔˔˔˔
   ˔˔˔˔˔˔˔˔
   

   View Slide

8. CONFIDENTIAL
   ैۀһ͕ʮ͸͍ʯ
   ɾ
   ʮ͍͍͑ʯͷΧϯλϯͳ࣭໰ʹ౴͑Δ͚ͩͰ
   ਃࠂॻྨ͕׬੒͠·͢ɻ΍΍͍͜͠ॻྨΛखॻ͖͢Δඞཁ͕ͳ͘ͳΔͷͰɺ
   ؅ཧऀ͸ɺॻ͖࿙Εɾॻ͖ؒҧ͍ʹΑΔमਖ਼ίετΛେ෯ʹ࡟ݮͰ͖·͢ɻ
   σʔλ͸ϑΝΠϧͰΤΫεϙʔτ΋ՄೳͰɺ൥ࡶͳσʔλԽ࡞ۀ΋ෆཁʹʂ
   εϚϗͰαΫαΫͰ͖Δʂ
   ϖʔύʔϨε೥຤ௐ੔
   ͍͍͑
   4NBSU)3ʹొ࿥͞Ε͍ͯΔॅॴ
   ˟
   ౦ژ౎ߓ۠ຑ෍୆
   දࣔ͞Ε͍ͯΔॅॴ͸
   ॅຽථॅॴͱಉ͡Ͱ͔͢ʁ
   ͸͍
   ಋೖϝϦοτ
   

   View Slide

9. CONFIDENTIAL
   ಋೖاۀ༷
   ͝ར༻͍͚ͨͩΔैۀһ਺͸
   ໊ʙ ໊ن໛·Ͱ
   

   View Slide

10. CONFIDENTIAL
    
    
    
    
    
    
    
    
    
    
    ݄
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    ࣾ
    ˞ ࣌఺
    Ϣʔβʔاۀ਺ɾࢢ৔γΣΞ
    ܧଓར཰
    
    

    View Slide

11. CONFIDENTIAL
    αʔϏε֓ཁ
    αʔϏε঺հ͜͜·Ͱ
    

    View Slide

12. ։ൃऀ͔Βݟͨ
    4NBSU)3ͱ͍͏ΞϓϦͷಛੑ
    

    View Slide

13. 
    13
    େྔͷΞΫηε͞͹͖·ͤΜ
    

    View Slide

14. 
    14
    ϛογϣϯΫϦςΟΧϧͰ΋͋Γ·ͤΜ
    ʢ͍·ͷͱ͜Ζ͸)
    

    View Slide

15. 
    15
    શը໘ͷׂ͕̔ϑΥʔϜ
    

    View Slide

16. 
    16
    ػೳվमʹALTER TABLE
    

    View Slide

17. 
    17
    Ϣʔβຖʹઐ༻ͷDB
    

    View Slide

18. 
    
    
    
    
    
    
    
    
    
    ݄
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    ݸͷσʔλϕʔε
    

    View Slide

19. ౰વɺ3%4ΠϯελϯεΛ
    ୆ཱ͍ͯͯΔ༁Ͱ͸͋Γ·ͤΜ
    ɹ
    

    View Slide

20. ୆ͷ3%4Πϯελϯεͷதʹ
    ݸͷσʔλϕʔε͕͋Γ·͢
    ʢ΍͹͍ʣ
    

    View Slide

21. ͜ͷΑ͏ͳɺಛఆͷϦιʔεΛ
    ෳ਺ͷ૊৫ ʹςφϯτ
    Ͱڞ༗͢Δ
    Α͏ͳઃܭͷ͜ͱΛ
    ʮϚϧνςφϯτΞʔΩςΫνϟʯ
    ͱݺͼ·͢ɻ
    

    View Slide

22. Ϛϧνςφϯτͳ΢ΣϒΞϓϦέʔγϣϯͷྫ
    ˡɹɹϚϧνςφϯτ ϚϧνςφϯτͰ͸ͳ͍ɹɹˠ
    

    View Slide

23. Ϛϧνςφϯτͷઆ໌
    ʢ·ͨ͸ɺϚϧνςφϯγʔʣ
    

    View Slide

24. ̍ͭͷγεςϜΛෳ਺ͷςφϯτͰ
    ڞ༗͢ΔΞϓϦέʔγϣϯͷܗଶ
    

    View Slide

25. ςφϯτͱ͸ɺ૊৫ͷ୯Ґ
    ʢνʔϜɾاۀɾஂମͳͲʣ
    

    View Slide

26. ݫີͳఆٛ͸ͳ͘ᐆດͰ͕͢ɺ
    ݸਓతͳݟղͱͯ͠͸શͯͷσʔλ͕
    ςφϯτʹඥ͔ͮ͘Ͳ͏͔͕෼ਫྮ
    

    View Slide

27. Θ͔Γ΍͘͢ݴ͏ͱ
    ϢʔβΛফͯ͠΋σʔλ͕ফ͑ͳ͍
    

    View Slide

28. Ϛϧνςφϯγʔͷ
    ໨తͱύλʔϯ
    

    View Slide

29. Ϛϧνςφϯγʔͷ໨త͸
    ϦιʔεΛڞ༗͢Δ͜ͱͰ
    αʔϏεͷఏڙίετΛ཈͑Δ͜ͱ
    

    View Slide

30. Ҿ༻ݩ.VMUJUFOBOU4BB4EBUBCBTFUFOBODZQBUUFSOT"[VSF42-%BUBCBTFc.JDSPTPGU%PDT
    IUUQTEPDTNJDSPTPGUDPNFOVTB[VSFTRMEBUBCBTFTBBTUFOBODZBQQEFTJHOQBUUFSOT
    Ϛϧνςφϯγʔͷύλʔϯྫ
    ΞϓϦέʔγϣϯϨϕϧͷ෼཭
    ʢϚϧνςφϯτͰ͸ͳ͍ʣ
    ςφϯτ୯ҐͰಠཱͨ͠
    ΞϓϦ%#ΠϯελϯεΛఏڙɻ
    

    View Slide

31. Ҿ༻ݩ.VMUJUFOBOU4BB4EBUBCBTFUFOBODZQBUUFSOT"[VSF42-%BUBCBTFc.JDSPTPGU%PDT
    IUUQTEPDTNJDSPTPGUDPNFOVTB[VSFTRMEBUBCBTFTBBTUFOBODZBQQEFTJHOQBUUFSOT
    Ϛϧνςφϯγʔͷύλʔϯྫ
    ΞϓϦέʔγϣϯͷڞ༗
    ΞϓϦέʔγϣϯ͸ڞ༗͢Δ͕ɺ
    %#Πϯελϯε͸ಠཱ͍ͯ͠Δɻ
    

    View Slide

32. Ҿ༻ݩ.VMUJUFOBOU4BB4EBUBCBTFUFOBODZQBUUFSOT"[VSF42-%BUBCBTFc.JDSPTPGU%PDT
    IUUQTEPDTNJDSPTPGUDPNFOVTB[VSFTRMEBUBCBTFTBBTUFOBODZBQQEFTJHOQBUUFSOT
    Ϛϧνςφϯγʔͷύλʔϯྫ
    %#Πϯελϯεͷڞ༗
    %#Πϯελϯε্Ͱςφϯτຖʹ
    σʔλϕʔεΛ࡞੒͢Δɻ
    

    View Slide

33. Ҿ༻ݩ.VMUJUFOBOU4BB4EBUBCBTFUFOBODZQBUUFSOT"[VSF42-%BUBCBTFc.JDSPTPGU%PDT
    IUUQTEPDTNJDSPTPGUDPNFOVTB[VSFTRMEBUBCBTFTBBTUFOBODZBQQEFTJHOQBUUFSOT
    Ϛϧνςφϯγʔͷύλʔϯྫ
    σʔλϕʔεͷڞ༗
    ֤ςʔϒϧʹςφϯτΛࣝผ͢Δ
    ΧϥϜΛ௥Ճ͢Δɻଞςφϯτͱσʔ
    λϕʔεΛڞ༗͢Δɻ
    

    View Slide

34. Ҿ༻ݩ.VMUJUFOBOU4BB4EBUBCBTFUFOBODZQBUUFSOT"[VSF42-%BUBCBTFc.JDSPTPGU%PDT
    IUUQTEPDTNJDSPTPGUDPNFOVTB[VSFTRMEBUBCBTFTBBTUFOBODZBQQEFTJHOQBUUFSOT
    Ϛϧνςφϯγʔͷύλʔϯྫ
    γϟʔσΟϯά
    ςφϯτࣝผࢠΛ׆༻ͯ͠γϟʔσΟ
    ϯάΛߦ͏ɻऩ༰ͷ؅ཧ͕େม͚ͩ
    ͲݸผͷσʔλϕʔεͷαΠζ͸খ
    ͘͞ͳΔɻ
    

    View Slide

35. ϚϧνςφϯτͷΉ͔ͣ͠͞
    

    View Slide

36. σʔλϕʔε͚ͩ޻෉͢Ε͹Α͍ʁ
    

    View Slide

37. ͱΜͰ΋ͳ͍
    

    View Slide

38. ϚϧνςφϯτΞʔΩςΫνϟ͸
    େྔͷҙࢥܾఆ͕ඞཁ
    

    View Slide

39. ΞΧ΢ϯτઃܭ
    ɾෳ਺ͷςφϯτʹϩάΠϯͰ͖Δʁ
    ɾςφϯτ͕ফ͞Εͨ࣌ΞΧ΢ϯτ͸ফࣦ͢Δ
    ɾΞΧ΢ϯτͷઃఆ͸ςφϯτ୯ҐͰ࣋ͭʁ
    ɾผͷςφϯτʹϩάΠϯ͢Δ࣌͸࠶ೝূෆཁʁ
    ɾςφϯτʹඥ෇͔ͳ͍ΞΧ΢ϯτ͸࡞ΕΔʁ
    

    View Slide

40. 63-ઃܭ
    ɾςφϯτͷ੾ସ͑͸αϒυϝΠϯͰߦ͏ʁQBUIʁ
    ɾςφϯτࣝผࢠ͸มߋͰ͖Δʁ
    ɾ࣋ͪࠐΈͷυϝΠϯΛׂ౰Ͱ͖Δʁ
    ɾTFTTJPODPPLJF͸ͲͷυϝΠϯʹ෇༩͢Δʁ
    ɾಈ࡞؀ڥ͸໨తͷϧʔςΟϯάํࣜʹରԠͯ͠Δʁ
    

    View Slide

41. σʔλϕʔεઃܭ
    ɾςφϯτͱσʔλϕʔεΛͲ͏ରԠͤ͞Δʁ
    ɾͲͷΑ͏ʹϚΠάϨʔγϣϯ͢Δʁ
    ɾͲͷΑ͏ʹόοΫΞοϓɾӡ༻͢Δʁ
    ɾઢܗతͳεέʔϧ͕༰қʹߦ͑Δ͔ʁ
    ɾকདྷతʹύλʔϯΛ੾Γସ͑Δ࣌ʹ໰୊ͳ͍͔ʁ
    

    View Slide

42. ετϨʔδઃܭ
    ɾ໊લۭؒΛͲͷΑ͏ʹ֬อ͢Δʁ
    ɾ໊લۭؒͷ࠶ར༻ʹ଱͑͏Δʁ
    ɾΞΫηε੍ޚ͸ʁ
    ɾଞςφϯτͱϦιʔεΛڞ༻͢Δʁ
    

    View Slide

43. ΞϓϦέʔγϣϯઃܭ
    ɾͲͷΑ͏ʹσʔλϕʔεΛ੾Γସ͑Δʁ
    ɾଞςφϯτͷσʔλ͸ݟ͑ͳ͍Α͏ʹͳ͍ͬͯΔʁ
    ɾσʔλϕʔε͕෼཭͞Ε͍ͯͳ͍৔߹ɺ
    ɹ҆શʹίʔυΛॻ͚Δઃܭʹͳ͍ͬͯΔʁ
    ɾ࣮ݱ͠Α͏ͱ͍ͯ͠Δ͜ͱ͕೉͗͢͠ͳ͍͔ʁ
    

    View Slide

44. Ϗδωεઃܭ
    ɾࠓޙͷࣄۀܭը͸ʁ
    ɾςφϯτ਺΍ར༻ن໛͸ͲͷΑ͏ʹ૿͑Δ͔ʁ
    ɾͲͷΑ͏ʹΞϓϦέʔγϣϯ͕มԽ͍͔ͯ͘͠ʁ
    ɾϢʔεέʔεͷ૿Ճ͸͋Δ͔ʁ
    ɾͦΕӡ༻ʹ৐Δʁ
    

    View Slide

45. ΞϓϦέʔγϣϯ͚ͩͰ͸
    ͳΜͱ΋ͳΒͳ͍
    

    View Slide

46. ϚϧνςφϯτΞʔΩςΫνϟ͸
    ෳ਺ͷ໰୊Λಉ࣌ʹղ͘ඞཁ͕͋Δ
    

    View Slide

47. Ϛϧνςφϯτ͸
    ෯޿͍஌ࣝɾࢹ఺΍༧஌ɾӡ༻ྗɺ
    ιϑτ΢ΣΞݕূೳྗΛཁٻ͞ΕΔ
    ΢ΣϒΞϓϦͷ૯߹ܳज़
    

    View Slide

48. ϚϧνςφϯτΞʔΩςΫνϟʹ
    ཱͪ޲͔͏࣌ͷ࠷ྑͷύʔτφʔ͸ʁ
    

    View Slide

49. ଟ͘ͷબ୒ࢶΛఏڙͯ͘͠ΕΔ΋ͷ
    

    View Slide

50. ٸ੒௕͢Δ4BB4ʹ͓͚Δ
    ΤϯδχΞͷ໾ׂͱ͸
    

    View Slide

51. ͋͘·ͰϢʔβ໨ઢͰ
    ྑ͍ϓϩμΫτΛ࡞Γଓ͚Δ͜ͱ
    

    View Slide

52. Ϗδωεͷ੒௕ʹ
    ٕज़ཁҼͰϒϨʔΩΛ͔͚ͳ͍͜ͱ
    

    View Slide

53. ૊৫ͷঢ়گʹԠͯ͡
    ࠷దͳٕज़બ୒Λ͍ͯ͘͜͠ͱ
    

    View Slide

54. Ͳ͜·Ͱ΋ݱঢ়Λ٬؍ࢹ͍ͯ͘͜͠ͱ
    

    View Slide

55. ϕϯνϟʔΒ͘͠๯ݥ΋͍͍͚Ͳɺ
    ӡ༻ʹ৐Δ͜ͱ͕࠷௿৚݅
    

    View Slide

56. 4NBSU)3ࣾͷঢ়گ
    

    View Slide

57. 4NBSU)3ͷैۀһ਺
    ೥݄࣌఺
    
    

    View Slide

58. 4NBSU)3ͷैۀһߏ੒
    ೥݄࣌఺
    
    

    View Slide

59. ɾΤϯδχΞ͸શମͷ
    ɾٕज़ελοΫ΋όϥόϥ
    ɾগਓ਺Ͱӡ༻Λ͠ͳ͍ͱ͍͚ͳ͍
    ɾࣗલӡ༻͸ͳΔ͚ͩݮΒ͍ͨ͠ʂ
    

    View Slide

60. 4BB4Χϯύχʔͱͯ͠ͷߟ͑ํ
    

    View Slide

61. 4NBSU)3ࣾ͸
    ۀքಛԽܕͷ4BB4Χϯύχʔ
    

    View Slide

62. ίΞͱͳΔՁ஋؍͸ɺ
    ੈͷதͷ໰୊Λ๻͕ͨͪ࣋ͭ
    ΑΓྑ͍ํ๏Ͱղܾ͢Δ͜ͱ
    

    View Slide

63. ͦΕͳΒ͹ɺ
    ๻ͨͪͷ໰୊΋ࣗ෼Ͱղܾ͢ΔΑΓ
    ྑ͍ํ๏͕͋ΔͳΒͲΜͲΜ׆༻
    

    View Slide

64. "84ͷϚωʔδυαʔϏε͸ศར
    

    View Slide

65. "84ͷϚωʔδυαʔϏε͸ศར
    Ͱ΋ɺͨ·ʹᙱ͍ॴʹख͕ಧ͔ͳ͍
    

    View Slide

66. "84Ҏ֎ʹ΋
    ϚωʔδυͳαʔϏε͕͋Δ
    

    View Slide

67. 9BB4
    "OZUIJOHBTBTFSWJDF
    
    

    View Slide

68. ͕ͩ9BB4ʹ͸
    ϨΠςϯγ͕໰୊ʹͳΔ΋ͷ΋͋Δ
    1BB4%#BB44&BB4FUD
    
    

    View Slide

69. ͔͠͠ɺଟ͘ͷ9BB4͸
    "84্ʹϗεςΟϯά͕ՄೳͰ͋Δ
    

    View Slide

70. "84͸࠷ॳͷΫϥ΢υϓϩόΠμʹ
    બ୒͞Ε΍͍͢ͷͰ
    ઌਐతͳ9BB4Λ׆༻Ͱ͖Δ
    

    View Slide

71. ϚωʔδυͰ͋ΔϝϦοτΛ׆͔͠
    ӡ༻޻਺Λճආͯ͠ϥΫΛ͢Δ
    

    View Slide

72. 4BB4Χϯύχʔ͔ͩΒͦ͜
    ଞࣾͷ9BB4Λੵۃ׆༻͠ɺ
    ͓ۚΛ෷ͬͯղܾ͢Δ
    

    View Slide

73. ͦͯ͠๻ͨͪ͸
    ϓϩμΫτ ސ٬ͷ՝୊
    ʹूத͢Δ
    

    View Slide

74. 4NBSU)3։ൃͷ՝୊
    

    View Slide

75. ݸΛ௒͑
    ࠓͳ͓૿͑ଓ͚Δσʔλϕʔε܈Λ
    ͲͷΑ͏ʹεέʔϧͤ͞Δ͔
    

    View Slide

76. ϚΠάϨʔγϣϯ໰୊
    ϚΠάϨʔγϣϯʹඵςφϯτ
    ʹςφϯτͰ෼
    ɹฒྻͰ΋࣌ؒ௒
    

    View Slide

77. ΦϖϨʔγϣϯதͷτϥϒϧ໰୊
    ԿΒ͔ͷཧ༝Ͱதஅ͞ΕΔͱ
    ෮چ͕େมɺεΩʔϚࠩҟ͕ൃੜ
    

    View Slide

78. ࣄۀͷ੒௕ʹ൐͏
    λʔήοτن໛ͷมߋ΁ͷରԠ
    ໊ن໛͔Βສ໊ن໛ʹ
    
    

    View Slide

79. ϓϥοτϑΥʔϜԽΛݟਾ͑ͨ
    σʔλϞσϧ΍֎෦࿈ܞͷઃܭ
    

    View Slide

80. ·ͩ·ͩ΍Δ͜ͱ͸୔ࢁ͋Γ·͢ʂ
    

    View Slide

81. ɹɹɹɹɹ͸
    ΤϯδχΞઈࢍ࠾༻தʂ
    

    View Slide

82. View Slide

83. ൃදऀϓϩϑΟʔϧ
    )/΀ΓΜ͍ͨ
    ιϑτ΢ΣΞΤϯδχΞ όοΫΤϯυ
    
    4NBSU)3Ͱಇ͍͍ͯ·͢
    5XJUUFS!TQBDFQSP@CF
    (JU)VC!QVSJOUBJ
    

    View Slide