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

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

Takuya Arita
September 11, 2018

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

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

Takuya Arita

September 11, 2018
Tweet

More Decks by Takuya Arita

Other Decks in Programming

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