クックパッドの管理アプリケーションの近況報告

Transcript

1. ΫοΫύουͷ؅ཧΞϓϦέʔ
   γϣϯͷۙگใࠂ
   ؅ཧը໘νϥݟͤὑφΠτ
   ΫοΫύουגࣜձࣾେੴӳհ
   

   View Slide

2. ࣗݾ঺հ
   • େੴӳհ
   • ΫοΫύουגࣜձࣾ ٕज़෦ ։ൃج൫άϧʔϓ
   • https://github.com/eisuke
   • https://twitter.com/eiskeoishi
   • ࠷ۙͷର֎తͳ׆ಈ
   • kuroko2 OSSԽ https://github.com/cookpad/kuroko2
   • ෳ਺αʔϏεؒͷ੔߹ੑͷऔΓ૊Έʹ͍ͭͯ - ΫοΫύου։
   ൃऀϒϩά http://techlife.cookpad.com/entry/2016/06/01/070000
   

   View Slide

3. 8&"3&)*3*/(
   IUUQTSFDSVJUDPPLQBEDPN
   

   View Slide

4. ΫοΫύουͷ؅ཧΞϓϦ
   έʔγϣϯʹ͍ͭͯͷۙگ
   

   View Slide

5. ΫοΫύουͷ؅ཧΞϓϦέʔγϣϯͷ਺
   • ਺͑ͯΈ·ͨ͠
   

   View Slide

6. ΫοΫύουͷ؅ཧΞϓϦέʔγϣϯͷ਺
   38ݸҎ্
   

   View Slide

7. ΫοΫύουͷ؅ཧΞϓϦέʔγϣϯ
   νϥݟͤλΠϜ
   

   View Slide

8. ܾࡁ؅ཧγεςϜ
   

   View Slide

9. όον؅ཧγεςϜ
   

   View Slide

10. δϣϒΩϡʔ؅ཧγεςϜ
    

    View Slide

11. Ϣʔβʔ؅ཧը໘
    

    View Slide

12. ؅ཧΞϓϦέʔγϣϯͷઃܭํ਑
    • αʔϏεͷ෼ׂͱ࿈ܞ͸؅ཧΞϓϦͰ΋ߦ͍ͬͯΔ
    • Docker + Hako (ECS)Ͱ؆୯ʹΞϓϦέʔγϣϯͷ
    ࣮ߦ؀ڥߏஙͱσϓϩΠ
    • ؅ཧը໘Ͱ΋API࿈ܞ
    • ٕज़తͳৄࡉ͸ԼهͳͲΛࢀߟʹ
    • Cookpad awakens (ঙ࢘ Յ৫ Cookpad TechConf 2017)
    • https://techconf.cookpad.com/2017/yoshiori.html
    

    View Slide

13. ؅ཧΞϓϦͷͨΊͷϧʔϧͱπʔϧ
    • ؅ཧ༻ΞϓϦέʔγϣϯ࡞੒࣌ͷϧʔϧΛఆٛ
    

    View Slide

14. ؅ཧΞϓϦͷͨΊͷϧʔϧͱπʔϧ
    • ֎෦ωοτϫʔΫ͔ΒͷΞΫηε΋ඞཁʹԠͯ͡Մೳ
    • hako ͷఆٛͰઃఆՄೳ
    • nginx_omniauth_adapter (sorah)
    • nginx Ͱ omniauth Λར༻ͯ͠ΞΫηε੍ޚΛߦ͏
    • http://techlife.cookpad.com/entry/2015/10/16/080000
    

    View Slide

15. ؅ཧΞϓϦͷͨΊͷϧʔϧͱπʔϧ
    • ྫ͑͹kuroko2 ͱ͍͏όον؅ཧπʔϧ
    

    View Slide

16. ؅ཧΞϓϦͷͨΊͷϧʔϧͱπʔϧ
    • ྫ͑͹kuroko2͸Ϩεϙϯγϒͳ؅ཧը໘ͳͷͰεϚϗ͔ΒόονͷϦτϥΠ͕Ͱ͖Δ
    

    View Slide

17. ܭଌ஋΍άϥϑ
    • ࠷ۙ͸ࣾ಺༻Ͱ͋Ε͹؅ཧը໘಺ʹ͸࡞Δ͜ͱ͸গͳ͍
    • DWHͰղܾ
    • DWHʹඞཁͳ͜ͱ (੨໦ๆ࿠ Cookpad TechConf 2016)
    • https://www.slideshare.net/mineroaoki/cookpad-techconf-2016-dwh
    

    View Slide

18. ܭଌ஋΍άϥϑ
    • σΟϨΫλʔ͕SQLΛ࢖͑ͯΑ͔ͬͨ࿩ - ΫοΫύου։ൃऀϒϩά
    • http://techlife.cookpad.com/entry/2016/07/06/094332
    

    View Slide

19. ܭଌ஋΍άϥϑ
    • Redash
    • Bdash
    • http://hokaccha.hatenablog.com/entry/2017/02/08/084821
    

    View Slide

20. ๊͍͑ͯΔ՝୊
    

    View Slide

21. ϨΨγʔͳ؅ཧΞϓϦέʔγϣϯͷଘࡏ
    • ࠷ݹࢀͷ؅ཧΞϓϦέγϣʔϯ papa (2007ʙ)
    

    View Slide

22. ϨΨγʔͳ؅ཧΞϓϦέʔγϣϯͷଘࡏ
    • ࠷ݹࢀͷ؅ཧΞϓϦέγϣʔϯ papa
    

    View Slide

23. ϨΨγʔͳ؅ཧΞϓϦέʔγϣϯͷଘࡏ
    • ෼ׂͱ࿈ܞҎલͷ࣌୅͸ͳΜͰ΋͜͜ʹ࡞͍ͬͯͨ
    • ࢖ΘΕ͍ͯͳ͍ը໘΋ͨ͘͞Μ
    • ؅ཧը໘ͷϝϯςφϯε͸ޙճ͠ʹͳΔ
    • ҰํͰॏཁͳػೳ΋ͨ͘͞Μ࢒͍ͬͯΔ
    • εςʔΫϗϧμʔ΋ͨ͘͞Μ
    • ෼ׂͰ͖Δ΋ͷ͸΍͍ͬͯ͘ํ޲
    • Θ͔Βͳ͍΋ͷ͸ܭଌ
    • ؅ཧը໘Ͱ΋PVͷϩάΛDWHʹೖΕͯௐࠪ
    • ੔ཧ͍͖͍ͯͨ͠
    

    View Slide

24. ·ͱΊ
    • ϓϩμΫτͱಉ༷ʹ؅ཧΞϓϦέʔγϣϯ΋খ͘͞
    ࡞ͬͯ෼ׂͱ࿈ܞΛ͍ͯ͠Δ
    • ڥքΛ͸͖ͬΓͤͯ͞ԿΛ؅ཧ͢Δ͔Λ໌֬ʹͰ
    ͖Δ
    • ΨΠυϥΠϯΛ࡞ͬͯ౷Ұͨ͠ϧʔϧͰӡ༻
    • άϥϑ΍ूܭ஋͸ DWH & BIπʔϧͰ
    • ݹ͍؅ཧΞϓϦέʔγϣϯΛ੔ཧ͢Δ͜ͱ͕՝୊
    

    View Slide

25. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝
    ·ͨ͠
    

    View Slide