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

by Takuya Arita

Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

ಈ࡞Πϝʔδ(ՄࢹԽ)

Slide 8

Slide 8 text

ಈ࡞Πϝʔδ(؂ࢹ)

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

ָ͍͚͠Ͳ

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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