Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Sumallyにおける Amazon Redshift 導入事例

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers.

Sumallyにおける Amazon Redshift 導入事例

How Sumally uses Redshift

Avatar for Noriaki Katayama

Noriaki Katayama

April 04, 2014
Tweet

Other Decks in Technology

Transcript

  1. 3FETIJGUͷӡ༻ํ਑ w 4VNBMMZͷϝΠϯγεςϜ͸$BMJGPSOJB VTXFTU w 3FETIJGU͸0SFHPO VTXFTU Ͱӡ༻ w ஍ཧతʹ$BMJGPSOJBͱ͍ۙˍ౦ژΑΓ͍҆

    w 44% w ·ͩ·ͩσʔλྔ͕গͳ͍ͷͰ଎͍ํΛ࢖͏ w (#͘Β͍·Ͱ͸)%%ΑΓ͓ಘ w ೚ҙͷλΠϛϯάͰ͸όοΫΞοϓ͠ͳ͍ʢࣗಈεφοϓγϣοτͷΈʣ w ϓϩμΫγϣϯ͔Β੾Γ཭͞Εͨσʔλղੳ༻؀ڥͳͷͰ࠷ѱΫϥελ͕ ແ͘ͳͬͯ΋4͔Β෮چͰ͖Ε͹ྑ͍ʢ࣮ࡍ෼Ͱ෮چͰ͖Δʣ 
  2. χΞϦΞϧλΠϜߋ৽  աڈͷߦಈϩάͷม׵ w αʔϏεϩʔϯν͔ΒͷߦಈϩάΛ$47ʹ$01:ͨ͠ w  SPXTTFDʢσʔλͷಛੑʹΑΔͷͰҰ֓ʹݴ͑ͳ͍ʣ  qVFOUE㱺4㱺3FETIJU

    w ʙNTͰճͷ$01:࣮ߦ w qVFOUQMVHJOSFETIJGUʢλΠϜΞ΢τ͢ΔͱqVFOUE͝ͱམͪΔʣ w qVFOUQMVHJOKTPOCVDLFUʢෆਖ਼ͳόΠτྻ͕ೖΔͱσʔλফ͑Δʣ w $01:ίϚϯυͷ+40/ΦϓγϣϯରԠʢࠓޙ͜ͷܗࣜʹҠߦ༧ఆʣ 
  3. $01:ίϚϯυͷৄࡉͳਐ௙ঢ়گΛ ஌Γ͍ͨʂ # select trim(name) tablename, col, to_char(sum(num_values), '999,999,999,999') count

    from SVV_DISKUSAGE where name = 'event_log' group by name, col order by 1, 2; tablename | col | count -----------+-----+------------------ event_log | 0 | 101,532 event_log | 1 | 101,532 event_log | 2 | 101,532 event_log | 3 | 101,532 event_log | 4 | 101,532 event_log | 5 | 101,532 event_log | 6 | 101,532 event_log | 7 | 101,532 event_log | 8 | 101,532 event_log | 9 | 101,532 event_log | 10 | 101,532 
  4. σΟεΫ࢖༻ྔΛ೺Ѳ͍ͨ͠ʂ # select trim(name) name, count(*) size from SVV_DISKUSAGE where

    name = 'event_log' group by name order by 1; name | size -----------+------ event_log | 23 ˞TJ[Fͷ୯Ґ͸.#