Slide 1

Slide 1 text

ΤΩαΠτϒϩά࡮৽ʹ޲͚ͯ ংষ - APIΛҰͭʹ

Slide 2

Slide 2 text

໨࣍ 1. ໨࣍ 2. ࣗݾ঺հ 3. ୲౰͢Δ࢓ࣄ 4. લʹਐΉͨΊʹϦϏϧυ 5. ؅ཧը໘͕4ͭ͋Δ? 6. web໘͕4ͭ͋Δ? 7. api͕2ͭ͋Δ? 8. DBͷ਺चͭͳ͗ߏ੒?? 9. ετΞυϓϩγʔδϟʔ?? 10. ·ͱΊ 11. DBͷ઀ଓΛapiʹҰຊԽ

Slide 3

Slide 3 text

ࣗݾ঺հ 2011/03 ෱Ԭେֶଔۀ 2011/04 தখSIer 2015/01 ্৔webܥ 2020/10 ΤΩαΠτೖࣾ ...ࠓʹࢸΔ தඌਖ਼߶(33ࡀ) όοΫΤϯυΤϯδχΞ ಛٕɿϩʔυόΠΫ झຯɿےτϨ - ϕϯνϓϨεɿ70kg - εΫϫοτɿ100kg - σουϦϑτɿ????

Slide 4

Slide 4 text

୲౰͢Δ࢓ࣄ ΤΩαΠτϒϩάͷӡ༻։ൃ͕ϝΠϯ Ͱ͢ɻ 2006೥͔Βελʔτ͍ͯ͠ΔαʔϏ εΛεέʔϧ͍ͤͯ͘͞ɻ

Slide 5

Slide 5 text

લʹਐΉͨΊʹϦϏϧυ ● ϦϏϧυͷ໨త ○ γεςϜͷߏ੒Λγϯϓϧʹɺࠓޙͷ௥Ճ։ൃΛ؆୯ʹʂ

Slide 6

Slide 6 text

લʹਐΉͨΊʹϦϏϧυ ● 1ϲ݄ͰγεςϜ֓ཁΛཧղ͢Δɻ ● 1ϲ݄ͰγεςϜͷ໰୊఺Λ೺Ѳ͢Δɻ ● 1ϲ݄ͰγεςϜͷվળํ๏Λߟ͑Δɻ ● ൒೥Ͱվળ/࣮ݱ͢Δʂ ݱ࣮͸աࠅͳΓɻɻɻ

Slide 7

Slide 7 text

؅ཧը໘͕4ͭ͋Δ???? ● چچ؅ཧը໘ ○ ࠷ݹͷ؅ཧը໘ɻ༗ࣝऀ͕͓Βͣɺϝϯςφϯε͕Ͱ͖ͳ͍ɻ ● چ؅ཧը໘ ○ Ұ൪ػೳ͕ͨ͘͞Μ͋ΔɻphpͷಠࣗϑϨʔϜϫʔΫͰ࣮૷͞Ε͍ͯΔɻ ● ৽؅ཧը໘ ○ ϞμϯͳσβΠϯͰͰ͖͍ͯΔɻLaravelͰ࣮૷͞Ε͍ͯΔɻ ● ύτϩʔϧ؅ཧը໘ ○ ͪΐͬͱφΠʔϒͳ৘ใΛѻ͑ΔɻphpͷಠࣗϑϨʔϜϫʔΫͰ࣮૷͞Ε͍ͯΔɻ

Slide 8

Slide 8 text

͜Μͳۀ຿͕ ͋Γ·ͨ͠ 1. چچ؅ཧը໘Ͱॳظొ࿥ͯ͠ 2. چը໘Ͱฤूͯ͠ 3. ৽ը໘ͰΞΫςΟϒʹ͢Δ ʹΌΜͩͱʂʂ

Slide 9

Slide 9 text

web໘͕4ͭ͋Δ? ● TOPϖʔδ ○ ϒϩάશମͰ͢ɻ ● ҰൠϢʔβʔ͕࢖͏ϒϩά/ެࣜϢʔβʔ͕࢖͏ϒϩά ○ ݸਓϒϩάͰ͢ɻ ● Ϣʔβʔͷ؅ཧը໘ ○ هࣄ؅ཧ͢ΔϢʔβʔ༻ͷ؅ཧը໘Ͱ͢ɻ

Slide 10

Slide 10 text

api͕2ͭ͋Δ? ● webܥͷAPI ● εϚʔτϑΥϯΞϓϦ༻ͷAPI

Slide 11

Slide 11 text

͜͜·Ͱ͸Α͋͘Δ࿩ʂʂʂʂ ͔͜͜Βɺɺɺ

Slide 12

Slide 12 text

DB04 DB03 DB02 DB01 DBͷ਺चͭͳ͗ߏ੒ʁ MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L P MSSQ L M ϒϩάͷهࣄ਺͸14,000ສΛݱ ࡏ௒͍͑ͯΔɻ 1ͭͷDBͰCRUDͷશͯΛࡹ͘ ͷʹݶք͕͋ΔͨΊDBΛ4෼ׂ ͍ͯ͠Δɻ DB01 → Ϛελʔσʔλ DB02 - 04 → هࣄσʔλ DBͷো֐͕ൃੜͨ͠ࡍΛߟ͑ ͯϓϦϯγόϧ/ϛϥʔϦϯάߏ

Slide 13

Slide 13 text

ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ DB04 DB03 DB02 DB01 MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L P MSSQ L M

Slide 14

Slide 14 text

ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ DB04 DB03 DB02 DB01 MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L P MSSQ L M ෛՙ্͕͕Δ

Slide 15

