Slide 1

Slide 1 text

ࠓ͔ΒͰ΋ग़དྷΔ! WebαʔϏεϞχλϦϯά!! 1)1FS,BJHJ

Slide 2

Slide 2 text

No content

Slide 3

Slide 3 text

ࠓ͔ΒͰ΋ग़དྷΔ! WebαʔϏεϞχλϦϯά!! 1)1FS,BJHJ

Slide 4

Slide 4 text

ಉҰͷ಺༰Ͱ͸͋Γ·ͤΜ

Slide 5

Slide 5 text

PHPerͷͨΊͷ WebαʔϏεϞχλϦϯά!!! 1)1FS,BJHJ

Slide 6

Slide 6 text

What is it? ϞχλϦϯάͯ͠·͔͢ʁ

Slide 7

Slide 7 text

What is it? ͳͥϞχλϦϯά͕ඞཁ͔

Slide 8

Slide 8 text

What is it? 1. ૉૣ͘ো֐ʹؾ෇ͨ͘Ί 2. ૉૣ͘ো֐ݪҼΛڀ໌͢ΔͨΊ 3. γεςϜͷৼΔ෣͍Λ༧ଌ͠ɺະવ ʹো֐Λ๷͙ͨΊ Լʹߦ͘΄ͲΑΓਫ਼౓ͷߴ͍؂ࢹ͕ඞཁ

Slide 9

Slide 9 text

What is it? ࠓ೔͸࿩Λ͠ͳ͍͜ͱ

Slide 10

Slide 10 text

What is it? γεςϜϝτϦοΫεͷ࿩ ʢCPUͱ͔Memoryͷ஋ͷݟํʣ

Slide 11

Slide 11 text

http://soudai.hatenablog.com/entry/2017/09/26/080117

Slide 12

Slide 12 text

What is it? σʔλϕʔεͷ؂ࢹͷ࿩

Slide 13

Slide 13 text

ݕࡧϫʔυ ͦʔ͍ͩͳΔΒ͕͖͘ா ʴ PostgreSQLͷ؂ࢹ MySQLͷ؂ࢹ InnoDBͷ؂ࢹ

Slide 14

Slide 14 text

What is it? ࠓ೔͓࿩͢Δ͜ͱ

Slide 15

Slide 15 text

What is it? WebαʔϏεʴPHPͷ؂ࢹ

Slide 16

Slide 16 text

ࠓ͔ΒͰ΋ग़དྷΔ! WebαʔϏεϞχλϦϯά!!!

Slide 17

Slide 17 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹWebαʔϏεΛݟΔ ̏ɹϞχλϦϯάͷצॴ ̐ɹPHPͷϞχλϦϯά ̑ɹ·ͱΊ

Slide 18

Slide 18 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹWebαʔϏεΛݟΔ ̏ɹϞχλϦϯάͷצॴ ̐ɹPHPͷϞχλϦϯά ̑ɹ·ͱΊ

Slide 19

Slide 19 text

ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ33ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿCustomer Reliability Engineering ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹɹ ษڧձ୲౰ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

Slide 20

Slide 20 text

ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ33ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿCustomer Reliability Engineering ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹɹ ษڧձ୲౰ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

Slide 21

Slide 21 text

Mackerel

Slide 22

Slide 22 text

͸ͯͳ͸஥ؒΛ୳ͯ͠·͢ curl -sIL mackerel.io | grep engineer

Slide 23

Slide 23 text

͸ͯͳ͸஥ؒΛ୳ͯ͠·͢ curl -sIL mackerel.io | grep engineer ͜Εͩͱ$3&ग़ͯ͜ͳ͍ͷͰHSFQDSF͍ͯͩ͘͠͞ʂʂ

Slide 24

Slide 24 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹWebαʔϏεΛݟΔ ̏ɹPHPͷϞχλϦϯά ̐ɹϞχλϦϯάͷצॴ ̑ɹ·ͱΊ

Slide 25

Slide 25 text

WebαʔϏεΛݟΔ 8FCαʔϏε͸ੜ͖෺

Slide 26

Slide 26 text

WebαʔϏεΛݟΔ 8FCαʔϏε͸ੜ͖෺ ˣ ͔ͩΒৗʹมԽ͍ͯ͠Δ

