AWS で実現した Mackerel 時系列データ1分粒度長期保存の裏側 / Mackerel Meetup #11 Tokyo

81e8ac1d3a766b3d9880cd08d9a7aba4?s=47 astj
PRO
February 05, 2018
Technology
6
21k

AWS で実現した Mackerel 時系列データ1分粒度長期保存の裏側 / Mackerel Meetup #11 Tokyo

2018/02/05 https://mackerelio.connpass.com/event/76678/

81e8ac1d3a766b3d9880cd08d9a7aba4?s=128

astj
PRO

February 05, 2018
Tweet

More Decks by astj

See All by astj
81e8ac1d3a766b3d9880cd08d9a7aba4?s=48 astj
PRO
3
3.1k
81e8ac1d3a766b3d9880cd08d9a7aba4?s=48 astj
PRO
1
740
81e8ac1d3a766b3d9880cd08d9a7aba4?s=48 astj
PRO
2
940
81e8ac1d3a766b3d9880cd08d9a7aba4?s=48 astj
PRO
1
630
81e8ac1d3a766b3d9880cd08d9a7aba4?s=48 astj
PRO
0
3.8k
81e8ac1d3a766b3d9880cd08d9a7aba4?s=48 astj
PRO
0
560
81e8ac1d3a766b3d9880cd08d9a7aba4?s=48 astj
PRO
0
6.2k
81e8ac1d3a766b3d9880cd08d9a7aba4?s=48 astj
PRO
0
3.4k

Other Decks in Technology

See All in Technology
F082484f19b518225501fafa28d05b93?s=48 greymd
0
600
9e7a653ed313b3da4b263a772bfc5026?s=48 clustervr
0
180
9ea422a61c1a69c888786830eee3dbe6?s=48 osonoi
0
160
D99b232749259de3083102b4b32199bc?s=48 ray_30cm_ns
0
270
510ec964f5d26c2724c883fd7b671e3d?s=48 cygames
1
330
19fc8f6113c5c3d86e6176362ff29479?s=48 kanaugust
PRO
0
140
56d7bcf9b5071512c65e753a1619987a?s=48 kakka
0
3.3k
E783e2d26dc6388730b73ced1348c638?s=48 vkbaba
0
100
Da40bdb49bfb7a3fc9426dacac78a99c?s=48 ama_ch
0
3.3k
706ff501573a736401aa4de5adc88e05?s=48 nihonbuson
2
1.5k
33d6320b53f63f6627508095633cf5ce?s=48 yosuke_matsuura
PRO
0
3.2k
098ad475722e3697ec2fba28c8654f9f?s=48 yuhta28
1
190

Featured

See All Featured
2bb923c57a1fdc3a2eb484bb8d565fd2?s=48 ufuk
56
5.4k
766b9746b59e6f09e280cd33cf4ed419?s=48 skipperchong
7
660
1b8ad785acdd1ce1c99914b1c2a4e10e?s=48 sugarenia
233
830k
3d6ace9554821d552146413bcdf874f6?s=48 trishagee
20
2k
A16eb159db895e3b01d3dc95767ad595?s=48 jonyablonski
14
1.1k
A9704266587836f7e784235e5073b93e?s=48 jmmastey
8
530
C7393b7ba7ec9c8890dd77d209fbb3c9?s=48 maltzj
500
36k
1519587b1a0febb658c36c94f6272b0d?s=48 roundedbygravity
84
7.8k
D47656e20ff5e42f125fc5ea0fd636c6?s=48 tmm1
61
8.3k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
55
5.4k
44b54d2ffcb7857004071cc6795dde11?s=48 cassininazir
347
20k
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
145
19k

