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
560
EurekaBIのミッションと事例
tamakitetsumoto
0
2.4k
Pairsと組織とデータチームの変遷
tamakitetsumoto
0
1.4k
Other Decks in Technology
See All in Technology
FlutterアプリにおけるSLI/SLOを用いたユーザー体験の可視化と計測基盤構築
ostk0069
0
100
【令和最新版】AWS Direct Connectと愉快なGWたちのおさらい
minorun365
PRO
5
760
オープンソースAIとは何か? --「オープンソースAIの定義 v1.0」詳細解説
shujisado
10
1.1k
【Startup CTO of the Year 2024 / Audience Award】アセンド取締役CTO 丹羽健
niwatakeru
0
1.3k
生成AIが変えるデータ分析の全体像
ishikawa_satoru
0
170
プロダクト活用度で見えた真実 ホリゾンタルSaaSでの顧客解像度の高め方
tadaken3
0
180
強いチームと開発生産性
onk
PRO
35
11k
Engineer Career Talk
lycorp_recruit_jp
0
190
AWS Lambdaと歩んだ“サーバーレス”と今後 #lambda_10years
yoshidashingo
1
180
ISUCONに強くなるかもしれない日々の過ごしかた/Findy ISUCON 2024-11-14
fujiwara3
8
870
Amplify Gen2 Deep Dive / バックエンドの型をいかにしてフロントエンドへ伝えるか #TSKaigi #TSKaigiKansai #AWSAmplifyJP
tacck
PRO
0
390
TanStack Routerに移行するのかい しないのかい、どっちなんだい! / Are you going to migrate to TanStack Router or not? Which one is it?
kaminashi
0
600
Featured
See All Featured
What's in a price? How to price your products and services
michaelherold
243
12k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
665
120k
RailsConf 2023
tenderlove
29
900
GitHub's CSS Performance
jonrohan
1030
460k
Building Better People: How to give real-time feedback that sticks.
wjessup
364
19k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
44
6.8k
For a Future-Friendly Web
brad_frost
175
9.4k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
33
1.9k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
48k
10 Git Anti Patterns You Should be Aware of
lemiorhan
655
59k
A designer walks into a library…
pauljervisheath
204
24k
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 :)