Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
ベンチャーならではのRedshift低コスト運用
Search
tama
April 27, 2015
Technology
1
3.3k
ベンチャーならではのRedshift低コスト運用
pairsでのRedshiftの運用方法について、その構成とコスト面での効果を説明します。
tama
April 27, 2015
Tweet
Share
More Decks by tama
See All by tama
Data Platform構築プロジェクト推進の事例と学び
tamakitetsumoto
18
19k
組織のデータリテラシー向上における、エウレカでの事例紹介
tamakitetsumoto
0
550
EurekaBIのミッションと事例
tamakitetsumoto
0
2.4k
Pairsと組織とデータチームの変遷
tamakitetsumoto
0
1.4k
Other Decks in Technology
See All in Technology
Spring Frameworkの新標準!? ~ RestClientとHTTPインターフェース入門 ~
ogiwarat
2
260
製造現場のデジタル化における課題とPLC Data to Cloudによる新しいアプローチ
hamadakoji
0
210
RustとWebAssemblyを使って高速な画像処理をWebアプリで実行しよう
rebonire626
0
110
Engineering at LY Corporation
lycorp_recruit_jp
0
320
信頼性に挑む中で拡張できる・得られる1人のスキルセットとは?
ken5scal
1
400
AWS パートナー企業でテクニカルサポートに従事して 3年経ったので思うところをまとめてみた
kazzpapa3
1
220
福岡新卒エンジニアの会
teba_eleven
1
190
私はこうやってマインドマップでテストすることを出す!
mineo_matsuya
0
210
Terraform未経験の御様に対してどの ように導⼊を進めていったか
tkikuchi
1
260
ドメイン名の終活について - JPAAWG 7th -
mikit
31
17k
DatabricksにおけるLLMOpsのベストプラクティス
taka_aki
4
1.6k
AI機能の開発運用のリアルと今後のリアル
akiroom
0
250
Featured
See All Featured
ReactJS: Keep Simple. Everything can be a component!
pedronauck
665
120k
Intergalactic Javascript Robots from Outer Space
tanoku
268
27k
The Invisible Side of Design
smashingmag
297
50k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
28
9.1k
Why You Should Never Use an ORM
jnunemaker
PRO
54
9k
GraphQLの誤解/rethinking-graphql
sonatard
67
10k
A better future with KSS
kneath
238
17k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
27
820
Designing for Performance
lara
604
68k
Become a Pro
speakerdeck
PRO
25
5k
Docker and Python
trallard
40
3.1k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
27
2k
Transcript
CONFIDENTIAL Copyright © 2009-2014 eureka, Inc. All rights reserved. 2015/04/23
͑ͼελʂ#2 ϕϯνϟʔͳΒͰͷ Redshiftͷίετӡ༻ Tamaki Tetsumoto
Copyright © 2009-2015 eureka, Inc. All rights reserved. • pairsαʔόʔαΠυ
ΤϯδχΞ • PhpStorm • Πϯλʔϯ͔Βೖࣾ • ࣾձਓ3 • PHPer͏͙͢5ಥೖ • ͜Ε͔ΒGopher גࣜձࣾΤϨΧ మຊ
ΤϯδχΞͷਓ 29% 71% ΤϯδχΞ ඇΤϯδχΞ ϋΠϒϦουɿ21ਓ WebΤϯδχΞɿ10ਓ iOS/AndroidΤϯδχΞɿ16ਓ Copyright ©
2009-2015 eureka, Inc. All rights reserved. 47ਓ 27.6 ࡀ ฏۉྸ
pairs Couples Copyright © 2009-2015 eureka, Inc. All rights reserved.
Copyright © 2009-2014 eureka, Inc. All rights reserved. pairs Couples
Copyright © 2009-2014 eureka, Inc. All rights reserved. iOS android
Couples Target Users are 18-26
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ୡ
Copyright © 2009-2014 eureka, Inc. All rights reserved. pairs Couples
Copyright © 2009-2014 eureka, Inc. All rights reserved. PC Browser
iOS android SP Browser pairs
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ສ Ϣʔβʔୡ
QBJSTͷΠϯϑϥߏ Copyright © 2009-2015 eureka, Inc. All rights reserved.
Copyright © 2009-2015 eureka, Inc. All rights reserved. "84ϑϧ׆༻ ൺֱతελϯμʔυͳߏͰ͢
3%4ʢ.Z42-ʣ w ϢʔβʔϓϩϑΟʔϧ w ചΓ্͛ w ϚονϯάFUD Copyright © 2009-2015
eureka, Inc. All rights reserved.
Copyright © 2009-2015 eureka, Inc. All rights reserved. %ZOBNP%# w
ϩάΠϯΞΫγϣϯ w ࠓͷϐοΫΞοϓ w ͋ͱFUD
ڈΔɺ݄ Copyright © 2009-2015 eureka, Inc. All rights reserved.
ʕ̡̢̡ʘ̅͟ ͡ ͜ 㷌 â @ ʔ̢̡̢ ཧը໘Λվम͍ͨ͠ Copyright ©
2009-2015 eureka, Inc. All rights reserved.
Copyright © 2009-2015 eureka, Inc. All rights reserved. ʕ̡̢̡ʘ̅͟ ͡
͜ 㷌 â @ ʔ̢̡̢ ཧը໘Λվम͍ͨ͠ ,1*ݟ͠·͢ ΞϧΰϦζϜௐͷώϯτཉ͍͠ ചΓ্͛༧ଌཱ͍ͯͨ
બࢶͭ Copyright © 2009-2015 eureka, Inc. All rights reserved.
(PPHMF#JH2VFSZ "NB[PO3FETIJGU "NB[PO&MBTUJD.BQ3FEVDF Copyright © 2009-2015 eureka,
Inc. All rights reserved.
Copyright © 2009-2015 eureka, Inc. All rights reserved. ͦͷલʹɺ3FETIJGUͱʜ
w ྻࢦʢΧϥϜφʔʣ%# w ϚωʔδυαʔϏεʢࣗಈόοΫΞοϓͳͲʣ w ࣌ؒ՝ۚ w "NB[PO4͔Βͷσʔλసૹແྉ "NB[PO3FETIJGU Copyright
© 2009-2015 eureka, Inc. All rights reserved.
ϫϯϥΠφʔͰσʔλΛऔΓࠐΊΔ ʢ4ͱ%ZOBNP%#͔Βʣ "NB[PO4 "NB[PO%ZOBNP%# "NB[PO3FETIJGU Copyright © 2009-2015 eureka, Inc.
All rights reserved.
$ COPY [コピー先DB名] FROM ‘s3://[Bucket名]/[ディレクトリパス]/’ σΟϨΫτϦࢦఆͰ $01:Մೳ "NB[PO4͔Βͷ$01: "NB[PO4 $01:
"NB[PO3FETIJGU Copyright © 2009-2015 eureka, Inc. All rights reserved.
$ COPY pairs FROM ‘dynamodb://[テーブル名]’ "NB[PO%ZOBNP%#͔Βͷ$01: Copyright © 2009-2015 eureka,
Inc. All rights reserved. "NB[PO%ZOBNP%# $01: "NB[PO3FETIJGU ͨͩ͠ɺશ݅$01:ͷΈ
Copyright © 2009-2015 eureka, Inc. All rights reserved. Ͱɺൺֱͯ͠Έ·͢
Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU
&.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º
Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU
&.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º #JH2VFSZΫΤϦ՝ۚ ࣌ؒ՝ۚͰൺֱ͢Δͱ 3FETIJGU&.3
Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU
&.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º σʔλసૹྉ͕ۚ #JH2VFSZͷJNQPSUͱ "84ͷPVUQVUͰ͔͔Δ 4͔Β3FETIJGUͷ σʔλసૹແྉ
Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU
&.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˚ º ਂόονͰूܭͳͷͰ ࠓճͦ͜͞·Ͱ ٻΊ͍ͯͳ͍
#JH2VFSZ 3FETIJGU &.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚
˓ ͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º Copyright © 2009-2015 eureka, Inc. All rights reserved. ຖ61%"5&͍ͨ͠ σʔλ͕͋ΔͷͰக໋తʜ
Copyright © 2009-2015 eureka, Inc. All rights reserved. #JH2VFSZ 3FETIJGU
&.3 ಋೖίετ ˓ ˕ ˓ ӡ༻ίετ ˚ ˚ ˓ ͞ ˕ ˓ ˚ 61%"5& %&-&5& º ˓ º ෳࡶͳΫΤϦ ˚ ˓ º ܹ͍͠ςʔϒϧͷ ֻ͚߹Θ͕ͤ͋ΔͷͰ ؤுͬͯཉ͔ͬͨ͠ʂ
Copyright © 2009-2015 eureka, Inc. All rights reserved. 3FETIJGUʹܾΊ·ͨ͠ w
1PTUHSF42-ϕʔεɹ w 61%"5& %&-&5&ɹɹɹɹ w ෳࡶͳΫΤϦɹɹɹɹɹɹɹ w ӡ༻ίετઃܭͰΧόʔɹ ͷ42-͕͑Δ ͕ൃߦͰ͖Δ ͕ൃߦͰ͖Δ ͢Δ
3FETIJGUΛ࣮ࡍʹͲ͏͍ͬͯΔ͔ Copyright © 2009-2015 eureka, Inc. All rights reserved.
Copyright © 2009-2015 eureka, Inc. All rights reserved. 4 3FETIJGU
&$ 3%4.Z42- 3%4.Z42- %ZOBNP%# 'MVFOUE 4OBQTIPU
4 3FETIJGU &$ 3%4.Z42- 3%4 %ZOBNP%# 'MVFOUE σʔλநग़ ਂόονͰ લͷσʔλΛநग़ɺ
UTWϑΝΠϧग़ྗ 4OBQTIPU Copyright © 2009-2015 eureka, Inc. All rights reserved.
4 3FETIJGU &$ 3%4 'MVFOUE 4OBQTIPU Copyright © 2009-2015 eureka,
Inc. All rights reserved. UTWϑΝΠϧΛ 4อଘ 3%4 %ZOBNP%# ϑΝΠϧΞοϓϩʔυ
4 3FETIJGU &$ 3%4 3%4 %ZOBNP%# 'MVFOUE "1*Ͱ4OBQTIPU͔Β $MVTUFSΛىಈ 4OBQTIPU
Copyright © 2009-2015 eureka, Inc. All rights reserved. 3FETIJGUىಈ
4 3FETIJGU &$ 3%4 3%4 %ZOBNP%# 'MVFOUE $01:ίϚϯυͰ 3FETIJGU͕4͔Β σʔλΛಡΈࠐΈ
$01:ίϚϯυ࣮ߦ 4OBQTIPU Copyright © 2009-2015 eureka, Inc. All rights reserved. UTWϑΝΠϧͷ ಡΈࠐΈ σʔλϩʔυ
4 3FETIJGU &$ 3%4 3%4.Z42- %ZOBNP%# 'MVFOUE "NB[PO3FETIJGU42- ʢ1PTUHSF42-ϕʔεʣ ΫΤϦ࣮ߦ
4OBQTIPU Copyright © 2009-2015 eureka, Inc. All rights reserved. ΫΤϦ࣮ߦ ूܭ
4 3FETIJGU &$ 3%4 3%4.Z42- %ZOBNP%# 'MVFOUE 4OBQTIPU ूܭ݁Ռͷ อଘ
Copyright © 2009-2015 eureka, Inc. All rights reserved. ूܭ݁ՌΛ ཧը໘ઐ༻ͷ 3%4อଘ ूܭ݁Ռͷอଘ
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ͷऴྃ
Ͱɺ݁ہͲΕ͘Β͍ίετͰ ࣮ݱͰ͖ͨͷ͔ʁ Copyright © 2009-2015 eureka, Inc. All rights reserved.
Copyright © 2009-2015 eureka, Inc. All rights reserved.
˞ίετݮ෯ʹ͍ͭͯσʔλྔܭࢉྔͳͲ ɹ༻ڥɾ༻్ʹΑͬͯҟͳΓ·͢ɻ
Copyright © 2009-2015 eureka, Inc. All rights reserved. ͬͨ͜ͱ
Copyright © 2009-2015 eureka, Inc. All rights reserved. ᶃ3FETIJGUىಈඞཁͳ͚࣌ͩ
Copyright © 2009-2015 eureka, Inc. All rights reserved. 3FETIJGUՔಇ࣌ؒ ࣌ؒˠ࣌ؒ
Copyright © 2009-2015 eureka, Inc. All rights reserved. ᶄूܭ݁ՌΛ3%4อଘ
Copyright © 2009-2015 eureka, Inc. All rights reserved. ઐ༻ཧը໘ͳͷͰ খ͍͞ΠϯελϯεͰ࣌ؒՔಇ
4 3FETIJGU &$ 3%4 %ZOBNP%# 'MVFOUE 4OBQTIPU Copyright © 2009-2015
eureka, Inc. All rights reserved. EXMBSHF 3FETIJGUৗ࣌Քಇ ˞౦ژΦϯσϚϯυྉۚͰܭࢉ IՔಇ ͍͍ͩͨ
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 ͍͍ͩͨ
Copyright © 2009-2015 eureka, Inc. All rights reserved. ·ͱΊ
3FETIJGU͕͍͍ͯΔ݅ w "84ϑϧ׆༻ͷΠϯϑϥߏ w %ZOBNP%#ͷσʔλ͏ ɹɹɹˠશσʔλͳΒಡΈࠐΈՄೳʂ ɹɹɹˠ͚ࠩͩऔΓࠐΈ͍ͨͳΒ4Λ͓͏ w ߋ৽ɾআ͍ͨ͠σʔλ͕͋Δ w
ͳ͔ͳ͔ܹ͍͠+0*/ͷཛྷ Copyright © 2009-2015 eureka, Inc. All rights reserved.
ίετӡ༻͕Ͱ͖Δ݅ w σʔλूܭҰఆͷλΠϛϯάͰྑ͍ w ूܭύλʔϯ͕ܾ·͍ͬͯΔ ɹɹɹˠઐ༻ͷ3%4Λͬͯूܭ݁ՌͷΈอଘʂ Copyright © 2009-2015 eureka,
Inc. All rights reserved.
͜ͷੳج൫Ͱ QBJSTதʂ Copyright © 2009-2015 eureka, Inc. All rights reserved.
େنϏοάσʔλ ղੳ ϚονϯάΞϧΰϦζϜ Big Data (PϑϧεΫϥον ϋΠϒϦου ΤϯδχΞ ✕ Engineering
ʮੈքͰѪ͞ΕΔαʔϏεʯΛҰॹʹ࡞Γ·ͤΜ͔ʁ ྆Ϗδωε͕ ηάϝϯτ/P άϩʔόϧల։த Business
CONFIDENTIAL Copyright © 2009-2014 eureka, Inc. All rights reserved. Thank
you :)