ΫοΫύουͷཧΞϓϦέʔγϣϯͷۙگใࠂཧը໘νϥݟͤὑφΠτΫοΫύουגࣜձࣾେੴӳհ
View Slide
ࣗݾհ• େੴӳհ• ΫοΫύουגࣜձࣾ ٕज़෦ ։ൃج൫άϧʔϓ• https://github.com/eisuke• https://twitter.com/eiskeoishi• ࠷ۙͷର֎తͳ׆ಈ• kuroko2 OSSԽ https://github.com/cookpad/kuroko2• ෳαʔϏεؒͷ߹ੑͷऔΓΈʹ͍ͭͯ - ΫοΫύου։ൃऀϒϩά http://techlife.cookpad.com/entry/2016/06/01/070000
8&"3&)*3*/(IUUQTSFDSVJUDPPLQBEDPN
ΫοΫύουͷཧΞϓϦέʔγϣϯʹ͍ͭͯͷۙگ
ΫοΫύουͷཧΞϓϦέʔγϣϯͷ• ͑ͯΈ·ͨ͠
ΫοΫύουͷཧΞϓϦέʔγϣϯͷ38ݸҎ্
ΫοΫύουͷཧΞϓϦέʔγϣϯνϥݟͤλΠϜ
ܾࡁཧγεςϜ
όονཧγεςϜ
δϣϒΩϡʔཧγεςϜ
Ϣʔβʔཧը໘
ཧΞϓϦέʔγϣϯͷઃܭํ• αʔϏεͷׂͱ࿈ܞཧΞϓϦͰߦ͍ͬͯΔ• Docker + Hako (ECS)Ͱ؆୯ʹΞϓϦέʔγϣϯͷ࣮ߦڥߏஙͱσϓϩΠ• ཧը໘ͰAPI࿈ܞ• ٕज़తͳৄࡉԼهͳͲΛࢀߟʹ• Cookpad awakens (ঙ࢘ Յ৫ Cookpad TechConf 2017)• https://techconf.cookpad.com/2017/yoshiori.html
ཧΞϓϦͷͨΊͷϧʔϧͱπʔϧ• ཧ༻ΞϓϦέʔγϣϯ࡞࣌ͷϧʔϧΛఆٛ
ཧΞϓϦͷͨΊͷϧʔϧͱπʔϧ• ֎෦ωοτϫʔΫ͔ΒͷΞΫηεඞཁʹԠͯ͡Մೳ• hako ͷఆٛͰઃఆՄೳ• nginx_omniauth_adapter (sorah)• nginx Ͱ omniauth Λར༻ͯ͠ΞΫηε੍ޚΛߦ͏• http://techlife.cookpad.com/entry/2015/10/16/080000
ཧΞϓϦͷͨΊͷϧʔϧͱπʔϧ• ྫ͑kuroko2 ͱ͍͏όονཧπʔϧ
ཧΞϓϦͷͨΊͷϧʔϧͱπʔϧ• ྫ͑kuroko2Ϩεϙϯγϒͳཧը໘ͳͷͰεϚϗ͔ΒόονͷϦτϥΠ͕Ͱ͖Δ
ܭଌάϥϑ• ࠷ۙࣾ༻Ͱ͋Εཧը໘ʹ࡞Δ͜ͱগͳ͍• DWHͰղܾ• DWHʹඞཁͳ͜ͱ (੨ๆ Cookpad TechConf 2016)• https://www.slideshare.net/mineroaoki/cookpad-techconf-2016-dwh
ܭଌάϥϑ• σΟϨΫλʔ͕SQLΛ͑ͯΑ͔ͬͨ - ΫοΫύου։ൃऀϒϩά• http://techlife.cookpad.com/entry/2016/07/06/094332
ܭଌάϥϑ• Redash• Bdash• http://hokaccha.hatenablog.com/entry/2017/02/08/084821
๊͍͑ͯΔ՝
ϨΨγʔͳཧΞϓϦέʔγϣϯͷଘࡏ• ࠷ݹࢀͷཧΞϓϦέγϣʔϯ papa (2007ʙ)
ϨΨγʔͳཧΞϓϦέʔγϣϯͷଘࡏ• ࠷ݹࢀͷཧΞϓϦέγϣʔϯ papa
ϨΨγʔͳཧΞϓϦέʔγϣϯͷଘࡏ• ׂͱ࿈ܞҎલͷ࣌ͳΜͰ͜͜ʹ࡞͍ͬͯͨ• ΘΕ͍ͯͳ͍ը໘ͨ͘͞Μ• ཧը໘ͷϝϯςφϯεޙճ͠ʹͳΔ• ҰํͰॏཁͳػೳͨ͘͞Μ͍ͬͯΔ• εςʔΫϗϧμʔͨ͘͞Μ• ׂͰ͖Δͷ͍ͬͯ͘ํ• Θ͔Βͳ͍ͷܭଌ• ཧը໘ͰPVͷϩάΛDWHʹೖΕͯௐࠪ• ཧ͍͖͍ͯͨ͠
·ͱΊ• ϓϩμΫτͱಉ༷ʹཧΞϓϦέʔγϣϯখ͘͞࡞ׂͬͯͱ࿈ܞΛ͍ͯ͠Δ• ڥքΛ͖ͬΓͤͯ͞ԿΛཧ͢Δ͔Λ໌֬ʹͰ͖Δ• ΨΠυϥΠϯΛ࡞ͬͯ౷Ұͨ͠ϧʔϧͰӡ༻• άϥϑूܭ DWH & BIπʔϧͰ• ݹ͍ཧΞϓϦέʔγϣϯΛཧ͢Δ͜ͱ͕՝
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