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
570
EurekaBIのミッションと事例
tamakitetsumoto
0
2.5k
Pairsと組織とデータチームの変遷
tamakitetsumoto
0
1.4k
Other Decks in Technology
See All in Technology
Exadata Database Service on Cloud@Customer セキュリティ、ネットワーク、および管理について
oracle4engineer
PRO
2
1.6k
スクラムというコンフォートゾーンから抜け出そう!プロジェクト全体に目を向けるインセプションデッキ / Inception Deck for seeing the whole project
takaking22
3
160
データベースの負荷を紐解く/untangle-the-database-load
emiki
2
550
Log Analytics を使った実際の運用 - Sansan Data Hub での取り組み
sansantech
PRO
0
120
Cracking the Coding Interview 6th Edition
gdplabs
14
28k
生成AI×財務経理:PoCで挑むSlack AI Bot開発と現場巻き込みのリアル
pohdccoe
1
820
Introduction to OpenSearch Project - Search Engineering Tech Talk 2025 Winter
tkykenmt
2
220
困難を「一般解」で解く
fujiwara3
8
2.3k
EDRの検知の仕組みと検知回避について
chayakonanaika
12
5.3k
エンジニア主導の企画立案を可能にする組織とは?
recruitengineers
PRO
1
310
QAエンジニアが スクラムマスターをすると いいなぁと思った話
____rina____
0
100
AWSアカウントのセキュリティ自動化、どこまで進める? 最適な設計と実践ポイント
yuobayashi
7
1.7k
Featured
See All Featured
A Modern Web Designer's Workflow
chriscoyier
693
190k
A Tale of Four Properties
chriscoyier
158
23k
How To Stay Up To Date on Web Technology
chriscoyier
790
250k
Build your cross-platform service in a week with App Engine
jlugia
229
18k
A Philosophy of Restraint
colly
203
16k
Become a Pro
speakerdeck
PRO
26
5.2k
How GitHub (no longer) Works
holman
314
140k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
7
660
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
27
1.9k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
115
51k
Mobile First: as difficult as doing things right
swwweet
223
9.5k
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 :)