サーバー監視[自作]入門 / How to build monitoring system with Redash

Mackerel UG × IDCFクラウド UG Meetup #1 の LT 資料です
https://mackerel-ug.connpass.com/event/99477/

Transcript

1. αʔόʔ؂ࢹ[ࣗ࡞]ೖ໳
   @ariarijp / Takuya Arita
   

   View Slide

2. ࣗݾ঺հ
   • ariarijp / ༗ా ୓࠸ / Takuya Arita
   • גࣜձࣾϢχτʔϯॴଐ
   • ޿ࠂ PF ͷ API Λ࢖ͬͨ޿ࠂӡ༻πʔϧ։ൃ
   • mackerel-plugin-php-fpm, mackerel-client-php ͷ࡞ऀ
   • Redash Meetup ओ࠵
   

   View Slide

3. αʔόʔ؂ࢹͷཁૉ
   • ؂ࢹର৅ϝτϦΫεͷऔಘ
   • औಘͨ͠ϝτϦΫεͷ஝ੵ
   • ஝ੵͨ͠ϝτϦΫεͷ؍ଌ
   • ؍ଌ݁Ռʹجͮ͘௨஌
   

   View Slide

4. ͜ΕΒΛ OSS Λ૊Έ߹Θͤͯ
   ࣮ݱͯ͠Έ·͢
   Prometheus ΍ NagiosɺMunin ͳͲͷ࿩͸͠·ͤΜ
   

   View Slide

5. αʔόʔ؂ࢹͷཁૉ
   • ؂ࢹର৅ϝτϦΫεͷऔಘ -> osquery
   • औಘͨ͠ϝτϦΫεͷ஝ੵ -> Fluentd
   • ஝ੵͨ͠ϝτϦΫεͷ؍ଌ -> Redash
   • ؍ଌ݁Ռʹجͮ͘௨஌ -> Redash
   

   View Slide

6. ࢖༻͢Δ OSS
   • osquery / https://osquery.io/
   • Facebook ͕ެ։͍ͯ͠Δ OSSɻSQL Ͱ ϝτϦΫεΛऔಘͰ͖Δ
   • Fluentd / https://www.fluentd.org/
   • σʔλΛऩूɾసૹ͢Δͷʹศརͳ OSS ɻ
   • Redash / https://redash.io/
   • ଟ͘ͷσʔλιʔεʹରԠͨ͠ OSS / SaaS ͷ BI πʔϧɻσʔλ
   ͷऔಘɺՄࢹԽ΍Ξϥʔτػೳ
   

   View Slide

7. ಈ࡞Πϝʔδ(ՄࢹԽ)
   

   View Slide

8. ಈ࡞Πϝʔδ(؂ࢹ)
   

   View Slide

9. ߏ੒Πϝʔδ
   <- ͪΐͬͱ Python ͰՃ޻
   

   View Slide

10. OSS Λ૊Έ߹ΘͤΔ͚ͩͰ
    ؂ࢹγεςϜ͸ࣗ࡞Ͱ͖Δ
    ΍Βͳ͍͍ͯ͘ͱࢥ͍·͢
    

    View Slide

11. ࣗ࡞͢Δͷ͸ָ͍͠
    ͜ͷ LT ४උΊͪΌͪ͘Όָ͔ͬͨ͠
    

    View Slide

12. ָ͍͚͠Ͳ
    

    View Slide

13. IDCF Ϋϥ΢υΛ࢖͏ͳΒ
    ؂ࢹ͸ Mackerel Ұ୒
    IDCF Ϋϥ΢υ x Mackerel ͷྉۚମܥΛࠓ೔஌Γ·ͨ͠
    

    View Slide

14. IDCF Ϋϥ΢υͱ Mackerel Ͱ
    ϫΫϫΫ͢Δ։ൃΛʂ
    

    View Slide