Slide 27

Slide 27 text

WebαʔϏεΛݟΔ 8FCαʔϏε͸೉͍͠

Slide 28

Slide 28 text

WebαʔϏεΛݟΔ 8FCαʔϏε͸೉͍͠ ˣ ৭ΜͳཁૉͷӨڹΛड͚Δ

Slide 29

Slide 29 text

WebαʔϏεΛݟΔ ͔ͩΒϞχλϦϯά͕ඞཁ

Slide 30

Slide 30 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ

Slide 31

Slide 31 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ

Slide 32

Slide 32 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ ࠷΋Θ͔Γ΍͍͢ྖҬ ϞχλϦϯά͢Δ͜ͱͰαʔϏεͷঢ়ଶΛ஌Δ

Slide 33

Slide 33 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ ࠷΋Θ͔Γ΍͍͢ྖҬ ϞχλϦϯά͢Δ͜ͱͰαʔϏεͷঢ়ଶΛ஌Δ ϞχλϦϯάʹΑΔޮՌ͕ग़΍͍͢

Slide 34

Slide 34 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ

Slide 35

Slide 35 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ ίϯτϩʔϧͰ͖Δ͕ҙਤ͠ͳ͍͜ͱ΋ଟ͍

Slide 36

Slide 36 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ ίϯτϩʔϧͰ͖Δ͕ҙਤ͠ͳ͍͜ͱ΋ଟ͍ ϞχλϦϯά͠ͳ͍ͱݪҼ௥ٻग़དྷͳ͍

Slide 37

Slide 37 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ

Slide 38

Slide 38 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ զʑͰ͸ίϯτʔϧग़དྷͳ͍ྖҬ

Slide 39

Slide 39 text

%/4 #(1 *41 WebαʔϏεΛݟΔ αʔό ωοτϫʔΫ ΞϓϦέʔγϣϯ ௨৴͸ৗʹԟདྷ͍ͯ͠Δ ΫϥΠΞϯτ Πϯλʔωοτ αʔόαΠυ զʑͰ͸ίϯτʔϧग़དྷͳ͍ྖҬ ͔ͩΒͦ͜ϞχλϦϯά͕େࣄ

Slide 40

Slide 40 text

WebαʔϏεΛݟΔ αʔόαΠυ w 04 w ωοτϫʔΫ w ϛυϧ΢ΣΞ w ΞϓϦέʔγϣϯʜFUD

Slide 41

Slide 41 text

WebαʔϏεΛݟΔ ΞϓϦέʔγϣϯ w ϓϩηε w εϨου w 'SBNFXPSL w ϩδοΫʜFUD

Slide 42

Slide 42 text

WebαʔϏεΛݟΔ ΫϥΠΞϯταΠυ w ϒϥ΢β w +BWB4DSJQU w ϓϩτίϧ w ωοτϫʔΫʜFUD

Slide 43

Slide 43 text

WebαʔϏεΛݟΔ Πϯλʔωοτ w ϨΠςϯγʔ w εϧʔϓοτ w ϨεϙϯεʜFUD

Slide 44

Slide 44 text

WebαʔϏεΛݟΔ ͦΕͧΕͷৼΔ෣͍ΛՄࢹԽ͢Δ

Slide 45

Slide 45 text

WebαʔϏεΛݟΔ

Slide 46

Slide 46 text

WebαʔϏεΛݟΔ 8FCαʔϏε͸ੜ͖෺

Slide 47

Slide 47 text

WebαʔϏεΛݟΔ 8FCαʔϏε͸ੜ͖෺ ˣ αʔϏεࣗମ΋ՄࢹԽ͢Δ

Slide 48

Slide 48 text

WebαʔϏεΛݟΔ αʔϏεͷՄࢹԽ w 17΍๚໰਺ w μ΢ϯϩʔυ਺ w Ϣʔβͷར༻ྔ w Ϋϥ΢υྉۚͷ՝ۚྔʜFUD

Slide 49

Slide 49 text

WebαʔϏεΛݟΔ

Slide 50

Slide 50 text

WebαʔϏεΛݟΔ αʔϏεͷมԽ͸ γεςϜͷมԽͱ૬ؔ

Slide 51

