Pro Yearly is on sale from $80 to $50! »

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

606d4feb3bf3293d04816e3938941e66?s=47 Purintai
September 08, 2018

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

606d4feb3bf3293d04816e3938941e66?s=128

Purintai

September 08, 2018
Tweet

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 Ҡߦ੒ޭʂ ͝ਗ਼ௌ ͋Γ͕ͱ͏͍͟͝·ͨ͠