Transcript

  1. "84Ͱ࣮ݱͨ͠.BDLFSFM ࣌ܥྻσʔλ෼ཻ౓௕ظอଘͷཪଆ  .BDLFSFM.FFUVQ5PLZP JEBTUKʢגࣜձࣾ͸ͯͳʣ

  2. w ͸ͯͳΞϓϦέʔγϣϯΤϯδχΞ w ͸ͯͳϒοΫϚʔΫ͸ͯͳϒϩάFUDʜ w डୗαʔϏε w .BDLFSFM d 

    w αʔόαΠυΤʔδΣϯτத৺ JEBTUK

  3. w NBDLFSFMBHFOUTZTUFNEରԠ w NBDLFSFMQMVHJOBXT ͍͔ͭ͘ w -*/&5XJMJP࿈ܞ w "84Ҡߦ࣌ܥྻσʔλϕʔεͷ࡮৽ w

    ࣌ܥྻσʔλ෼ཻ౓௕ظอଘ w ؂ࢹϧʔϧͷૢ࡞Λ௨஌νϟϯωϧʹ௨஌ w ʜ JEBTUK

  4. ຊ೔ͷ࿩୊

  5. w .BDLFSFM࣌ܥྻ%#ͷ঺հ w ෼ཻ౓௕ظอଘͷٕज़എܠ w αʔόϨεϛυϧ΢ΣΞͷߏஙࣄྫ w %ZOBNP%#4USFBNT -BNCEB w

    ߴεϧʔϓοτ4ॻ͖ࠐΈ

  6. લఏ

  7. ࣌ܥྻσʔλ

  8. ࣌ܥྻσʔλ hatena.mackerel.host1.cpu.user 2018/02/01T21:15:00Z 44.00 2018/02/01T21:16:00Z 6.00 2018/02/05T21:17:00Z 8.00 … …

  9. ࣌ܥྻσʔλϕʔε hatena.mackerel.host1.cpu.user 2018/02/01T21:15:00Z 44.00 2018/02/01T21:16:00Z 6.00 2018/02/05T21:17:00Z 8.00 hatena.mackerel.host1.cpu.user 2018/02/01T21:15:00Z

    44.00 2018/02/01T21:16:00Z 6.00 2018/02/05T21:17:00Z 8.00 hatena.mackerel.host1.cpu.user 2018/02/01T21:15:00Z 44.00 2018/02/01T21:16:00Z 6.00 2018/02/05T21:17:00Z 8.00 hatena.mackerel.host1.cpu.user 2018/02/01T21:15:00Z 44.00 2018/02/01T21:16:00Z 6.00 2018/02/05T21:17:00Z 8.00 … …

  10. http://blog.yuuk.io/entry/the-rebuild-of-tsdb-on-cloud

  11. None

  12. NI NE IE   #FGPSF E

  13. NE NE IE E   "GUFS

  14. None

  15. .BDLFSFMͷ ࣌ܥྻσʔλϕʔε

  16. Ҡߦલ(SBQIJUF IUUQTHSBQIJUFBQQPSH

  17. http://blog.yuuk.io/entry/high-performance-graphite

  18. ҠߦޙEJBNPOE ಺੡ίʔυωʔϜ

  19. IUUQCMPHZVVLJPFOUSZUIFSFCVJMEPGUTECPODMPVE ࣌ܥྻσʔλϕʔεͱ͍͏֓೦ΛΫϥ΢υͷٕͰ࠶ߏங͢Δ

  20. IUUQJUDIZOZIBUFOBCMPHDPNFOUSZ 4FSWFSMFTTDPOG5PLZPͰʰαʔόϨεΞʔΩςΫνϟʹ ΑΔ࣌ܥྻσʔλϕʔεͷߏஙͱ؂ࢹʱͱ͍͏ൃද͖ͯ͠·ͨ͠

  21. http://blog.yuuk.io/entry/the-rebuild-of-tsdb-on-cloud 3FEJT$MVTUFS &$

  22. ίϯηϓτ w εέʔϧ͢ΔΞʔΩςΫνϟ w ϚωʔδυαʔϏεʹΑΔӡ༻লྗԽ w ΞΫηεಛੑʹԠͨ͡֊૚ܕσʔλετΞ w 3FEJT %ZOBNP%#

    4

  23. ετϨʔδ *0ίετ ϨΠςϯγ ༰ྔίετ 3FEJT ˕ ˕ ˚ %ZOBNP%# ˓

    ˓ ˓ 4 ˚ ˚ ˕ σʔλετϨʔδ

  24. %ZOBNP%# w ϑϧϚωʔδυ/P42- w ҆ఆɾߴύϑΥʔϚϯεɾεέʔϥϏϦςΟ w खࠒͳίετ w σʔλ༰ྔɺεϧʔϓοτ w

    ʢͱ͸͍͑අ༻Λແࢹ͸Ͱ͖ͳ͍ʣ

  25. 3FEJT $MVTUFS w ΠϯϝϞϦ,74 w *0ίετ͕ %ZOBNP%#ΑΓ खܰ w σʔλྔΛࡹͨ͘Ί3FEJT$MVTUFS

    w ࠓͷͱ͜Ζ&$

  26. 4 w ,74తʹར༻ w ༰ྔίετ͸ඇৗʹ཈͑ΒΕΔ w ϨΠςϯγɾ*0ίετ͸ྼΔ w ॻ͖ࠐΈճ਺ΛݮΒ͍ͨ͠

  27. w %ZOBNP%# w ϝΠϯ w 3FEJT w ߋ৽ϦΫΤετΛݮΒͨ͢ΊͷόοϑΝ w 4

    w طଘͷอ࣋ظؒͰ͸ ར༻͠ͳ͍ ֊૚ܕσʔλετΞ 

  28. NI NE IE   ֊૚ܕσʔλετΞ  %ZOBNP%# 3FEJT E

  29. ෼ཻ౓ͷ௕ظอଘ

  30. w σʔλྔ͕େ͖͘๲ΒΉ ഒ  w ݹ͍σʔλͷϨΠςϯγཁ݅͸গ͠؇͍ w ৽͍͠σʔλ΄Ͳසൟʹ͸ࢀর͞Εͳ͍ w ݹ͍σʔλͷ্ॻ͖ߋ৽͸ൃੜ͠ͳ͍

  31. w ݹ͍σʔλΛ4ʹ഑ஔ w طଘͷอ࣋ظؒͷύϑΥʔϚϯεΛҡ࣋ w ॻ͖ࠐΈճ਺ΛݮΒ͢ ֊૚ܕσʔλετΞ 

  32. NE NE IE   ֊૚ܕσʔλετΞ  %ZOBNP%# 3FEJT 4

    E
  33. None

  34. 55-&YQJSF %ZOBNP%# %%#4USFBN -BNCEB 4 1VU0CKFDU

  35. %ZOBNP%#55-

  36. %ZOBNP%#ͷΞΠςϜ͝ͱʹ༗ޮظݶ 55- Λࢦఆͯ͠ɺࣗಈతʹ࡟আͤ͞Δ

  37. %ZOBNP%# hatena.mackerel.host1.cpu.user 2018/02/03 00:00~03:59 ExpireAt: 2018/02/04 05:00 2018/02/02 16:00~19:59 ExpireAt:

    2018/02/03 21:00 hatena.mackerel.host1.cpu.user 2018/02/03 04:00~07:59 ExpireAt: 2018/02/04 09:00 hatena.mackerel.host1.cpu.user hatena.mackerel.host1.cpu.user 2018/02/02 20:00~23:59 ExpireAt: 2018/02/04 01:00

  38. %ZOBNP%# hatena.mackerel.host1.cpu.user 2018/02/03 00:00~03:59 ExpireAt: 2018/02/04 05:00 hatena.mackerel.host1.cpu.user 2018/02/03 04:00~07:59

    ExpireAt: 2018/02/04 09:00 hatena.mackerel.host1.cpu.user hatena.mackerel.host1.cpu.user 2018/02/02 20:00~23:59 ExpireAt: 2018/02/04 01:00

  39. %ZOBNP%# hatena.mackerel.host1.cpu.user 2018/02/03 00:00~03:59 ExpireAt: 2018/02/04 05:00 hatena.mackerel.host1.cpu.user 2018/02/03 04:00~07:59

    ExpireAt: 2018/02/04 09:00 hatena.mackerel.host1.cpu.user

  40. hatena.mackerel.host1.cpu.user 2018/02/03 04:00~07:59 ExpireAt: 2018/02/04 09:00 hatena.mackerel.host1.cpu.user %ZOBNP%#

  41. %ZOBNP%# hatena.mackerel.host1.cpu.user

  42. %ZOBNP%#

  43. ೳಈతͳૢ࡞ͳ͘%ZOBNP%#্ͷ ϨίʔυΛ࡟আͰ͖Δ

  44. %ZOBNP%#4USFBNT

  45. w %ZOBNP%#্ͷΞΠςϜߋ৽͕
 Πϕϯτͱͯ͠ྲྀΕΔετϦʔϜ w ςʔϒϧͷσʔλมߋΛτϦΨʹ
 -BNCEBؔ਺ΛىಈͰ͖Δ w ϖΠϩʔυʹมߋલޙͷΞΠςϜ಺༰Λ
 ؚΊΔ͜ͱ͕Ͱ͖Δ

  46. %ZOBNP%# 4USFBN -BNCEB ৽نΞΠςϜ௥Ճ طଘΞΠςϜߋ৽ ΞΠςϜ࡟আ

  47. EJBNPOEFYQPSUFS %ZOBNP%#55-  %ZOBNP%#4USFBNT

  48. w 55-ʹ౸ୡͨ͠ΞΠςϜͷ࡟আ࣌ʹ
 ΞΠςϜͷ಺༰Λ౉ͯ͠-BNCEBؔ਺Λ ىಈ w -BNCEBؔ਺Ͱ4ʹॻ͖ग़͠

  49. ͜ͷΞΠςϜ͕55-ʹ౸ୡͯ͠
 ࡟আ͞Ε·ͨ͠ hatena.mackerel.host1.cpu.user 2018/02/01T21:15:00Z 44.00 2018/02/01T21:16:00Z 6.00 2018/02/05T21:17:00Z 8.00 …

    … hatena.mackerel.host1.cpu.user 2018/02/01T21:15:00Z 44.00 2018/02/01T21:16:00Z 6.00 2018/02/05T21:17:00Z 8.00 … …

  50. hatena.mackerel.host1.cpu.user 2018/02/01T21:15:00Z 44.00 2018/02/01T21:16:00Z 6.00 2018/02/05T21:17:00Z 8.00 … …

  51. 55-&YQJSF %ZOBNP%# %%#4USFBN -BNCEB 4 1VU0CKFDU

  52. 55-&YQJSF %ZOBNP%# %%#4USFBN -BNCEB 4 1VU0CKFDU w ϝτϦοΫ͝ͱO࣌ؒ͝ͱʹΞΠςϜ w %ZOBNP%#ͷΞΠςϜʹ55-Λઃఆ

    w 55-ܦաʹΑΓΞΠςϜ࡟আ w ΞΠςϜ࡟আΠϕϯτ͕4USFBNʹ௨஌ w 4USFBN͔Β-BNCEBؔ਺ىಈ w -BNCEBؔ਺͕ΞΠςϜΛ4ʹॻࠐ

  53. 55-&YQJSF %ZOBNP%# %%#4USFBN -BNCEB 4 1VU0CKFDU w 55-෇༩Ҏ֎ͷ ೳಈతͳૢ࡞͕ෆཁ w

    -BNCEBͷࣦഊ࣌ϦτϥΠ΋ࣗಈ w 4USFBNҎ֎ʹঢ়ଶΛ࣋ͨͳ͍ w %ZOBNP%#ΞΠςϜ4Φϒ δΣΫτ

  54. 4 EJBNPOE"11 NBDLFSFM"11 (FU0CKFDU )551 )551

  55. γϯϓϧ

  56. "84ͷΞοϓσʔτʹΑ࣮ͬͯݱ

  57. ೥ͷ%ZOBNP%#Ξοϓσʔτ w 55-d w "VUP4DBMF %"9d w 71$&OEQPJOUd w (MPCBM5BCMFT

    ΦϯσϚϯυόοΫΞοϓd

  58. 4΁ͷߴස౓ॻ͖ࠐΈ

  59. w 4΁ͷߴස౓ॻ͖ࠐΈΛߦ͏৔߹͸ରԠ͕ඞཁ w ಺෦γϟʔσΟϯάରԠͷͨΊͷQSFpY෇༩ w ٸܹͳ૿Ճͷ৔߹͸ "84αϙʔτܦ༝Ͱͷ
 ࣄલରԠґཔ

  60. Amazon S3 όέοτͷϫʔΫϩʔυ͕ຖඵ 100 ճͷ PUT/LIST/DELETE ϦΫΤετ·ͨ͸ຖඵ 300 ճͷ GET

    ϦΫΤετΛසൟʹ௒͑Δ৔߹ ͸ɺ࠷ߴͷύϑΥʔϚϯεͱεέʔϥϏϦςΟ Λ֬อ͢ΔͨΊɺ͜ͷτϐοΫͷΨΠυϥΠϯ ʹै͍ͬͯͩ͘͞ɻ ϦΫΤετ཰͓ΑͼϦΫΤετύϑΥʔϚϯεʹؔ͢Δཹҙࣄ߲ https://docs.aws.amazon.com/ja_jp/AmazonS3/latest/dev/request- rate-perf-considerations.html

  61. EJBNPOEͰ4΁ͷॻ͖ࠐΈ͸ίϯελϯτʹൃੜ SQT͸༏ʹ௒͑Δ

  62. 55-&YQJSF %ZOBNP%# %%#4USFBN -BNCEB 4 1VU0CKFDU w ϝτϦοΫ͝ͱO࣌ؒ͝ͱʹΞΠςϜ w %ZOBNP%#ͷΞΠςϜʹ55-Λઃఆ

    w 55-ܦաʹΑΓΞΠςϜ࡟আ w ΞΠςϜ࡟আΠϕϯτ͕4USFBNʹ௨஌ w 4USFBN͔Β-BNCEBؔ਺ىಈ w -BNCEBؔ਺͕ΞΠςϜΛ4ʹॻࠐ ࠶ܝ

  63. 55-&YQJSF %ZOBNP%# %%#4USFBN -BNCEB 4 1VU0CKFDU w 55-෇༩Ҏ֎ͷ ೳಈతͳૢ࡞͕ෆཁ w

    -BNCEBͷࣦഊ࣌ϦτϥΠ΋ࣗಈ w %ZOBNP%#ͷΞΠςϜ4Φϒ δΣΫτ ࠶ܝ

  64. ϦΫΤετ཰͓ΑͼϦΫΤετύϑΥʔϚϯεʹؔ͢Δཹҙࣄ߲ https://docs.aws.amazon.com/ja_jp/AmazonS3/latest/dev/request- rate-perf-considerations.html

  65. w ΦϒδΣΫτ໊ઌ಄ʹ.%ϋογϡͷ෇༩ w ॻ͖ࠐΈ։࢝લʹαϙʔτʹରԠΛґཔ w ਺೔Φʔμʔͷ଴͕ͪ࣌ؒൃੜ͢Δ

  66. ա৒ͳϖʔεͰͷߋ৽͸)551YYΤϥʔ͕ ൃੜ͢ΔʢΒ͍͠ʣ ϞχλϦϯάʂ

  67. "844ͷϞχλϦϯά

  68. w 4ͷඪ४$MPVE8BUDI.FUSJDT͸ݶఆత w όέοτͷ೔࣍ͷετϨʔδϝτϦΫε w ϦΫΤετͷ෼ੳ͸Ͱ͖ͳ͍ w ΦϓγϣϯͰϦΫΤετͷϞχλϦϯά΋Մೳ w 4όέοτͷઃఆͰ༗ޮʹͰ͖Δ

    https://docs.aws.amazon.com/ja_jp/AmazonS3/latest/dev/ cloudwatch-monitoring.html
  69. None

  70. $MPVE8BUDI.BDLFSFM

  71. mackerel-plugin-aws-s3-requests [plugin.metrics.diamond-s3] command = "/path/to/mackerel-plugin-aws-s3-requests --bucket- name=XXX --region=ap-northeast-1 --filter-id YYY"

    ެࣜϓϥάΠϯͱͯ͠ϦϦʔε༧ఆ ͖ͬͱࠓिதʹ͸ʜ
  72. None

  73. w (FU 1VUͦΕͧΕͷϦΫΤετ਺ w ୹ظతͳόʔετɺ௕ظతͳτϨϯυ w YYΤϥʔͷ਺ ؂ࢹϧʔϧ

  74. ͓ΘΓʹ

  75. w ࣌ܥྻσʔλ෼ཻ౓௕ظอଘͷ಺෦࣮૷ w ߴස౓4ॻ͖ࠐΈ w ཹҙࣄ߲ϞχλϦϯά

  76. ༗Γ೉͏͍͟͝·ͨ͠ʂ