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
18k
組織のデータリテラシー向上における、エウレカでの事例紹介
tamakitetsumoto
0
540
EurekaBIのミッションと事例
tamakitetsumoto
0
2.4k
Pairsと組織とデータチームの変遷
tamakitetsumoto
0
1.3k
Other Decks in Technology
See All in Technology
不動産売買取引におけるAIの可能性とプロダクトでのAI活用
zabio3
0
270
Developer Experienceを向上させる基盤づくりの取り組み事例集
coconala_engineer
0
150
eBPFのこれまでとこれから
yutarohayakawa
10
3.2k
watsonx.ai Dojo 環境準備について
oniak3ibm
PRO
0
300
The XZ Backdoor Story
fr0gger
0
3.6k
より快適なエラーログ監視を目指して
leveragestech
4
1.4k
DuckDB雑紹介(1.1対応版)@DuckDB座談会
ktz
6
1.4k
OR学会2024秋_短期収益と将来のオフ方策評価性能を考慮したクーポン割当方策混合比の決定
recruitengineers
PRO
4
460
Creative UIs with Compose: DroidKaigi 2024
chrishorner
1
580
Mocking in Rust Applications
taiki45
2
410
『GRANBLUE FANTASY Relink』キャラクターの魅力を支えるリグ・シミュレーション制作事例
cygames
0
120
再考 アクターモデル/ reconsider actor model
ytake
0
360
Featured
See All Featured
Intergalactic Javascript Robots from Outer Space
tanoku
268
26k
A better future with KSS
kneath
235
17k
Done Done
chrislema
180
16k
Why You Should Never Use an ORM
jnunemaker
PRO
53
8.9k
A Philosophy of Restraint
colly
202
16k
Mobile First: as difficult as doing things right
swwweet
221
8.8k
YesSQL, Process and Tooling at Scale
rocio
167
14k
The Language of Interfaces
destraynor
153
23k
GraphQLとの向き合い方2022年版
quramy
43
13k
The Invisible Side of Design
smashingmag
296
50k
Testing 201, or: Great Expectations
jmmastey
36
7k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
23
1.7k
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 :)