Slide 51 text

WebαʔϏεΛݟΔ ͔ͩΒ8FCαʔϏεΛݟΔ

Slide 52

Slide 52 text

WebαʔϏεΛݟΔ ͔ͩΒ8FCαʔϏεΛݟΔ ˣ ϞχλϦϯά͢Δ

Slide 53

Slide 53 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹWebαʔϏεΛݟΔ ̏ɹϞχλϦϯάͷצॴ ̐ɹPHPͷϞχλϦϯά ̑ɹ·ͱΊ

Slide 54

Slide 54 text

ϞχλϦϯάͷצॴ ஌Γ͍ͨ͜ͱ͸Կͳͷ͔ʁ

Slide 55

Slide 55 text

ϞχλϦϯάͷצॴ ஌Γ͍ͨ͜ͱ͸Կͳͷ͔ʁ ˣ αʔϏε͕ਖ਼͘͠ಈ͍͍ͯΔ͔

Slide 56

Slide 56 text

ϞχλϦϯάͷצॴ γεςϜͷϞχλϦϯά͸ ϦιʔεΛਖ਼͘͠࢖͑ͯΔ͔

Slide 57

Slide 57 text

ϞχλϦϯάͷצॴ γεςϜͷϞχλϦϯά͸ ϦιʔεΛਖ਼͘͠࢖͑ͯΔ͔ Ϧιʔε͕ෆ଍ͯ͠΋༨Βͯ͠΋ବ໨

Slide 58

Slide 58 text

ϞχλϦϯάͷצॴ ҙਤ͠ͳ͍ڍಈʹؾ෇͘

Slide 59

Slide 59 text

ϞχλϦϯάͷצॴ αʔϏεͷมԽͷػඍʹؾ෇͘

Slide 60

Slide 60 text

ϞχλϦϯάͷצॴ αʔϏεͷมԽͷػඍʹؾ෇͘ ˣ มԽͷࠩ෼͕͋Δ͔Βؾ෇͚Δ

Slide 61

Slide 61 text

ϞχλϦϯάͷצॴ ౿ΈࠐΜͩγεςϜͷՄࢹԽ w ࣮ߦCBUDIͷδϣϒ਺ w Ωϡʔ਺ w อଘ͞ΕͯΔը૾਺ w %/4΍/51ͷঢ়ଶ

Slide 62

Slide 62 text

ϞχλϦϯάͷצॴ ౿ΈࠐΜͩαʔϏεͷՄࢹԽ w ϢʔβͷϓϨΠঢ়گ w Πϯετʔϧ͞Εͨ04 w Ϣʔβͷݕࡧϫʔυ w ਃ͠ࠐΈϘλϯͷΫϦοΫ਺

Slide 63

Slide 63 text

ϞχλϦϯάͷצॴ γεςϜͷঢ়ଶΛՄࢹԽ͢Δ

Slide 64

Slide 64 text

ϞχλϦϯάͷצॴ αʔϏεͷৼΔ෣͍ΛՄࢹԽ͢Δ

Slide 65

Slide 65 text

ϞχλϦϯάͷצॴ ୭΋ݟͳ͍άϥϑʹҙຯ͸ແ͍

Slide 66

Slide 66 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹWebαʔϏεΛݟΔ ̏ɹϞχλϦϯάͷצॴ ̐ɹPHPͷϞχλϦϯά ̑ɹ·ͱΊ

Slide 67

Slide 67 text

PHPͷϞχλϦϯά 1)1ͷৼΔ෣͍Λ஌Δ

Slide 68

Slide 68 text

PHPͷϞχλϦϯά 1)1ͷৼΔ෣͍Λ஌Δ ˣ ਖ਼͠͞Λ஌Βͳ͍ͱ ؒҧ͍ʹؾ෇͚ແ͍

Slide 69

Slide 69 text

PHPͷϞχλϦϯά 1)1ͷ࢓૊ΈΛ஌Δ

Slide 70

Slide 70 text

PHPͷϞχλϦϯά ϓϩηεͱ1)1

Slide 71

Slide 71 text

PHPͷϞχλϦϯά Πϕϯτͱ1)1

Slide 72

Slide 72 text

