Upgrade to Pro — share decks privately, control downloads, hide ads and more …

つらくないマルチテナンシーを求めて: 全て見せます！ SmartHR データベース移行プロジェ...

Avatar for Purintai Purintai
September 08, 2018
Programming
123
63k

つらくないマルチテナンシーを求めて: 全て見せます！ SmartHR データベース移行プロジェクトの裏側 / builderscon 2018

Avatar for Purintai

Purintai

September 08, 2018
Tweet

More Decks by Purintai

See All by Purintai
急成長するマルチテナント SaaSの技術戦略を支えるAWS / X-Tech JAWS 2
Avatar for Purintai purintai
15
4.3k

Other Decks in Programming

See All in Programming
Is Xcode slowly dying out in 2025?
Avatar for 上ちょ / uetyo uetyo
1
260
CursorはMCPを使った方が良いぞ
Avatar for taiga taigakono
1
250
Quand Symfony, ApiPlatform, OpenAI et LangChain s'allient pour exploiter vos PDF : de la théorie à la production…
Avatar for Ahmed EBEN HASSINE ahmedbhs123
0
170
AIと”コードの評価関数”を共有する / Share the "code evaluation function" with AI
Avatar for Shintani Teppei euglena1215
1
150
LINEヤフー データグループ紹介
Avatar for LINEヤフー株式会社 採用情報 lycorp_recruit_jp
1
2.4k
High-Level Programming Languages in AI Era -Human Thought and Mind-
Avatar for Hayato Ishida hayat01sh1da
PRO
0
760
Hack Claude Code with Claude Code
Avatar for Akihiro Okuno choplin
3
960
関数型まつりレポート for JuliaTokai #22
Avatar for GOTOH Shunsuke antimon2
0
160
テストから始めるAgentic Coding 〜Claude Codeと共に行うTDD〜 / Agentic Coding starts with testing
Avatar for r-kagaya rkaga
12
3.1k
Claude Code + Container Use と Cursor で作る ローカル並列開発環境のススメ / ccc local dev
Avatar for Yuichi Maekawa kaelaela
6
2.5k
GitHub Copilot and GitHub Codespaces Hands-on
Avatar for Kento.Yamada ymd65536
2
150
XP, Testing and ninja testing
Avatar for seki at druby.org m_seki
3
240

Featured

See All Featured
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
346
40k
Code Reviewing Like a Champion
Avatar for maltzj maltzj
524
40k
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
140
7k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
Avatar for mongodb mongodb
46
9.6k
Faster Mobile Websites
Avatar for Dean Hume deanohume
307
31k
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
6.5k
Unsuck your backbone
Avatar for Amy Palamountain ammeep
671
58k
The Psychology of Web Performance [Beyond Tellerrand 2023]
Avatar for Tammy Everts tammyeverts
48
2.9k
Typedesign – Prime Four
Avatar for Hannes Fritz hannesfritz
42
2.7k
Stop Working from a Prison Cell
Avatar for Chris Michel hatefulcrawdad
270
21k
Automating Front-end Workflow
Avatar for Addy Osmani addyosmani
1370
200k
We Have a Design System, Now What?
Avatar for Morgane Peng morganepeng
53
7.7k

