サーバー監視[自作]入門 / 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
2. ࣗݾ঺հ • ariarijp / ༗ా ୓࠸ / Takuya Arita • גࣜձࣾϢχτʔϯॴଐ • ޿ࠂ PF ͷ API Λ࢖ͬͨ޿ࠂӡ༻πʔϧ։ൃ • mackerel-plugin-php-fpm, mackerel-client-php ͷ࡞ऀ • Redash Meetup ओ࠵
3. αʔόʔ؂ࢹͷཁૉ • ؂ࢹର৅ϝτϦΫεͷऔಘ • औಘͨ͠ϝτϦΫεͷ஝ੵ • ஝ੵͨ͠ϝτϦΫεͷ؍ଌ • ؍ଌ݁Ռʹجͮ͘௨஌
4. ͜ΕΒΛ OSS Λ૊Έ߹Θͤͯ ࣮ݱͯ͠Έ·͢ Prometheus ΍ NagiosɺMunin ͳͲͷ࿩͸͠·ͤΜ
5. αʔόʔ؂ࢹͷཁૉ • ؂ࢹର৅ϝτϦΫεͷऔಘ -> osquery • औಘͨ͠ϝτϦΫεͷ஝ੵ -> Fluentd • ஝ੵͨ͠ϝτϦΫεͷ؍ଌ -> Redash • ؍ଌ݁Ռʹجͮ͘௨஌ -> Redash
6. ࢖༻͢Δ OSS • osquery / https://osquery.io/ • Facebook ͕ެ։͍ͯ͠Δ OSSɻSQL Ͱ ϝτϦΫεΛऔಘͰ͖Δ • Fluentd / https://www.fluentd.org/ • σʔλΛऩूɾసૹ͢Δͷʹศརͳ OSS ɻ • Redash / https://redash.io/ • ଟ͘ͷσʔλιʔεʹରԠͨ͠ OSS / SaaS ͷ BI πʔϧɻσʔλ ͷऔಘɺՄࢹԽ΍Ξϥʔτػೳ
7. ಈ࡞Πϝʔδ(ՄࢹԽ)
8. ಈ࡞Πϝʔδ(؂ࢹ)
9. ߏ੒Πϝʔδ <- ͪΐͬͱ Python ͰՃ޻
10. OSS Λ૊Έ߹ΘͤΔ͚ͩͰ ؂ࢹγεςϜ͸ࣗ࡞Ͱ͖Δ ΍Βͳ͍͍ͯ͘ͱࢥ͍·͢
11. ࣗ࡞͢Δͷ͸ָ͍͠ ͜ͷ LT ४උΊͪΌͪ͘Όָ͔ͬͨ͠
12. ָ͍͚͠Ͳ
13. IDCF Ϋϥ΢υΛ࢖͏ͳΒ ؂ࢹ͸ Mackerel Ұ୒ IDCF Ϋϥ΢υ x Mackerel ͷྉۚମܥΛࠓ೔஌Γ·ͨ͠
14. IDCF Ϋϥ΢υͱ Mackerel Ͱ ϫΫϫΫ͢Δ։ൃΛʂ