エキサイトブログ刷新に向けて

JJUG CCC 2021 Fallの際の資料です

Transcript

1. ΤΩαΠτϒϩά࡮৽ʹ޲͚ͯ ংষ - APIΛҰͭʹ
2. ໨࣍ 1. ໨࣍ 2. ࣗݾ঺հ 3. ୲౰͢Δ࢓ࣄ 4. લʹਐΉͨΊʹϦϏϧυ 5. ؅ཧը໘͕4ͭ͋Δ? 6. web໘͕4ͭ͋Δ? 7. api͕2ͭ͋Δ? 8. DBͷ਺चͭͳ͗ߏ੒?? 9. ετΞυϓϩγʔδϟʔ?? 10. ·ͱΊ 11. DBͷ઀ଓΛapiʹҰຊԽ
3. ࣗݾ঺հ 2011/03 ෱Ԭେֶଔۀ 2011/04 தখSIer 2015/01 ্৔webܥ 2020/10 ΤΩαΠτೖࣾ ...ࠓʹࢸΔ தඌਖ਼߶(33ࡀ) όοΫΤϯυΤϯδχΞ ಛٕɿϩʔυόΠΫ झຯɿےτϨ - ϕϯνϓϨεɿ70kg - εΫϫοτɿ100kg - σουϦϑτɿ????
4. ୲౰͢Δ࢓ࣄ ΤΩαΠτϒϩάͷӡ༻։ൃ͕ϝΠϯ Ͱ͢ɻ 2006೥͔Βελʔτ͍ͯ͠ΔαʔϏ εΛεέʔϧ͍ͤͯ͘͞ɻ
5. લʹਐΉͨΊʹϦϏϧυ • ϦϏϧυͷ໨త ◦ γεςϜͷߏ੒Λγϯϓϧʹɺࠓޙͷ௥Ճ։ൃΛ؆୯ʹʂ
6. લʹਐΉͨΊʹϦϏϧυ • 1ϲ݄ͰγεςϜ֓ཁΛཧղ͢Δɻ • 1ϲ݄ͰγεςϜͷ໰୊఺Λ೺Ѳ͢Δɻ • 1ϲ݄ͰγεςϜͷվળํ๏Λߟ͑Δɻ • ൒೥Ͱվળ/࣮ݱ͢Δʂ ݱ࣮͸աࠅͳΓɻɻɻ
7. ؅ཧը໘͕4ͭ͋Δ???? • چچ؅ཧը໘ ◦ ࠷ݹͷ؅ཧը໘ɻ༗ࣝऀ͕͓Βͣɺϝϯςφϯε͕Ͱ͖ͳ͍ɻ • چ؅ཧը໘ ◦ Ұ൪ػೳ͕ͨ͘͞Μ͋ΔɻphpͷಠࣗϑϨʔϜϫʔΫͰ࣮૷͞Ε͍ͯΔɻ • ৽؅ཧը໘ ◦ ϞμϯͳσβΠϯͰͰ͖͍ͯΔɻLaravelͰ࣮૷͞Ε͍ͯΔɻ • ύτϩʔϧ؅ཧը໘ ◦ ͪΐͬͱφΠʔϒͳ৘ใΛѻ͑ΔɻphpͷಠࣗϑϨʔϜϫʔΫͰ࣮૷͞Ε͍ͯΔɻ
8. ͜Μͳۀ຿͕ ͋Γ·ͨ͠ 1. چچ؅ཧը໘Ͱॳظొ࿥ͯ͠ 2. چը໘Ͱฤूͯ͠ 3. ৽ը໘ͰΞΫςΟϒʹ͢Δ ʹΌΜͩͱʂʂ
9. web໘͕4ͭ͋Δ? • TOPϖʔδ ◦ ϒϩάશମͰ͢ɻ • ҰൠϢʔβʔ͕࢖͏ϒϩά/ެࣜϢʔβʔ͕࢖͏ϒϩά ◦ ݸਓϒϩάͰ͢ɻ • Ϣʔβʔͷ؅ཧը໘ ◦ هࣄ؅ཧ͢ΔϢʔβʔ༻ͷ؅ཧը໘Ͱ͢ɻ
10. api͕2ͭ͋Δ? • webܥͷAPI • εϚʔτϑΥϯΞϓϦ༻ͷAPI
11. ͜͜·Ͱ͸Α͋͘Δ࿩ʂʂʂʂ ͔͜͜Βɺɺɺ
12. 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ͷো֐͕ൃੜͨ͠ࡍΛߟ͑ ͯϓϦϯγόϧ/ϛϥʔϦϯάߏ
13. ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ 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
14. ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ 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 ෛՙ্͕͕Δ
15. ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ 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 ϓϦϯγόϧ/ ϛϥʔ͕ೖΕସΘΔ
16. ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ 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 ෛՙ্͕͕Δ
17. ϑΣʔϧΦʔόʔ ࣮ࡍʹϑΣʔϧΦʔόʔ͢Δࡍͷಈ͖ Λઆ໌͠·͢ɻ 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 ϓϦϯγόϧ/ ϛϥʔ͕ೖΕସΘΔ ϓϦϯγόϧ/ ϛϥʔ͕ݩ௨Γ
18. ϑΣʔϧΦʔόʔ͸͍ͯ͠Δ͚Ͳʁʁ
19. ϑΣʔϧΦʔόʔ 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
20. ετΞυϓϩγʔδϟʔ?? ϏδωεϩδοΫ͕ΨοπϦDBʹґଘ͍ͯ͠Δʂʂ ͜͜·Ͱ͸Α͋͘Δ࿩͕ͩɺϏδωεϩδοΫ಺ͰDBͷ઀ଓઌΛϕλଧͪ͠ ͍ͯΔՕॴ͕͋Δʂ ͭ·ΓɺϑΣʔϧΦʔόʔ͕ൃੜ͍ͯ͠Δ࠷தʹɺಛఆͷAPI͕ඞͣΤϥʔʹ ͳΔɻ
21. ࣮ࡍͷίʔυ ࣮ࡍͷίʔυ͸ӈʹهࡌ͍ͯ͠Δ 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
22. ·ͱΊ • ϦϏϧυͷ໨త ◦ γεςϜͷߏ੒Λγϯϓϧʹɺࠓޙͷ௥Ճ։ൃΛ؆୯ʹʂ ▪ DBͷ઀ଓՕॴΛAPIʹશͯدͤΔ ▪ DBΛΦʔτεέʔϧ͢Δߏ੒ʹ͠ɺΑΓଟ͘ͷPVΛࡹ͘ʂ • ࠓͷϑΣʔϧΦʔόʔͷ࢓૊ΈͩͱɺΦʔτεέʔϧͤͣҰ࣌྇͗Ͱ͔͠ͳΒͳ͍ͷͰ ◦ ࠓͷߏ੒Λmaster/slaveߏ੒ʹ ▪ ؅ཧը໘Λ1ͭʹͯ͠ɺγϯϓϧʹɺӡ༻ίετΛݮΒ͢ʂ • چچɺچɺ৽؅ཧը໘ɺύτϩʔϧΛҰͭʹ
23. DBͷ઀ଓΛapiʹҰຊԽ • Ϣʔβ໘ɺ؅ཧը໘ɺAPIͰಉ͡ΫΤϦͱҰຊԽͯ͠APIܦ༝ʹ͢Δ͜ͱ ͰɺϑϩϯτΤϯυ͕DBͷ͜ͱΛؾʹ͠ͳͯ͘Α͘ͳΔʂ • ετΞυϓϩγʔδϟͷDBϕλॻ͖͕ͳ͘ͳΔͨΊɺΤϥʔ͕ൃੜ͠ͳ ͍ • ετΞυϓϩγʔδϟͷDBϕλॻ͖͕ͳ͘ͳΕ͹ɺࠓͷߏ੒Λmaster/ slaveߏ੒ʹϚΠάϨʔγϣϯ͢Δ͜ͱ͕Ͱ͖Δ
24. ఘΊͳ͍৺Ͱ ϦϏϧυؤுΓ·͢ɻ ·ͣ͸APIΛʂ to be continued
25. ͍ͭͰ΋໘ஊ଴͍ͬͯ·͢ʂ