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
20k
組織のデータリテラシー向上における、エウレカでの事例紹介
tamakitetsumoto
0
580
EurekaBIのミッションと事例
tamakitetsumoto
0
2.5k
Pairsと組織とデータチームの変遷
tamakitetsumoto
0
1.4k
Other Decks in Technology
See All in Technology
~宇宙最速~2025年AWS Summit レポート
satodesu
1
1.3k
Azure AI Foundryでマルチエージェントワークフロー
seosoft
0
150
キャディでのApache Iceberg, Trino採用事例 -Apache Iceberg and Trino Usecase in CADDi--
caddi_eng
0
170
AI技術トレンド勉強会 #1MCPの基礎と実務での応用
nisei_k
1
240
米国国防総省のDevSecOpsライフサイクルをAWSのセキュリティサービスとOSSで実現
syoshie
2
810
エンジニア向け技術スタック情報
kauche
0
110
2年でここまで成長!AWSで育てたAI Slack botの軌跡
iwamot
PRO
2
140
より良いプロダクトの開発を目指して - 情報を中心としたプロダクト開発 #phpcon #phpcon2025
bengo4com
0
340
In Praise of "Normal" Engineers (LDX3)
charity
3
1.2k
kubellが挑むBPaaSにおける、人とAIエージェントによるサービス開発の最前線と技術展望
kubell_hr
1
390
Welcome to the LLM Club
koic
0
130
Microsoft Build 2025 技術/製品動向 for Microsoft Startup Tech Community
torumakabe
1
200
Featured
See All Featured
Embracing the Ebb and Flow
colly
86
4.7k
The World Runs on Bad Software
bkeepers
PRO
69
11k
A designer walks into a library…
pauljervisheath
206
24k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
34
3k
YesSQL, Process and Tooling at Scale
rocio
173
14k
RailsConf 2023
tenderlove
30
1.1k
How STYLIGHT went responsive
nonsquared
100
5.6k
Making the Leap to Tech Lead
cromwellryan
134
9.3k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
35
2.3k
Building Flexible Design Systems
yeseniaperezcruz
328
39k
Optimizing for Happiness
mojombo
379
70k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
46
9.6k
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 :)