Transcript

  1. ͭΒ͘ͳ͍ϚϧνςφϯγʔΛٻΊͯ શͯݟͤ·͢ʂ 4NBSU)3σʔλϕʔεҠߦ ϓϩδΣΫτͷཪଆ ΀ΓΜ͍ͨ ιϑτ΢ΣΞΤϯδχΞ CVJMEFSTDPO  4BU

  2. ࠓ೔͸Έͳ͞Μ͕େ޷͖ͳ σʔλϕʔεҠߦͷ࿩Ͱ͢ʂ

  3. ͜͜Ͱ ϓϩδΣΫτ։࢝௚લͷ ࢲͷπΠʔτΛݟ·͠ΐ͏

  4. None

  5. ΤϯδχΞਓʹฉ͖·ͨ͠ ͋ͳͨͷਐḿΛѱԽͤ͞ΔݪҼ͸ʁ

  6. πΠολʔΛ΍Ίͯ ѹ౗తਐḿ

  7. Ұํઌिͷ ࢲͷπΠʔτΛݟ·͠ΐ͏

  8. None

  9. ࠶ͼπΠολʔΛ΍Ίͯ ѹ౗తਐḿ ͔ͱࢥ͍͖΍ʜʜ

  10. None

  11. ̍िؒμ΢ϯ͠·͕ͨ͠ ͳΜͱ͔ؒʹ߹͍·ͨ͠

  12. ࣗݾ঺հ )/΀ΓΜ͍ͨ 5XJUUFS!TQBDFQSP@CF (JU)VC!QVSJOUBJ ɾ4NBSU)3ͷιϑτ΢ΣΞΤϯδχΞ ೥݄ೖࣾ  ɾࠓճͷ%#ҠߦϓϩδΣΫτΛϦʔυͨ͠ ɾಛஈ3%#.4ʹৄ͍͠Θ͚Ͱ͸ͳ͍

  13. ԿނσʔλϕʔεҠߦΛʁ

  14. σϓϩΠʹֻ͕͔࣌ؒΓ͗͢

  15. σϓϩΠʹֻ͕͔࣌ؒΓ͗͢

  16. σϓϩΠʹֻ͕͔࣌ؒΓ͗͢ ຊ౰ʹ͔͔࣌ؒΓ·ͨ͠

  17. ͳͥ͜Μͳ͜ͱʹ ͳͬͯ͠·ͬͨΜͩ

  18. ཧ༝͸εΩʔϚมߋ ςʔϒϧ΍ΧϥϜͷ௥Ճɾมߋɾ࡟আFUD

  19. Ͱ΋͔͔࣌ؒΔ εΩʔϚมߋͳΜͯ ฉ͍ͨ͜ͱ͕ͳ͍

  20. Ͳ͏ͯ͜͠Μͳ͜ͱʹʁ ҰମͲ͏΍ͬͯղܾΛʜ

  21. ΞδΣϯμ w Ϛϧνςφϯτͱ͸ w 4NBSU)3ͷϚϧνςφϯτ w BQBSUNFOUͷམͱ݀͠ w 4NBSU)3Ϛϧνςφϯτ೥ද w

    $JUVT$MPVEҠߦϓϩδΣΫτ w σʔλҠߦ͋Ε͜Ε w ৼΓฦΓ

  22. Ϛϧνςφϯτͱ͸

  23. Ϛϧνςφϯτͱ͸ ϚϧνςφϯτʢNVMUJUFOBOUʣ 4BB4 αʔε ͳͲͷαʔϏεʹ͓͍ͯɺෳ਺ͷސ٬اۀ͕ ҰͭͷγεςϜΛڞ༗͢Δํࣜɻγϯάϧςφϯτʹൺ΂ɺ ௿ίετͰར༻Ͱ͖ΔɻԾ૝Խٕज़ͱαʔόʔͷੑೳͷɹ ޲্ʹΑͬͯΫϥ΢υίϯϐϡʔςΟϯά͕޿͘ීٴ͠ɺ ΑΓҰൠతʹͳͬͨɻϚϧνςφϯγʔɻ Ҿ༻ݩϚϧνςφϯτͱ͸ίτόϯΫ


    IUUQTLPUPCBOLKQXPSEϚϧνςφϯτ

  24. Ϛϧνςφϯτͱ͸ ࡶʹઆ໌ͯ͠͠·͏ͱ اۀ͝ͱʹاۀઐ༻ͷ8FC%#αʔόΛ༻ҙ͢Δ ɹˠγϯάϧςφϯτ ෳ਺ͷاۀ͕ಉ͡8FC%#αʔόΛڞ༻͢Δ ʢར༻اۀ͔Β͸ઐ༻ͷ؀ڥͰ͋ΔΑ͏ʹݟ͑Δʣ ɹˠϚϧνςφϯτ

  25. Ϛϧνςφϯτͱ͸ ͭ·Δͱ͜Ζར༻ऀؒͰܭࢉࢿݯΛڞ༗ͭͭ͠ σʔλ ੈք؍ ͷ෼཭Λ࣮ݱ͠ͳ͚Ε͹ͳΒͳ͍ Ҿ༻ݩ.VMUJUFOBODZ"SDIJUFDUVSFc+FTÙT(JM)FSOÂOEF[ IUUQKFTVTHJMIFSOBOEF[DPNNVMUJUFOBODZBSDIJUFDUVSF

  26. Ϛϧνςφϯτͱ͸ 2ͳͥϚϧνςφϯτΛ΍Δͷʁ "Πϯϑϥʹ͓͕͔͔ۚΒͳ͍͔ΒͰ͢  ͕ࣾαΠϯΞοϓͨ͠ͱ͖ ηοτͷ8FC%#αʔόʹಉډͤ͞Δ ɹɹɹɹɹɹɹ  ηοτͷ8FC%#αʔόΛݸผʹ༻ҙ͢Δ ˠ͓ۚ΋͔͔Δ͠ɺͲ͏΍ͬͯӡ༻͢Δͷʁ

  27. 4NBSU)3͸ Ϛϧνςφϯτ ##4BB4Ͱ͢

  28. 4NBSU)3ͷ Ϛϧνςφϯτ

  29. Ϛϧνςφϯγʔ޲͚HFN 4NBSU)3͸3VCZPO3BJMTͰͰ͖͍ͯ·͢

  30. Ϛϧνςφϯγʔ޲͚HFN 3VCZPO3BJMTͱ͍͑͹๛෋ͳHFN QBDLBHF ͨͪ lϚϧνςφϯτzͰݕࡧ

  31. Ϛϧνςφϯγʔ޲͚HFN 4NBSU)3Ͱ࠾༻͞Εͨͷ͸BQBSUNFOU

  32. Ϛϧνςφϯγʔ޲͚HFN (JU)VC4UBS΋ͨ͘͞Μ ϚϧνςφϯτHFNτοϓμ΢ϯϩʔυ਺ ༷ʑͳΦεεϝهࣄ

  33. ͍͚ͦ͏

  34. BQBSUNFOUͷڍಈ BQBSUNFOU͸ςφϯτ͕࡞੒͞ΕΔͱ ɹɹɹɹɹʢʹར༻اۀͷαΠϯΞοϓʣ .Z42-ͳΒ$3&"5&%"5"#"4& 1PTUHSF42-ͳΒ$3&"5&4$)&."͕࣮ߦ͞Ε ੜ੒͞Εͨର৅ʹ޲͚ͯεΩʔϚఆٛΛద༻ TDIFNBSCΛಡΜͰ$3&"5&5"#-&Λ࣮ߦ ͠·͢

  35. BQBSUNFOUͷڍಈ ςφϯτ୯ҐͰσʔλϕʔε͕࡞੒͞ΕΔͷͰ ແ഑ྀʹ$SFXGJSTU 4&-&$5 '30.DSFXT-*.*5  ͱ͔΍ͬͯ΋ଞςφϯτͷσʔλ͕ࠞ͟Βͳ͍☺ ΋͠BQBSUNFOUΛ࢖Θͳ͍ͳΒ ಉ͡ςʔϒϧʹผςφϯτͷϨίʔυ͕ࠞ͟ΔͳΒ $SFXXIFSF

    UFOBOU@JE GJSTUͬͯຖճࢦఆ͠ͳ͍ͱ 4&-&$5 '30.DSFXT 8)&3&AUFOBOU@JEA-*.*5

  36. BQBSUNFOUͷڍಈ ҰํςφϯτΛ·͍ͨͰऔΓѻ͍͍ͨ֓೦΋͋Δ ྫαϒυϝΠϯ՝ۚςφϯτͦͷ΋ͷFUD ςφϯτؒͰڞ༗͍ͨ͠Ϩίʔυ͸ύϒϦοΫ%# ͱ͍͏ಛผͳ%#্ʹ؅ཧͰ͖ΔΑ͏ࢦఆ͕Մೳ ٯʹڞ༗ͨ͘͠ͳ͍ςφϯτผͷϨίʔυ͸ ઌఔ࡞੒͞ΕͨςφϯτຖͷϓϥΠϕʔτ%#Ͱ؅ཧ

  37. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU

  38. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU  )551ϦΫΤετΛड͚Δ

  39. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU %#ίωΫγϣϯΛׂΓ౰ͯΒΕΔ <ύϒϦοΫ%#>

  40. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU ϦΫΤετϔομʔͷ)PTU͔ΒαϒυϝΠϯΛநग़ )PTUFYBNQMFTNBSUISKQ͔ΒFYBNQMFΛऔΓग़͢ <ύϒϦοΫ%#>

  41. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU αϒυϝΠϯFYBNQMFʹରԠ͢Δ ɹςφϯτͷଘࡏΛύϒϦοΫ%#্Ͱ֬ೝ͢Δ
  4&-&$5 '30.AUFOBOUTA 8)&3&ATVCEPNBJOAFYBNQMF <ύϒϦοΫ%#>

  42. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU αϒυϝΠϯFYBNQMFʹରԠ͢ΔϨίʔυΛฦ͢ <ύϒϦοΫ%#>

  43. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU Ϩίʔυʹσʔλϕʔεؚ໊͕·Ε͍ͯΔͷͰ ɹݱࡏ௫ΜͰ͍Δ%#઀ଓͷσʔλϕʔεΛ੾Γସ͑Δ
  VTFQSPEVDUJPO@FYBNQMF <FYBNQMF>

  44. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU BQBSUNFOU͸ϦΫΤετΛॲཧ͢Δؒ ੾Γସ͑தͷςφϯτΛ͓֮͑ͯ͘
  "QBSUNFOU5FOBOUDVSSFOUFYBNQMF <FYBNQMF> <FYBNQMF>

  45. <FYBNQMF> BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic

    Beanstalk Amazon S3 BQBSUNFOU FY3FEJTͱ4͸੾Γସ͑தͷςφϯτ*%Λ ͦΕͧΕOBNFTQBDFσΟϨΫτϦύεʹར༻͠෼཭ <FYBNQMF>

  46. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU ϦΫΤετΛॲཧ͢Δ  ϓϥΠϕʔτ%#্ͰϨίʔυૢ࡞ <FYBNQMF> <FYBNQMF>

  47. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU )551ϨεϙϯεΛฦ͢ <FYBNQMF> <FYBNQMF>

  48. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU ݱࡏ௫ΜͰ͍Δ%#ίωΫγϣϯͷ ࢀরઌΛݩʹ໭͢
  VTFTNBSUIS@QSPEVDUJPO <ύϒϦοΫ%#>

  49. BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic Beanstalk

    Amazon S3 BQBSUNFOU %#ίωΫγϣϯΛฦ٫ऴྃ͠ ࣍ͷ)551ϦΫΤετΛ଴ͭʢऴʣ

  50. BQBSUNFOUศར͡ΌΜ ʢศར͡ΌΜʣ

  51. BQBSUNFOUͷམͱ݀͠

  52. BQBSUNFOUͷམͱ݀͠ ࣌͸ḪΓ೥݄

  53. BQBSUNFOUͷམͱ݀͠ ΦοBQBSUNFOUHFNʹ͍ͭͯͷηογϣϯͰ͢Ͷ

  54. BQBSUNFOUͷམͱ݀͠ Ҿ༻ݩ1SPHSBNc3VCZ9&MJYJS$POG5BJXBO IUUQTSVCZDPOGUXQSPHSBNMJBOHDIJUTFOH

  55. BQBSUNFOUͷམͱ݀͠ Ҿ༻ݩ1SPHSBNc3VCZ9&MJYJS$POG5BJXBO IUUQTSVCZDPOGUXQSPHSBNMJBOHDIJUTFOH /&7&3VTFBQBSUNFOUHFN POBMBSHFTDBMFQSPKFDU

  56. BQBSUNFOUͷམͱ݀͠ Ҿ༻ݩ1SPHSBNc3VCZ9&MJYJS$POG5BJXBO IUUQTSVCZDPOGUXQSPHSBNMJBOHDIJUTFOH BQBSUNFOUΛ࢖͏ͳ େن໛ϓϩδΣΫτͰ

  57. 8):

  58. BQBSUNFOUͷམͱ݀͠ ɾ%#ϚΠάϨʔγϣϯʹ͔͔Δ࣌ؒͷ૿େ ɾσʔλϕʔεͷىಈʹ͔͔Δ࣌ؒͷ૿େ ɾ"DUJWF3FDPSEͷΩϟογϡͰϝϞϦυΧ৯͍ ɾϑΝΠϧγεςϜͷJOPEF্ݶ ɹ˺Πϯελϯεͷςʔϒϧ਺ͷ্ݶ Ҿ༻ݩ3VCZ&MJYJS$POG5BJXBO/FWFSVTF"QBSUNFOUHFNPOBMBSHFTDBMFQSPKFDUCZ-JBOH$IJ5TFOH IUUQTXXXZPVUVCFDPNXBUDI W%1($-UNT

  59. None

  60. ϚΠάϨʔγϣϯ໰୊ σʔλϕʔε͕෼཭͞Ε͍ͯͯศར ˠͭ·ΓϚΠάϨʔγϣϯ΋෼཭ ˠςφϯτΛ๊͍͑ͯͨΒ ϚΠάϨʔγϣϯճ࣮ߦ ˠ ςφϯτͳΒʜʜ  ˠ ςφϯτͳΒʜʜ

     ˠ ςφϯτͳΒʜʜ 

  61. ϚΠάϨʔγϣϯ໰୊ ςφϯτ͋ͨΓͷϚΠάϨʔγϣϯʹඵ ςφϯτˠඵ  ςφϯτˠඵ  ςφϯτˠ෼  ςφϯτˠ࣌ؒ

  62. ϚΠάϨʔγϣϯ໰୊ ςφϯτ͋ͨΓͷϚΠάϨʔγϣϯʹඵ ςφϯτˠඵ  ςφϯτˠඵ  ςφϯτˠ෼  ςφϯτˠ࣌ؒ

  63. ϚΠάϨʔγϣϯ໰୊ ςφϯτ͋ͨΓͷϚΠάϨʔγϣϯʹඵ ςφϯτˠ෼  ςφϯτˠ෼  ςφϯτˠ࣌ؒ  ςφϯτˠϱ݄

  64. ϚΠάϨʔγϣϯ໰୊

  65. %#ϒʔτλΠϜ໰୊ ςφϯτ਺͕૿͑ΔʹͭΕ૿͑Δॾʑͷ࣌ؒʜʜ

  66. %#ϒʔτλΠϜ໰୊

  67. %#ϒʔτλΠϜ໰୊

  68. ͜ͷ··Ͱ͸·͍ͣ ͳͥͳΒʜʜ

  69. 4NBSU)3ͱ͍͏ΞϓϦͷಛੑ શը໘ͷׂ͕̔ϑΥʔϜ

  70. 4NBSU)3ͱ͍͏ΞϓϦͷಛੑ ͭ·Γػೳվम͸جຊతʹϚΠάϨʔγϣϯΛ൐͏

  71. 4NBSU)3ͱ͍͏ΞϓϦͷಛੑ ͭ·Γػೳվम͸جຊతʹϚΠάϨʔγϣϯΛ൐͏

  72. ࣮ࡍिʙϖʔεͰ ϚΠάϨʔγϣϯͯͨ͠

  73. ͦͷଞॾʑ͸ׂѪ ࢲୡʹର͢ΔӨڹ͸ܰඍͩͬͨ

  74. ͜ͷ··Ͱ͸·͍ͣʜʜ

  75. ౰વࢦΛ͘Θ͑ͯ ͨͩݟक͍ͬͯͨ Θ͚Ͱ͸͋Γ·ͤΜ

  76. 4NBSU)3 Ϛϧνςφϯτ೥ද

  77. 4NBSU)3Ϛϧνςφϯτ೥ද ܧଓར༻཰        

           ࣾ ར༻اۀ਺

  78. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺

  79. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄

  80. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄

  81. JOJUJBMDPNNJU

  82. BQBSUNFOU͕(FNGJMFʹ௥Ճ͞Εͨͷ͸िؒޙ JOJUJBMDPNNJU

  83. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛

  84. ϚΠάϨʔγϣϯʹ ͕͔͔࣌ؒΔͳΒ ฒྻԽ͢Ε͹͍͍͡ΌΜ

  85. ϚΠάϨʔγϣϯฒྻԽ

  86. ϚΠάϨʔγϣϯฒྻԽ ςφϯτ͋ͨΓඵ͔͔ΔϚΠάϨʔγϣϯ͕  ςφϯτ͋Δͱ͖ʹ ඵʹͳΔͳΒ ฒྻͰϚΠάϨʔγϣϯ͢Ε͹ඵʹͳΔΑͶ

  87. ͜ͷ࣌͸·ͩ Կ΋஌Βͳ͔ͬͨ

  88. ͔͜͠͠ͷ࣌఺Ͱ͸ ࣮ઓ౤ೖͤͣ

  89. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛ σϓϩΠ໰୊͕ ঃʑʹݦࡏԽ

  90. σϓϩΠ໰୊͕ݦࡏԽͩ͢͠

  91. σϓϩΠ໰୊͕ݦࡏԽͩ͢͠ 8FCίϯςφͷσϓϩΠ͸ऴΘͬͯΔͷʹ ϚΠάϨʔγϣϯ͸ऴΘͬͯͳ͍ʂ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ ୅ද 8FCίϯςφ ϚΠάϨʔγϣϯ࣮ߦத

    $3&"5&5"#-&DPNNFOUT ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧͳ͍

  92. Τϥʔ

  93. ͱ͸͍͑ ςφϯτ਺΋গͳΊͰ ਺෼ఔ౓Ͱղফͯͨ͠

  94. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛ σϓϩΠ໰୊͕ ঃʑʹݦࡏԽ QVSJOUBJೖࣾ

  95. ͸͍

  96. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛ σϓϩΠ໰୊͕ ঃʑʹݦࡏԽ QVSJOUBJೖࣾ ଟஈσϓϩΠͷಋೖ

  97. ଟஈσϓϩΠͷಋೖ

  98. ଟஈσϓϩΠͷಋೖ

  99. ଟஈσϓϩΠͷಋೖ ઌʹNJHSBUJPO؀ڥͰϚΠάϨʔγϣϯ࣮ߦ ׬ྃޙʹXFC؀ڥʹσϓϩΠ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ϚΠάϨʔγϣϯ࣮ߦத

    $3&"5&5"#-&DPNNFOUT 8FCίϯςφ DPNNFOUTͷ ଘࡏΛ஌Βͳ͍ 8FCίϯςφ DPNNFOUTͷ ଘࡏΛ஌Βͳ͍

  100. ଟஈσϓϩΠͷಋೖ ઌʹNJHSBUJPO؀ڥͰϚΠάϨʔγϣϯ࣮ߦ ׬ྃޙʹXFC؀ڥʹσϓϩΠ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ϚΠάϨʔγϣϯ׬ྃ $3&"5&5"#-&DPNNFOUT 8FCίϯςφ

    DPNNFOUTͷ ଘࡏΛ஌Βͳ͍ 8FCίϯςφ DPNNFOUTͷ ଘࡏΛ஌Βͳ͍

  101. ଟஈσϓϩΠͷಋೖ ઌʹNJHSBUJPO؀ڥͰϚΠάϨʔγϣϯ࣮ߦ ׬ྃޙʹXFC؀ڥʹσϓϩΠ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ৽͍͠ 8FCίϯςφ DPNNFOUT

    ςʔϒϧ͋Δ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ
  102. None

  103. ͔ͯ࣌ؒ͠͠͸ ͔͔ΔΑ͏ʹͳͬͨ

  104. ฒྻ࣮ߦͷເ

  105. ฒྻ࣮ߦͷເ

  106. ฒྻ࣮ߦͷເ

  107. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛ σϓϩΠ໰୊͕ ঃʑʹݦࡏԽ QVSJOUBJೖࣾ ଟஈσϓϩΠͷಋೖ ৳ͼଓ͚Δ σϓϩΠ࣌ؒ

  108. σϓϩΠ࣌ؒ෼Ͱ ௕͍ͱݴ͍ͬͯͨ ϱ݄લʜʜ

  109. ৳ͼଓ͚ΔσϓϩΠ࣌ؒ

  110. ςφϯτ਺͸ Λ ௒͍͑ͯͨ

  111. ͍ͦͯͭ͠ʹ ͋ͷൿີฌث͕

  112. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛ σϓϩΠ໰୊͕ ঃʑʹݦࡏԽ QVSJOUBJೖࣾ ଟஈσϓϩΠͷಋೖ ৳ͼଓ͚Δ σϓϩΠ࣌ؒ ʁʁʁ

  113. ฒྻϚΠάϨʔγϣϯ࣮ઓ౤ೖ

  114. ͖ͨʂ͜ΕͰউͭΔʂ

  115. ࣮ઓ౤ೖޙ

  116. ͋ͬ

  117. ͋ͬ

  118. ىͬͨ͜͜ͱ NJHSBUJPO؀ڥ্ͰฒྻϚΠάϨʔγϣϯΛ࣮ߦ ͓΍ʜʜNJHSBUJPO؀ڥͷ༷ࢠ͕ʜʜʁ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ฒྻϚΠάϨʔγϣϯ࣮ߦத

    $3&"5&5"#-&DPNNFOUT

  119. ىͬͨ͜͜ͱ ϝϞϦෆ଍ͰNJHSBUJPO؀ڥࢮ๢ ˞ͨͩͷߟྀ࿙Ε  "-5&35"#-&͕த్൒୺ͳঢ়ଶͰऴΘΔ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈

  120. ىͬͨ͜͜ͱ

  121. ىͬͨ͜͜ͱ

  122. ·ͨผͷ೔͸ ผͷཧ༝Ͱཱͯଓ͚ʹ σϓϩΠࣦഊ

  123. ࿈೔ͷো֐ൃੜ ೔த̔࣌ؒͷ αʔϏεఀࢭ

  124. None

  125. ਃ͠༁͍͟͝·ͤΜ Ͱͨ͠

  126. ͜ΕΛ͖͔͚ͬʹ ਂ໷ఆظϝϯςφϯε͕ ͸͡·Δʜʜ

  127. εϥΠυલ൒ऴྃ ʢͪΐͬͱٳܜʣ

  128. ٳܜ͕ͯΒ ͜͜·Ͱͷ໰୊ͷ੔ཧ

  129. ໰୊ͷ࠶੔ཧ ɾฒྻσϓϩΠ͸࣮ઓ౤ೖ͞Εͨ͹͔ΓͰ·ͩෆ҆ఆ ɾجຊతʹଟஈσϓϩΠͰ໰୊ແ͍͸͕ͣͩ ɹಛఆ৚݅ԼͰෆ҆ఆʹͳΔ ɾԿΒ͔ͷཁҼͰϚΠάϨʔγϣϯ͕தஅ͞ΕΔͱ ɹςφϯτ͝ͱͷεΩʔϚ͕όϥόϥʹͳΓ ɹௐࠪ෮چ͕େม ɾԿΑΓσϓϩΠʹ͕͔͔࣌ؒΓ͗͢Δ

  130. ໰୊ͷ࠶੔ཧ ͳʹ͕Ұ൪ղফ͞ΕΔͱ͏Ε͍͠ͷ͔ ɹˠϚΠάϨʔγϣϯ͕ര଎ʹͳΔͱ͏Ε͍͠ ɹˠͦͷͨΊʹ͸BQBSUNFOUΛ΍ΊΔඞཁ͕͋Δ ɹˠBQBSUNFOUΛ΍Ίͨޙͷ͜ͱΛߟ͑Δͱʜʜ εΩʔϚ౷߹ޙʹͲ͏΍ͬͯϚϧνςφϯτΛकΔʁ ओΩʔ͕࿈൪͔ͩΒ౷߹͢Δͱিಥ͢Δ͠ʜʜ ༬͔͍ͬͯΔ৘ใ͕৘ใ͚ͩʹ࿙ΕͨΒᔬམʹͳΒͳ͍

  131. ϚΠάϨʔγϣϯΛ ര଎ʹ͢Δํ๏ͷߟ࡯ ʢτϥΠΞϯυΤϥʔʣ

  132. ΠϯελϯεαΠζΛένͬͪΌμϝ NJHSBUJPO؀ڥ͸NYMBSHF 3%4 .Z42- ͸SYMBSHF  (#44%ʹมߋ ͜Ε͚ͩͰҰ࣌తʹ਺ഒߴ଎Խͨ͠ ʢςφϯτ਺૿͑ͯ·ͨ஗͘ͳ͚ͬͨͲʣ ۚͷ஄ؙ

  133. ͢΂ͯͷςφϯτ͕ ೔ৗతʹར༻͞Ε͍ͯΔΘ͚Ͱ͸ͳ͍ ༏ઌϚΠάϨʔγϣϯ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ

  134. ςφϯτ܈ʹ༏ઌ౓Λ෇༩͢Δ ྫ՝ۚதτϥΠΞϧதແྉϓϥϯ ೔Ҏ಺ϩάΠϯ೔Ҏ಺ϩάΠϯϩάΠϯͳ͠ ༏ઌϚΠάϨʔγϣϯ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ༏ઌ౓ߴ ༏ઌ౓த

    ༏ઌ౓௿

  135. ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ༏ઌ౓ߴ͕ऴྃͨ͠Βݟ੾ΓσϓϩΠͯ͠͠·͏ɹɹɹɹ ༏ઌϚΠάϨʔγϣϯ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ༏ઌ౓ߴ ༏ઌ౓த

    ༏ઌ౓௿ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧͳ͍

  136. ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ༏ઌ౓தɾ௿܈͕ΞΫηε͢ΔͱΤϥʔʹͳΔ͕ ࣮ࡍΞΫηεස౓͕௿͍܈ͳͷͰ໰୊͕ى͖ͳ͍ ༏ઌϚΠάϨʔγϣϯ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ༏ઌ౓ߴ

    ༏ઌ౓த ༏ઌ౓௿ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧͳ͍

  137. ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ༏ઌ౓தɾ௿܈ͷਓ͕ΞΫηεͯ͘͠Δࠒʹ͸ ϚΠάϨʔγϣϯ͸ऴΘ͍ͬͯΔʢϋζʣ ༏ઌϚΠάϨʔγϣϯ ະ ׬ NJHSBUJPO ίϯςφ ༏ઌ౓ߴ

    ༏ઌ౓த ༏ઌ౓௿ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ

  138. গ͠ޮՌ͸͋ͬͨ

  139. ͕ͩશମͱ͕ͯ࣌ؒ͠ ͔͔Δͷ͸มΘΒͣ

  140. ݩͷߏ੒ ΞʔΩςΫνϟͷมߋݕ౼ MySQL DB instance BQBSUNFOU ύϒϦοΫ%# ϓϥΠϕʔτ%# ϓϥΠϕʔτ%# ϓϥΠϕʔτ%#

    instance

  141. ෳ਺%#ʹ͢Ε͹ϚΠάϨʔγϣϯ଎͘ͳΔͷͰ͸ʁ ΞʔΩςΫνϟͷมߋݕ౼ MySQL DB instance BQBSUNFOU ύϒϦοΫ%# ϓϥΠϕʔτ%# ϓϥΠϕʔτ%# ϓϥΠϕʔτ%#

    instance MySQL DB instance ύϒϦοΫ%# ϓϥΠϕʔτ%# ϓϥΠϕʔτ%# ϓϥΠϕʔτ%#

  142. ͪΐͬͱ଴ͪͨ·͑

  143. ͦ΋ͦ΋4NBSU)3͸

  144. ࣮͸ैۀһͱϢʔβΛ σʔλϕʔεލ͍Ͱ+0*/͍ͯ͠Δ ΞʔΩςΫνϟͷมߋݕ౼ MySQL DB instance BQBSUNFOU ύϒϦοΫ%# ϓϥΠϕʔτ%# ϓϥΠϕʔτ%#

    ϓϥΠϕʔτ%# instance ैۀһςʔϒϧ ͸ͬͪ͜ Ϣʔβςʔϒϧ ͸ͬͪ͜

  145. ͳͥϢʔβ͕ ύϒϦοΫ%#্ʹʁ

  146. ཧ༝ࣾ࿑࢜޲͚ػೳͱͯ͠ෳ਺ͷςφϯτʹ ୯ҰϢʔβ͕ϩάΠϯͰ͖Δػೳ͕͋Δ͔Β ΞʔΩςΫνϟͷมߋݕ౼

  147. ͦͯ͠ෳ਺%#ߏ੒͸ ઌߦࣄྫΛௐࠪ͢Δʹ পͬΆ͍ʜʜ

  148. ͭΒ͍΍Γํ͸ ͍͔ͭࣗ෼ͨͪͷ଍Λ Ҿͬுͬͯ͘Δ

  149. ଞʹ΋༷ʑ͋Γ ෳ਺%#ܭը͸ ͓ଂೖΓ

  150. ͱ͜ΖͰ

  151. CVJMEFSTDPOͷςʔϚ͸ ʮ஌Βͳ͔ͬͨΛɺฉ͘ʯ Ͱ͕͢

  152. օ͞Μ͓ؾ͖ͮ Ͱͨ͠Ͱ͠ΐ͏͔

  153. શ͘ޮՌ͕ग़ͳ͔ͬͨ ͋ͷൿີฌثͷ͜ͱΛʜ

  154. ࢥ͍ग़͢γϦʔζ

  155. ಥવͰ͕͢ ͜͜ͰΫΠζͰ͢

  156. ͋Δ"843%4 .Z42- ͷΠϯελϯε্ʹ ଘࡏ͢Δෳ਺ͷ%"5"#"4&ʹڞ௨Ͱଘࡏ͢Δ ςʔϒϧʹΧϥϜΛ௥Ճ͠Α͏ͱࢥ͍·͢ɻ %"5"#"4&ͷ਺͕ͩͬͨ৔߹ʹฒྻͰ "-5&35"#-&Λ࣮ߦͨ͠ΒԿඵͰऴΘΔͰ͠ΐ͏͔ɻ ୯ମͰ࣮ߦͨ͠৔߹͸ඵ͔͔Δ΋ͷͱ͠ɺ Φʔόʔϔου͸ৗʹඵͱ͢Δɻ ಥવͷΫΠζ

  157. ਖ਼ղ͸ʜʜ

  158. ਖ਼ղ͸ʜʜඵͰ͢

  159. ฒྻ%%-ͷ࣮ߦͬͯ ͦ΋ͦ΋ແཧͩͬͨ গͳ͘ͱ΋ςʔϒϧΧϥϜͷ௥Ճ࡟আ͕൐͏ͱ

  160. ஌Βͳ͔ͬͨ

  161. ஌Βͳ͔ͬͨ

  162. ஌Βͳ͔ͬͨ Λฉ͚·͔ͨ͠ʁ

  163. ։ൃνʔϜ͕ ͜ͷࣄ࣮ʹؾͮ͘ͷ͸ ΋͏গ͠ઌͷ࿩

  164. ͓͋ͱ͕ΑΖ͍͠Α͏Ͱ

  165. εϥΠυޙ൒ελʔτ

  166. ଓɾ4NBSU)3 ϚΠάϨʔγϣϯ೥ද

  167. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛ σϓϩΠ໰୊͕ ঃʑʹݦࡏԽ QVSJOUBJೖࣾ ଟஈσϓϩΠͷಋೖ ৳ͼଓ͚Δ σϓϩΠ࣌ؒ αʔϏεো֐ൃੜ ఆظϝϯςମ੍ ελʔτ

  168. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛ σϓϩΠ໰୊͕ ঃʑʹݦࡏԽ QVSJOUBJೖࣾ ଟஈσϓϩΠͷಋೖ ৳ͼଓ͚Δ σϓϩΠ࣌ؒ αʔϏεো֐ൃੜ ఆظϝϯςମ੍ ελʔτ %JTDPWFS 4PNFUIJOH/FX

  169. ͦΕ͸)FSPLV1PTUHSFTΛௐ΂͍ͯͨ࣌ͷ࿩ $JUVTͱͷग़ձ͍

  170. $JUVTͱͷग़ձ͍

  171. $JUVTͱ͸IUUQTHJUIVCDPNDJUVTEBUBDJUVT ɾΦʔϓϯιʔεͷ1PTUHSF42-֦ு GPSLͰ͸ͳ͍  ɾߴ͍εέʔϥϏϦςΟ ɾΫΤϦฒྻԽͷͨΊͷ෼ࢄΤϯδϯ ɾϚϧνςφϯτΞϓϦΛߟྀͨ͠ઃܭ ɾͱʹ͔͘ϚΠάϨʔγϣϯ͕଎͍ ɾΞϓϦέʔγϣϯ͔Β͸୯ҰͷσʔλϕʔεͷΑ͏ʹݟ͑Δ $JUVTͱͷग़ձ͍

  172. $JUVT͸ͭͷίʔσΟωʔλʔϊʔυͱ ෳ਺ͷϫʔΧʔϊʔυʹ෼͔Ε͍ͯΔ $JUVTͱͷग़ձ͍

  173. ΞϓϦέʔγϣϯ͔Β͸ ίʔσΟωʔλϊʔυʹର͠ΫΤϦΛ࣮ߦ͢Δ $JUVTͱͷग़ձ͍

  174. ίʔσΟωʔλϊʔυ͸ड͚औͬͨΫΤϦΛ ద੾ͳϫʔΧʔϊʔυʹ౤͛௚͢ $JUVTͱͷग़ձ͍

  175. ϫʔΧʔϊʔυ͸ίʔσΟωʔλϊʔυʹ ΫΤϦͷ࣮ߦ݁ՌΛฦ٫͢Δ $JUVTͱͷग़ձ͍

  176. ίʔσΟωʔλϊʔυ͸ ϫʔΧʔϊʔυ͔Βͷ݁ՌΛΞϓϦέʔγϣϯʹฦ͢ $JUVTͱͷग़ձ͍

  177. ΫΤϦ͕ෳ਺ͷϊʔυΛ·͙ͨ৔߹΋ ίʔσΟωʔλϊʔυ͕͏·͘ूܭͯ݁͠ՌΛฦ͢ $JUVTͱͷग़ձ͍

  178. "-5&35"#-&΋౰વ͍͚Δ $JUVTͱͷग़ձ͍

  179. ͍͢͝ʜʜ

  180. Ͱ΋ࣗ෼Ͱཱͯͳ͍ͱ ͍͚ͳ͍ΜͰ͠ΐʁ

  181. $JUVT$MPVEIUUQTXXXDJUVTEBUBDPNQSPEVDUDMPVE $JUVTࣾެࣜͷ%BUBCBTFBTB4FSWJDF "84౦ژϦʔδϣϯ্ʹ΋ϗεςΟϯάՄೳ $JUVTͱͷग़ձ͍

  182. έʔΩ৯ͬͯΔ ৔߹͡ΌͶ͑

  183. $JUVTͱͷग़ձ͍

  184. Ϛϧνςφϯγʔͷݕূ༻ΞϓϦΛ࡞੒ ࡶʹ ςφϯτΛ࡞੒ͯ͠ ద౰ʹ਺ઍສϨίʔυੜ੒ޙECNJHSBUFΛ͔͚Δ $JUVTͱͷग़ձ͍

  185. BQBSUNFOUHFN͔Βൺֱత৐Γ׵͕͑༰қͳ $JUVT͕ࣾఏڙ͢ΔBDUJWFSFDPSENVMUJUFOBOUHFN IUUQTHJUIVCDPNDJUVTEBUBBDUJWFSFDPSENVMUJUFOBOU $JUVTͱͷग़ձ͍

  186. ݟ͚ͭͨͧʜʜ ۜͷ஄ؙʜʜ

  187. %#ϨΠϠͷ໰୊͕ %#ϨΠϠͰղܾ͢Δͬͯ ࠷ߴ͡ΌΜʜʜ

  188. $JUVT$MPVEҠߦ ϓϩδΣΫτ

  189. ·ͣ͸Ҡߦର৅Λ੔ཧ

  190. Ҡߦલ ҠߦલͱҠߦޙͷࠩ෼ 1PTUHSF42- $JUVT$MPVE Ҡߦޙ .Z42- "843%4

  191. Ҡߦલ ҠߦલͱҠߦޙͷࠩ෼ 1PTUHSF42- $JUVT$MPVE QHHFN BDUJWFSFDPSENVMUJUFOBOUHFN ୯ҰεΩʔϚ Ҡߦޙ .Z42- "843%4

    NZTRMHFN BQBSUNFOUHFN ෼ࢄεΩʔϚ

  192. ͋ͬɺओΩʔͲ͏͠Α

  193. ڧ͍ؾ࣋ͪͰ ࣗ෼Ͱ࣮૷͠ͳ͍

  194. Ҡߦલ ҠߦલͱҠߦޙͷࠩ෼ 1PTUHSF42- $JUVT$MPVE QHHFN BDUJWFSFDPSENVMUJUFOBOUHFN ୯ҰεΩʔϚ ओΩʔ66*% 4ͷΩʔ66*% Ҡߦޙ

    .Z42- "843%4 NZTRMHFN BQBSUNFOUHFN ෼ࢄεΩʔϚ ओΩʔ࿈൪ 4ͷΩʔ࿈൪

  195. ͦ΋ͦ΋.Z42-ͱ1PTUHSF42-ͷҧ͍ Α͘஌ΒΜ͠ͳ͋ʜʜ ࠩ෼ΛຒΊΔํ๏

  196. ࠩ෼ΛຒΊΔํ๏

  197. ͸͍

  198. ࠩ෼ΛຒΊΔํ๏

  199. ࠩ෼ΛຒΊΔํ๏

  200. ੟ਓ͔ʜʜ

  201. ͱ͸͍͑·ͣ͸ σʔλҠߦͳ͠Ͱ֬ೝ

  202. ॳख͸ECDPOOFDUPS͔Β

  203. BQBSUNFOUHFN͸࢒ͨ͠·· NZTRM͸  QHBDUJWFSFDPSENVMUJUFOOBUHFNΛ௥Ճ ॳख͸ECDPOOFDUPS͔Β

  204. ॳख͸ECDPOOFDUPS͔Β ͜͏͍͏ͷˣ

  205. ೥໌͚͔Β̏िؒ ಈ࡞֬ೝ੒ޭ

  206. ͔͜͜͠͠Ͱ໰୊͕

  207. ࢥ͍ग़͢γϦʔζ ͭ·Γػೳվम͸جຊతʹϚΠάϨʔγϣϯΛ൐͏

  208. ͏Θͬʜʜ ػೳ։ൃʹ൐͏ εΩʔϚมߋଟ͗͢ʜʜ

  209. σʔλϕʔεҠߦϓϩδΣΫτΛ΍͍ͬͯΔͷʹ ຖिεΩʔϚมߋ͕ى͜Δঢ়ଶͰ Ͳ͏΍ͬͯσʔλҠߦ͕ Ͱ͖͍ͯΔ͜ͱΛݕূ͢Δͷ͔ʜʜ ͱ͸͍͑ػೳ։ൃΛࢭΊΔΘ͚ʹ͸ʜʜ %#ࠩ෼͕ຖिൃੜ

  210. ͍΍ ͜͜͸ڧ͍ؾ࣋ͪͰ ࢭΊͳ͚Ε͹

  211. ϓϩμΫτνʔϜ૬ஊͷ΋ͱ̑ʙ݄̒ʹ͔͚ͯ ʮ4NBSU)3ຊମͷ։ൃΛҰϲ݄ఀࢭ͠·͢ʯ Λશࣾతʹڞ༗ ίʔυϑϦʔζ·Ͱʹؒʹ߹Θ͍ͤͨνέοτͷ ༏ઌ౓ௐ੔΍ɺظؒதͷෆ۩߹ରԠํ਑ʹ͍ͭͯ੔උ ίʔυϑϦʔζͷ༧ࠂ

  212. ·ͨɺίʔυϑϦʔζظؒத͸ ΧελϚʔαϙʔτνʔϜ͕2"ΛόοΫΞοϓ ଞ෦ॺͷํʑ΋ࣄ৘Λঝ஌ͷ্Ͱద੾ͳಈ͖Λݕ౼ ίʔυϑϦʔζͷ༧ࠂ

  213. ͓٬༷޲͚ͷࠂ஌ϒϩά΋هड़ αʔϏεαΠτͷ͓஌ΒͤͱςοΫϒϩάهࣄͰ าௐΛ߹ΘͤΔͷ͸ྑ͍ࢼΈͰͨ͠ ίʔυϑϦʔζͷ༧ࠂ

  214. σʔλҠߦʹ޲͚ͨ ૊৫ମ੍͕੔͖ͬͯͨ

  215. σʔλҠߦ΋ ४උ͠ͳ͚Ε͹

  216. σʔλҠߦޙ͸ओΩʔΛ66*%ʹ͢Δ͚Ͳ ༧Ί࠾൪͓͍ͯͨ͠ํ͕Կ͔ͱศརͩΑͶ ʢϦϨʔγϣϯͷுΓ௚͠ͱ͔ʣ ˠશςʔϒϧʹVVJEΧϥϜΛੜ΍͢ ˠVVJEΛ࠾൪ࣗಈͰ࠾൪͞ΕΔΑ͏ʹ ˠVVJEʹ/05/6--੍໿Λ෇༩ σʔλҠߦʹ޲͚ͨ४උ

  217. શςʔϒϧʹ VVJEΧϥϜΛੜ΍͢ ʜʜ͋ͬʢ࡯͠ʣ

  218. 4NBSU)3ͷ౰࣌ͷςʔϒϧ਺͸ ͦΕΒશͯʹରͯ͠ 6/*26&੍໿෇͖ TUSJOHΧϥϜΛ௥Ճ શςʔϒϧʹΧϥϜΛੜ΍͢

  219. ϚΠάϨʔγϣϯ౰೔ શςʔϒϧʹΧϥϜΛੜ΍͢

  220. ͦͯ͜͠ͷϚΠάϨʔγϣϯͰΑ͏΍͘ؾ͕ͭ͘ શςʔϒϧʹΧϥϜΛੜ΍͢

  221. ͦͯ͜͠ͷϚΠάϨʔγϣϯͰΑ͏΍͘ؾ͕ͭ͘ ฒྻϚΠάϨʔγϣϯʹ ʢ͋·Γʣҙຯ͕ͳ͔ͬͨ͜ͱΛʜʜ શςʔϒϧʹΧϥϜΛੜ΍͢

  222. ͪͳΈʹ.Z42-෇ଐͷ66*%ؔ਺͸ 66*%W UJNFTUBNQ෇ ͳͷͰ 66*%WܗࣜͰࣗಈ࠾൪͍ͨ͠ͳΒ "DUJWF3FDPSEଆͰҰ޻෉͢Δඞཁ͋Γ BGUFS@JOJUJBMJ[F͸BDUJWFSFDPSEJNQPSU޲͚ .Z42-Ͱ΋66*%ࣗಈ࠾൪

  223. શͯͷϨίʔυʹ66*%͕࠾൪͞ΕΔΑ͏ʹͳΓ σʔλҠߦલޙͷಈ࡞֬ೝΛָʹ͢ΔͨΊϓνIBDL .Z42-Ͱ΋66*%ࣗಈ࠾൪

  224. ͕ͯ͜͜͞େҰ൪

  225. σʔλҠߦ͋Ε͜Ε

  226. σʔλҠߦํ๏ͷௐࠪ MySQL DB instance Amazon RDS Postgre SQL instance ԿΒ͔ͷํ๏

  227. σʔλҠߦํ๏ͷௐࠪ ཁ݅ ɹ׬શͳΔఀࢭ͕ڐ༰͞ΕΔ࣌ؒ಺ʹ ɹશͯͷσʔλҠߦ޻ఔ͕׬ྃ͢Δ͜ͱ ˠଟ෼ɺ౔೔ͷ̎೔͕ؒݶ౓͡Όͳ͍͔ͳ

  228. σʔλҠߦํ๏ͷௐࠪ ·ͣ͸$JUVT 1PTUHSF42- Λௐࠪͯ͠ΈΑ͏ Postgre SQL instance

  229. σʔλҠߦํ๏ͷௐࠪ

  230. σʔλҠߦํ๏ͷௐࠪ

  231. σʔλҠߦํ๏ͷௐࠪ $JUVTͷ$01:จʹΑΔΠϯϙʔτ͸࣮ࡍ଎͍ ϫβϚΤʂʢඵؒສϨίʔυͬͯ  Ҿ༻ݩ$01:JOUPEJTUSJCVUFE1PTUHSF42-UBCMFT VQUPd.SPXTTFD$JUVT%BUB IUUQTXXXDJUVTEBUBDPNCMPHDPQZQPTUHSFTRMEJTUSJCVUFEUBCMFT

  232. σʔλҠߦํ๏ͷௐࠪ $JUVT΁ͷΠϯϙʔτʹର͢Δෆ҆͸ͳ͘ͳͬͨ "843%4 .Z42- ͔Β $JUVT$MPVEʹऔΓࠐΊΔܗࣜͰ ΤΫεϙʔτ͢Δํ๏Λௐࠪ͢Δ͜ͱʹ MySQL DB instance

    Amazon RDS

  233. .Z42-͔Β$47Ͱ ΤΫεϙʔτͱݴ͑͹ NZTRMEVNQͰ͕͢

  234. σʔλҠߦํ๏ͷௐࠪ NZTRMEVNQ͸࢒೦ͳ͕Β"843%4Ͱ͸࢖͑ͳ͍ ʢσΟεΫ্΁ͷॻ͖ࠐΈݖ͕ͳ͍ͷͰʣ ಉ༷ʹ4&-&$5d*/50065'*-&౳΋ෆՄ ૉ௚ʹநग़༻ͷεΫϦϓτॻ͔͘͠ MySQL DB instance Amazon RDS

  235. 3VCZͰॻ͍ͨΒ ऴΘΒͳ͍ʢ௚ײʣ

  236. ͜ͷΑ͏ͳ42-ϑΝΠϧΛςʔϒϧຖʹ༻ҙͯ͠ʜʜ σʔλҠߦεΫϦϓτࢼ࡞ MySQL DB instance Amazon RDS

  237. ͜ͷΑ͏ͳγΣϧεΫϦϓτΛॻ͍ͯ σʔλҠߦεΫϦϓτࢼ࡞ MySQL DB instance Amazon RDS

  238. நग़͘Μࢼ࡞Ұ߸ػͷڍಈ  ύϒϦοΫ%#্ͷ5FOBOUςʔϒϧ͔Β
 શςφϯτͷ%#໊Λશ෦நग़  ϧʔϓ͠ͳ͕ΒύΠϓ্Ͱ
 Ҿ਺ల։ͯ͠઀ଓઌ%#੾ସ  NZTRMίϚϯυͷ࣮ߦ݁ՌΛඪ४ग़ྗ 

    ϦμΠϨΫτͰ೚ҙͷϑΝΠϧʹॻࠐ σʔλҠߦεΫϦϓτࢼ࡞ MySQL DB instance Amazon RDS

  239. நग़͘Μࢼ࡞Ұ߸ػͷ൓ল ɾύοτݟՄಡੑ௿͍͠ϝϯςੑ΋௿͍ ɾύΠϓͰγΣϧҾ਺ల։͕τϦοΩʔ͗͢ ɾςφϯτͷ਺͚ͩNZTRMDNE͕࣮ߦ͞Ε஗͍ σʔλҠߦεΫϦϓτࢼ࡞

  240. Ϙπ

  241. ࢼߦࡨޡͷ຤

  242. ҠߦεΫϦϓτ͸3VCZͰॻ͘ 42-ϑΝΠϧ͸FSCͰςϯϓϨʔτԽ͢Δ σʔλநग़͸QPQFOܦ༝ͰNZTRMίϚϯυୟ͘ σʔλҠߦεΫϦϓτ7

  243. Αͦ͞͏

  244.  ςʔϒϧ͝ͱͷ42-ϑΝΠϧͷςϯϓϨʔτΛ
 σʔλϕʔεεΩʔϚ͔Βࣗಈੜ੒͠FSCͰग़ྗ
 ΧϥϜͷछྨͰѻ͍Λม͍͑ͯΔ σʔλҠߦεΫϦϓτ7ྲྀΕ

  245. ग़ྗ͞ΕͨFSCΛ໨ࢹͰ֬ೝ͠ ɹϦϨʔγϣϯϙϦϞʔϑΟοΫؔ࿈ΧϥϜ Λ͍͍ײ͡ʹ΍Δ ͱΓ͋͑ͣࡶʹ-&'5065&3+0*/ͯ͠ $0"-&4$&Ͱฒ΂͓͚ͯ͹େৎ෉ʂ σʔλҠߦεΫϦϓτ7ྲྀΕ

  246. 5FOBOUςʔϒϧ͔Βσʔλϕʔε໊Λશநग़͠ FSCςϯϓϨʔτʹࠩ͠ࠐΜͩ΋ͷΛ ςʔϒϧ୯ҐͷϑΝΠϧʹ௥هग़ྗ ͢Δͱςʔϒϧͷ਺͚ͩͷ42-ϑΝΠϧ͕Ͱ͖Δ ࢼ࡞ܕͱҧ͏ͷ͸ɺͭͷ42-ϑΝΠϧʹ શςφϯτ෼ͷ4&-&$5จ͕ग़ྗ͞Ε͍ͯΔ͜ͱ σʔλҠߦεΫϦϓτ7ྲྀΕ

  247. ग़ྗ͞Εͨ42-ϑΝΠϧΛ NZTRMίϚϯυͰ౤͛ ඪ४ग़ྗΛϑΝΠϧʹॻ͖ग़͢ ͪͳΈʹNZTRMίϚϯυͷΦϓγϣϯ͸"/S
 "%#੾ସ࣌ʹςʔϒϧఆٛΛಡΈࠐ·ͳ͍ߴ଎Խ /ΧϥϜͷϔομʔΛग़ྗ͔ΒӅ͢ Sग़ྗ஋ͷΤεέʔϓม׵Λ͠ͳ͍ σʔλҠߦεΫϦϓτ7ྲྀΕ

  248. None

  249. ࠔͬͨॴ

  250. TUSJOHUFYUΧϥϜʹEPVCMFRVPUFؚ͕·Εͨ৔߹ NZTRMίϚϯυ͸཯ّʹΤεέʔϓॲཧ<>ˠ<>Λ ͯ͘͠Ε͸͠ͳ͍ͷͰɺࣗྗͰ΍Δඞཁ͕͋Δʜʜ Ͳ͏΍ͬͯʁ EPVCMFRVPUFͷΤεέʔϓ໰୊

  251. ग़ྗޙʹTFEͳͲͰ΍Δํ๏΋͋Δ͕ ετΞυϑΝϯΫγϣϯΛ࢖ͬͨΒָͰͨ͠ ͨͩ୯ʹEPVCMFRVPUF͕͋ͬͨΒ̎ͭʹ͢Δ͚ͩ  ͳ͓ܕ͸-0/(5&95ʹ͠ͳ͍ͱจࣈҎ಺ʹॖΊΒΕͯ͠·͏ EPVCMFRVPUFͷΤεέʔϓ໰୊ CREATE FUNCTION sys.CSVSTR(str LONGTEXT

    CHARSET utf8mb4) RETURNS LONGTEXT CHARSET utf8mb4 DETERMINISTIC RETURN CONCAT('"', REPLACE(str, '"', '""'), '"');

  252. ετΞυϑΝϯΫγϣϯ࡞ͬͨΒ UFYUܥΛͻͨ͢ΒғΉ EPVCMFRVPUFͷΤεέʔϓ໰୊ SELECT t.uuid AS id, '<%= tenant_id %>'

    AS tenant_id, CONCAT('"', t.id, '"') AS old_id, CONCAT('"', DATE_FORMAT(t.created_at, '%Y-%m-%d %T'), '"') AS created_at, CONCAT('"', DATE_FORMAT(t.updated_at, '%Y-%m-%d %T'), '"') AS updated_at, sys.CSVSTR(t.country_number) AS country_number, sys.CSVSTR(t.zip_code) AS zip_code, sys.CSVSTR(t.pref) AS pref, sys.CSVSTR(t.city) AS city, sys.CSVSTR(t.street) AS street, sys.CSVSTR(t.building) AS building, sys.CSVSTR(t.literal_yomi) AS literal_yomi FROM <%= dbname %>.addresses AS t ORDER BY t.id ASC;

  253. ྫ͑͹ͱ͋ΔϢʔβͷট଴ऀϢʔβ͕࡟আ͞Εͯͨ ҰԠট଴ऀͷ*%ͷ਺஋͕ΧϥϜʹ࢒͍ͬͯΔ͕ɺ 66*%Ҡߦʹ൐͍Ͳ͏ʹ͔͠ͳ͍ͱ͍͚ͳ͍ ͔ͱ͍ͬͯϥϯμϜͳ66*%Λ࠾൪͢ΔΘ͚ʹ͸ ͜Ε΋ετΞυϑΝϯΫγϣϯͰͳΜͱ͔͠·͠ΐ͏ ϦϨʔγϣϯઌͷϨίʔυ͕ͳ͍

  254. ফ͑ͨࢀরઌͷςʔϒϧ໊JEςφϯτJEΛ౉͢ͱ 66*%Λฦͯ͘͠ΕΔϋογϡؔ਺ ϦϨʔγϣϯઌͷϨίʔυ͕ͳ͍ DELIMITER // CREATE FUNCTION sys.GHOSTUUID(table_name TEXT, id

    BIGINT, tenant_id TEXT) RETURNS TEXT CHARSET utf8mb4 DETERMINISTIC BEGIN SET @sha2 = SHA2(CONCAT('table_name:',table_name,'::id:',id,'::tenant_id:',tenant_id), 512); SET @uuid = CONCAT( SUBSTR(@sha2 from 10 for 8), '-', SUBSTR(@sha2 from 18 for 4), '-4', SUBSTR(@sha2 from 22 for 3), '-', LOWER(CONV(CONV(SUBSTR(@sha2 from 26 for 1), 16, 10) & 3 | 8, 10, 16)), SUBSTR(@sha2 from 27 for 3), '-', SUBSTR(@sha2 from 40 for 12) ); RETURN @uuid; END; // DELIMITER ;

  255. ଘࡏ͠ͳ͍͔΋͠Εͳ͍΍ͭ͸ ͱΓ͋͑ͣғΜͰ͓͜͏ʂ ϦϨʔγϣϯઌͷϨίʔυ͕ͳ͍ SELECT t.uuid AS id, '<%= tenant_id %>'

    AS tenant_id, CONCAT('"', t.id, '"') AS old_id, CONCAT('"', DATE_FORMAT(t.created_at, '%Y-%m-%d %T'), '"') AS created_at, CONCAT('"', DATE_FORMAT(t.updated_at, '%Y-%m-%d %T'), '"') AS updated_at, COALESCE(s.uuid, sys.GHOSTUUID('Payslip', t.payslip_id, '<%= tenant_id %>')) AS payslip_id, sys.CSVSTR(t.name) AS name, t.amount AS amount FROM <%= dbname %>.deductions AS t LEFT OUTER JOIN <%= dbname %>.payslips AS s ON t.payslip_id = s.id ORDER BY t.id ASC ;

  256. ετΞυϑΝϯΫγϣϯ ศརա͗Δ

  257. ͦͯ͠Ҡߦ౰೔

  258. None
  259. None
  260. None
  261. None

  262. ಛʹେ͖ͳτϥϒϧ΋ͳ͘

  263. None
  264. None

  265. 46$$&44

  266. None
  267. None
  268. None

  269. ৼΓฦΓ

  270. ৼΓฦΓ ੒ޭͷҰ൪ͷཁҼ͸πΠολʔઈͪ

  271. ৼΓฦΓ ੒ޭͷҰ൪ͷཁҼ͸πΠολʔઈͪ ʜʜΛؚΊͨɺ͜ͷϓϩδΣΫτ͚ͩʹ ूதͰ͖Δ؀ڥΛपғʹ੔͑ͯ΋Βͬͨ͜ͱ ݕূʹे෼ͳ͕࣌ؒ͋ͬͨ͜ͱͰ ෆ҆ͳ͘ҠߦΛ͢Δ͜ͱ͕Ͱ͖ͨ

  272. ৼΓฦΓ ޙ͸ແཧΛͨ͠࡞ΓࠐΈΛ͠ͳ͔ͬͨ͜ͱ ʢద੾ͳଥڠ͕Ͱ͖ͨʣ ݩ͕γϯϓϧͳঢ়ଶͰ͋Ε͹ ผͷঢ়ଶʹ͍࣋ͬͯ͘͜ͱ΋ͨ΍͍͢ ٕज़બఆ͸ͨͩબͿ࡞Δ͚ͩͰ͸ͳ͘ ͔ͦ͜Βޙ໭Γ͕Ͱ͖Δ͔Ͳ͏͔ͱ͍͏ᄿ֮΋େࣄ

  273. ৼΓฦΓ ࠓճ͸͍ͬͱ͖ͷ੒ޭΛऩΊ·͕ͨ͠ কདྷͷ͋Δ࣌఺ʹ͓͍ͯ੒ޭ͔Ͳ͏͔͸෼͔Βͳ͍ ຊ౰ͷධՁʹ͸ྺ࢙ͷ൑அ͕ඞཁ ͱ͸͍͑๻ͨͪ͸͜Ε͔Β$JUVTͱ΍͍͖ͬͯ·͢

  274. Զͨͪͷઓ͍͸ ·ͩ·ͩ͜Ε͔Βͩ

  275. 4NBSU)3Ϛϧνςφϯτ೥ද         

        ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺ 4NBSU)3ެ։ ೥݄ JOJUJBMDPNNJU ೥݄ ฒྻNJHSBUF ࢼ࡞൛ σϓϩΠ໰୊͕ ঃʑʹݦࡏԽ QVSJOUBJೖࣾ ଟஈσϓϩΠͷಋೖ ৳ͼଓ͚Δ σϓϩΠ࣌ؒ αʔϏεো֐ൃੜ ఆظϝϯςମ੍ ελʔτ $JUVTͱͷग़ձ͍ $JUVT$MPVE Ҡߦ1+ελʔτ ίʔυϑϦʔζ❄ $JUVT$MPVE Ҡߦ੒ޭʂ ͝ਗ਼ௌ ͋Γ͕ͱ͏͍͟͝·ͨ͠