PHPͷϞχλϦϯά ೥8FCαʔόΞʔΩςΫνϟং࿦ Ώ͏͏͖ϒϩά IUUQCMPHZVVLJPFOUSZXFCTFSWFSBSDIJUFDUVSF

Slide 73

Slide 73 text

PHPͷϞχλϦϯά 1)1ͱΩϟογϡ

Slide 74

Slide 74 text

PHPͷϞχλϦϯά 01$BDIFͱ"1$V

Slide 75

Slide 75 text

PHPͷϞχλϦϯά 01$BDIFίʔυΩϟογϡ "1$VσʔλΩϟογϡ

Slide 76

Slide 76 text

PHPͷϞχλϦϯά Ͳ͏΍ͬͯݟΔ͔ʁ

Slide 77

Slide 77 text

PHPͷϞχλϦϯά "1$Vίϯτϩʔϧύωϧ IUUQTHJUIVCDPNLSBLKPFBQDV

Slide 78

Slide 78 text

PHPͷϞχλϦϯά 0QDBDIF$POUSPM1BOFM IUUQTHJTUHJUIVCDPNDLPO

Slide 79

Slide 79 text

PHPͷϞχλϦϯά "QBDIF "QBDIF4FSWFS4UBUVT

Slide 80

Slide 80 text

PHPͷϞχλϦϯά /(*/9 OHJOY@TUBUVT

Slide 81

Slide 81 text

PHPͷϞχλϦϯά ݕࡧϫʔυ ͦʔ͍ͩͳΔམॻ͖ா ʴ "QBDIFcc/(*/9 ͷ؂ࢹ

Slide 82

Slide 82 text

PHPͷϞχλϦϯά ͜ΕΒͷαʔϏεΛݟΔ

Slide 83

Slide 83 text

PHPͷϞχλϦϯά ͜ΕΒͷαʔϏεΛݟΔ ˣ ৗʹݟଓ͚ΔΘ͚ʹ͸ߦ͔ͳ͍

Slide 84

Slide 84 text

PHPͷϞχλϦϯά ࣌ܥྻͰσʔλΛ࣋ͭ

Slide 85

Slide 85 text

PHPͷϞχλϦϯά ࣌ܥྻͰσʔλΛ࣋ͭ ˣ ͦͷมԽΛఆظతʹݟΔ

Slide 86

Slide 86 text

ϞχλϦϯάͷצॴ ౿ΈࠐΜͩγεςϜͷՄࢹԽ w ࣮ߦCBUDIͷδϣϒ਺ w Ωϡʔ਺ w อଘ͞ΕͯΔը૾਺ w %/4΍/51ͷঢ়ଶ

Slide 87

Slide 87 text

ϞχλϦϯάͷצॴ ౿ΈࠐΜͩγεςϜͷՄࢹԽ w ࣮ߦCBUDIͷδϣϒ਺ w Ωϡʔ਺ w อଘ͞ΕͯΔը૾਺ w %/4΍/51ͷঢ়ଶ 1)1͕࢖͏ϝϞϦྔ΍࣮ߦ࣌ؒ΋ؾʹͳΔ

Slide 88

Slide 88 text

ϞχλϦϯάͷצॴ ౿ΈࠐΜͩγεςϜͷՄࢹԽ w ࣮ߦCBUDIͷδϣϒ਺ w Ωϡʔ਺ w อଘ͞ΕͯΔը૾਺ w %/4΍/51ͷঢ়ଶ ը૾αΠζͷ߹ܭ͕NFNPSZ@MJNJUʹऩ·Δʁ

Slide 89

Slide 89 text

ϞχλϦϯάͷצॴ ౿ΈࠐΜͩαʔϏεͷՄࢹԽ w ϢʔβͷϓϨΠঢ়گ w Πϯετʔϧ͞Εͨ04 w Ϣʔβͷݕࡧϫʔυ w ਃ͠ࠐΈϘλϯͷΫϦοΫ਺

Slide 90

Slide 90 text

ϞχλϦϯάͷצॴ ౿ΈࠐΜͩαʔϏεͷՄࢹԽ w ϢʔβͷϓϨΠঢ়گ w Πϯετʔϧ͞Εͨ04 w Ϣʔβͷݕࡧϫʔυ w ਃ͠ࠐΈϘλϯͷΫϦοΫ਺ "QBDIFͷNBYDMJFOUT͸௒͑ͳ͍ʁ