Slide 15 text

ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ DB04 DB03 DB02 DB01 MSSQ L P MSSQ L M MSSQ L M MSSQ L P MSSQ L P MSSQ L M MSSQ L P MSSQ L M ϓϦϯγόϧ/ ϛϥʔ͕ೖΕସΘΔ

Slide 16

Slide 16 text

ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ DB04 DB03 DB02 DB01 MSSQ L P MSSQ L M MSSQ L M MSSQ L P MSSQ L P MSSQ L M MSSQ L P MSSQ L M ෛՙ্͕͕Δ

Slide 17

Slide 17 text

ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ DB04 DB03 DB02 DB01 MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L M MSSQ L P MSSQ L P MSSQ L M ϓϦϯγόϧ/ ϛϥʔ͕ೖΕସΘΔ ϓϦϯγόϧ/ ϛϥʔ͕ݩ௨Γ

Slide 18

Slide 18 text

ϑΣʔϧΦʔόʔ͸͍ͯ͠Δ͚Ͳʁʁ

Slide 19

Slide 19 text

ϑΣʔϧΦʔόʔ DB04ʹෛՙ͕د͍ͬͯΔͷͰɺ௨ৗ ΑΓෛՙ͕ߴ͍ঢ়ଶ͕ଓ͍͍ͯΔɻ ͔͠΋ɺϑΣʔϧΦʔόʔΛݩʹ໭͢ ʹ͸खಈͰϑΣʔϧΦʔόʔ͠ͳ͍ͱ ͍͚ͳ͍ʂʂʂ DB04 DB03 DB02 DB01 MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L M MSSQ L P MSSQ L P MSSQ L M

Slide 20

Slide 20 text

ετΞυϓϩγʔδϟʔ?? ϏδωεϩδοΫ͕ΨοπϦDBʹґଘ͍ͯ͠Δʂʂ ͜͜·Ͱ͸Α͋͘Δ࿩͕ͩɺϏδωεϩδοΫ಺ͰDBͷ઀ଓઌΛϕλଧͪ͠ ͍ͯΔՕॴ͕͋Δʂ ͭ·ΓɺϑΣʔϧΦʔόʔ͕ൃੜ͍ͯ͠Δ࠷தʹɺಛఆͷAPI͕ඞͣΤϥʔʹ ͳΔɻ

Slide 21

Slide 21 text

࣮ࡍͷίʔυ ࣮ࡍͷίʔυ͸ӈʹهࡌ͍ͯ͠Δ DB03ͷcDBͷϓϦϯγόϧ͕DB04- MillerʹҠಈ͍ͯ͠Δͱ[DB04-Miller].c ͡Όͳ͍ͱΞΫηεͰ͖ͳ͍ɻ ͔͠͠ɺίʔυ্Ͱ[DB03].cͱهࡌ͞ Ε͓ͯΓΞΫηεͰ͖ͣɺAPI͸Τ ϥʔͱͳΔɻ DB04 DB03 MSSQ L M MSSQ L M MSSQ L P MSSQ L P SELECT @id = CASE WHEN '1' THEN '[DB01].a.dbo.XXXXXXX' WHEN '2' THEN '[DB02].b.dbo.XXXXXXX WHEN '3' THEN '[DB03].c.dbo.XXXXXXX WHEN '4' THEN '[DB04].d.dbo.XXXXXXX END [DB04-Miller].c.dbo.XXXXXXX [DB03].c.dbo.XXXXXX

Slide 22

Slide 22 text

·ͱΊ ● ϦϏϧυͷ໨త ○ γεςϜͷߏ੒Λγϯϓϧʹɺࠓޙͷ௥Ճ։ൃΛ؆୯ʹʂ ■ DBͷ઀ଓՕॴΛAPIʹશͯدͤΔ ■ DBΛΦʔτεέʔϧ͢Δߏ੒ʹ͠ɺΑΓଟ͘ͷPVΛࡹ͘ʂ ● ࠓͷϑΣʔϧΦʔόʔͷ࢓૊ΈͩͱɺΦʔτεέʔϧͤͣҰ࣌྇͗Ͱ͔͠ͳΒͳ͍ͷͰ ○ ࠓͷߏ੒Λmaster/slaveߏ੒ʹ ■ ؅ཧը໘Λ1ͭʹͯ͠ɺγϯϓϧʹɺӡ༻ίετΛݮΒ͢ʂ ● چچɺچɺ৽؅ཧը໘ɺύτϩʔϧΛҰͭʹ

Slide 23

Slide 23 text

DBͷ઀ଓΛapiʹҰຊԽ ● Ϣʔβ໘ɺ؅ཧը໘ɺAPIͰಉ͡ΫΤϦͱҰຊԽͯ͠APIܦ༝ʹ͢Δ͜ͱ ͰɺϑϩϯτΤϯυ͕DBͷ͜ͱΛؾʹ͠ͳͯ͘Α͘ͳΔʂ ● ετΞυϓϩγʔδϟͷDBϕλॻ͖͕ͳ͘ͳΔͨΊɺΤϥʔ͕ൃੜ͠ͳ ͍ ● ετΞυϓϩγʔδϟͷDBϕλॻ͖͕ͳ͘ͳΕ͹ɺࠓͷߏ੒Λmaster/ slaveߏ੒ʹϚΠάϨʔγϣϯ͢Δ͜ͱ͕Ͱ͖Δ

Slide 24

Slide 24 text

ఘΊͳ͍৺Ͱ ϦϏϧυؤுΓ·͢ɻ ·ͣ͸APIΛʂ to be continued

Slide 25

Slide 25 text

͍ͭͰ΋໘ஊ଴͍ͬͯ·͢ʂ