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

ベンチャーならではのRedshift低コスト運用

tama
April 27, 2015

 ベンチャーならではのRedshift低コスト運用

pairsでのRedshiftの運用方法について、その構成とコスト面での効果を説明します。

tama

April 27, 2015
Tweet

More Decks by tama

Other Decks in Technology

Transcript

  1. CONFIDENTIAL Copyright © 2009-2014 eureka, Inc. All rights reserved. 2015/04/23

    ͑ͼελʂ#2 ϕϯνϟʔͳΒͰ͸ͷ Redshiftͷ௿ίετӡ༻ Tamaki Tetsumoto
  2. Copyright © 2009-2015 eureka, Inc. All rights reserved. • pairsαʔόʔαΠυ


    ΤϯδχΞ • PhpStorm • Πϯλʔϯ͔Βೖࣾ • ࣾձਓ3೥໨ • PHPer΋͏͙͢5೥໨ಥೖ • ͜Ε͔ΒGopher גࣜձࣾΤ΢ϨΧ మຊ ؀
  3. Copyright © 2009-2014 eureka, Inc. All rights reserved. DL਺ਪҠ Couples

    562,500 1,125,000 1,687,500 2,250,000 2014/5 2014/6 2014/7 2014/8 2014/9 2014/10 2014/11 2014/12 2015/1 2015/2 2015/3 200ສ DLୡ੒
  4. Copyright © 2009-2014 eureka, Inc. All rights reserved. 500,000 1,000,000

    1,500,000 2,000,000 2012/10 2012/12 2013/2 2013/4 2013/6 2013/8 2013/10 2013/12 2014/2 2014/4 2014/6 2014/8 2014/10 2014/12 2015/2 ྦྷܭϢʔβʔ਺ਪҠ pairs 220ສ Ϣʔβʔୡ੒
  5. Copyright © 2009-2015 eureka, Inc. All rights reserved. %ZOBNP%# w

    ϩάΠϯΞΫγϣϯ w ࠓ೔ͷϐοΫΞοϓ w ଍͋ͱFUD
  6. Copyright © 2009-2015 eureka, Inc. All rights reserved. ʕ̡̢̡ʘ̅͟ ͡

    ͜ 㷌 â @ ʔ̢̡̢ ؅ཧը໘Λվम͍ͨ͠ ,1*ݟ௚͠·͢ ΞϧΰϦζϜௐ੔ͷώϯτཉ͍͠ ചΓ্͛༧ଌཱ͍ͯͨ
  7. $ COPY pairs FROM ‘dynamodb://[テーブル名]’ "NB[PO%ZOBNP%#͔Βͷ$01: Copyright © 2009-2015 eureka,

    Inc. All rights reserved. "NB[PO%ZOBNP%# $01: "NB[PO3FETIJGU ͨͩ͠ɺશ݅$01:ͷΈ
  8. Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU

    &.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ଎͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º
  9. Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU

    &.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ଎͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º #JH2VFSZ͸ΫΤϦ՝ۚ ࣌ؒ՝ۚͰൺֱ͢Δͱ 3FETIJGU&.3
  10. Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU

    &.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ଎͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º σʔλసૹྉ͕ۚ #JH2VFSZͷJNQPSUͱ "84ͷPVUQVUͰ͔͔Δ 4͔Β3FETIJGU΁ͷ σʔλసૹ͸ແྉ
  11. Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU

    &.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ଎͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˚ º ਂ໷όονͰूܭͳͷͰ ࠓճ͸଎͞͸ͦ͜·Ͱ ٻΊ͍ͯͳ͍
  12. #JH2VFSZ 3FETIJGU &.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚

    ˓ ଎͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º Copyright © 2009-2015 eureka, Inc. All rights reserved. ຖ೔61%"5&͍ͨ͠ σʔλ͕͋ΔͷͰக໋తʜ
  13. Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU

    &.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ଎͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º ܹ͍͠ςʔϒϧͷ ֻ͚߹Θ͕ͤ͋ΔͷͰ ؤுͬͯཉ͔ͬͨ͠ʂ
  14. Copyright © 2009-2015 eureka, Inc. All rights reserved. 3FETIJGUʹܾΊ·ͨ͠ w

    1PTUHSF42-ϕʔεɹ w 61%"5& %&-&5&ɹɹɹɹ w ෳࡶͳΫΤϦɹɹɹɹɹɹɹ w ӡ༻ίετ͸ઃܭͰΧόʔɹ ͷ42-͕࢖͑Δ ͕ൃߦͰ͖Δ ͕ൃߦͰ͖Δ ͢Δ
  15. Copyright © 2009-2015 eureka, Inc. All rights reserved. 4 3FETIJGU

    &$ 3%4.Z42- 3%4.Z42- %ZOBNP%# 'MVFOUE 4OBQTIPU
  16. 4 3FETIJGU &$ 3%4.Z42- 3%4 %ZOBNP%# 'MVFOUE σʔλநग़ ਂ໷όονͰ લ೔ͷσʔλΛநग़ɺ

    UTWϑΝΠϧग़ྗ 4OBQTIPU Copyright © 2009-2015 eureka, Inc. All rights reserved.
  17. 4 3FETIJGU &$ 3%4 'MVFOUE 4OBQTIPU Copyright © 2009-2015 eureka,

    Inc. All rights reserved. UTWϑΝΠϧΛ 4΁อଘ 3%4 %ZOBNP%# ϑΝΠϧΞοϓϩʔυ
  18. 4 3FETIJGU &$ 3%4 3%4 %ZOBNP%# 'MVFOUE "1*Ͱ4OBQTIPU͔Β $MVTUFSΛىಈ 4OBQTIPU

    Copyright © 2009-2015 eureka, Inc. All rights reserved. 3FETIJGUىಈ
  19. 4 3FETIJGU &$ 3%4 3%4 %ZOBNP%# 'MVFOUE $01:ίϚϯυͰ 3FETIJGU͕4͔Β σʔλΛಡΈࠐΈ

    $01:ίϚϯυ࣮ߦ 4OBQTIPU Copyright © 2009-2015 eureka, Inc. All rights reserved. UTWϑΝΠϧͷ ಡΈࠐΈ σʔλϩʔυ
  20. 4 3FETIJGU &$ 3%4 3%4.Z42- %ZOBNP%# 'MVFOUE "NB[PO3FETIJGU42- ʢ1PTUHSF42-ϕʔεʣ ΫΤϦ࣮ߦ

    4OBQTIPU Copyright © 2009-2015 eureka, Inc. All rights reserved. ΫΤϦ࣮ߦ ूܭ
  21. 4 3FETIJGU &$ 3%4 3%4.Z42- %ZOBNP%# 'MVFOUE 4OBQTIPU ूܭ݁Ռͷ อଘ

    Copyright © 2009-2015 eureka, Inc. All rights reserved. ूܭ݁ՌΛ ؅ཧը໘ઐ༻ͷ 3%4΁อଘ ूܭ݁Ռͷอଘ
  22. 4 3FETIJGU &$ 3%4 3%4 %ZOBNP%# 'MVFOUE "1*Ͱ4OBQTIPUʹ όοΫΞοϓΛอଘ $MVTUFSΛ࡟আ

    4OBQTIPU "1*Ͱ 4OBQTIPU΁ อଘɾ࡟আ ˞"1*ͷҾ਺Ͱ$MVTUFS࡟আ࣌ʹ ɹόοΫΞοϓΛऔΔ͔ࢦఆՄೳ Copyright © 2009-2015 eureka, Inc. All rights reserved. 3FETIJGUͷऴྃ
  23. Copyright © 2009-2015 eureka, Inc. All rights reserved.  

     ˞ίετ࡟ݮ෯ʹ͍ͭͯ͸σʔλྔ΍ܭࢉྔͳͲ ɹ࢖༻؀ڥɾ༻్ʹΑͬͯҟͳΓ·͢ɻ
  24. 4 3FETIJGU &$ 3%4 %ZOBNP%# 'MVFOUE 4OBQTIPU Copyright © 2009-2015

    eureka, Inc. All rights reserved. EXMBSHF 3FETIJGUৗ࣌Քಇ ˞౦ژΦϯσϚϯυྉۚͰܭࢉ   IՔಇ ͍͍ͩͨ
  25. 4 3FETIJGU &$ 3%4 3%4.Z42- %ZOBNP%# 'MVFOUE 4OBQTIPU  

    Copyright © 2009-2015 eureka, Inc. All rights reserved. ˞౦ژΦϯσϚϯυྉۚͰܭࢉ ௿ίετӡ༻ IOFXՔಇ 3FETIJGUɿEXMBSHF IˣՔಇ 3%4ɿUTNBMM  ͍͍ͩͨ
  26. େن໛Ϗοάσʔλ
 ղੳ ϚονϯάΞϧΰϦζϜ Big Data (PϑϧεΫϥον ϋΠϒϦου ΤϯδχΞ ✕ Engineering

    ʮੈքͰѪ͞ΕΔαʔϏεʯΛҰॹʹ࡞Γ·ͤΜ͔ʁ ྆Ϗδωε͕
 ηάϝϯτ/P άϩʔόϧల։த Business