Slide 91

Slide 91 text

ϞχλϦϯάͷצॴ ౿ΈࠐΜͩαʔϏεͷՄࢹԽ w ϢʔβͷϓϨΠঢ়گ w Πϯετʔϧ͞Εͨ04 w Ϣʔβͷݕࡧϫʔυ w ਃ͠ࠐΈϘλϯͷΫϦοΫ਺ ͲΕ͘Β͍ͷ42-͕࣮ߦ͞ΕΔʁ

Slide 92

Slide 92 text

PHPͷϞχλϦϯά 1)1ͱαʔϏεͷৼΔ෣͍͸ දཪҰମ

Slide 93

Slide 93 text

PHPͷϞχλϦϯά ͔ͩΒͦ͜ϞχλϦϯά͢Δ

Slide 94

Slide 94 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹWebαʔϏεΛݟΔ ̏ɹϞχλϦϯάͷצॴ ̐ɹPHPͷϞχλϦϯά ̑ɹ·ͱΊ

Slide 95

Slide 95 text

·ͱΊ ·ͣ͸ՄࢹԽΛ͢Δ

Slide 96

Slide 96 text

·ͱΊ μΠΤοτ΋ମॏܭʹ৐Δ͠ɺ ݈߁਍அ΋݂ѹͳͲΛܭଌ͢Δ

Slide 97

Slide 97 text

·ͱΊ μΠΤοτ΋ମॏܭʹ৐Δ͠ɺ ݈߁਍அ΋݂ѹͳͲΛܭଌ͢Δ 8FCαʔϏε΋Ұॹ

Slide 98

Slide 98 text

·ͱΊ ਪଌΑΓܭଌ

Slide 99

Slide 99 text

·ͱΊ ਪଌΑΓܭଌ ↓ ܭଌΑΓ؍ଌ

Slide 100

Slide 100 text

·ͱΊ ࣄ࣮ΛΑΓଟ͘ɺਖ਼͘͠஌Δ͜ͱͰ ະདྷΛਖ਼͘͠༧ଌͰ͖Δ

Slide 101

Slide 101 text

https://papix.hatenablog.com/entry/2018/03/03/112532

Slide 102

Slide 102 text

No content

Slide 103

Slide 103 text

·ͱΊ ΤϯδχΞʹ͸ࠜڌ͕ඞཁ

Slide 104

Slide 104 text

·ͱΊ ΤϯδχΞʹ͸ࠜڌ͕ඞཁ ↓ ͳΜͱͳ͘Ͱ࢓ࣄ͸ग़དྷͳ͍

Slide 105

Slide 105 text

·ͱΊ

Slide 106

Slide 106 text

·ͱΊ

Slide 107

Slide 107 text

·ͱΊ

Slide 108

Slide 108 text

·ͱΊ ςετίʔυ͸ϓϩάϥϜͷ඼࣭ͷՄࢹԽ ϞχλϦϯά͸αʔϏεͷ඼࣭ͷՄࢹԽ

Slide 109

Slide 109 text

·ͱΊ lߴ౓ʹൃୡͨ͠γεςϜͷҟৗ͸ ਆͷౖΓͱݟ෼͚͕͔ͭͳ͍z ŠZ@VVLJ

Slide 110

Slide 110 text

·ͱΊ ମॏܭʹ৐Δ͚ͩͰ͸૫ͤͳ͍

Slide 111

Slide 111 text

·ͱΊ ମॏܭʹ৐Δ͚ͩͰ͸૫ͤͳ͍ ↓ ඼࣭ΛՄࢹԽ͚ͨͩ͠Ͱ͸վળ͸͞Εͳ͍

Slide 112

Slide 112 text

·ͱΊ ΠνϩʔͷόοτΛ࢖ͬͯ΋ Πνϩʔʹ͸ͳΕͳ͍

Slide 113

Slide 113 text

·ͱΊ lखΛಈ͔ͨ͠ਓ͚͕ͩੈքΛม͑Δz Š:BTVIJSP0OJTIJ

Slide 114

Slide 114 text

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