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

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 Ͱ ϫΫϫΫ͢Δ։ൃΛʂ