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

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

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

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

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

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

Ұํઌिͷ ࢲͷπΠʔτΛݟ·͠ΐ͏

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

̍िؒμ΢ϯ͠·͕ͨ͠ ͳΜͱ͔ؒʹ߹͍·ͨ͠

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

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

σϓϩΠʹֻ͕͔࣌ؒΓ͗͢

σϓϩΠʹֻ͕͔࣌ؒΓ͗͢ ຊ౰ʹ͔͔࣌ؒΓ·ͨ͠

ͳͥ͜Μͳ͜ͱʹ ͳͬͯ͠·ͬͨΜͩ

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

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

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

ΞδΣϯμ w Ϛϧνςφϯτͱ͸ w 4NBSU)3ͷϚϧνςφϯτ w BQBSUNFOUͷམͱ݀͠ w 4NBSU)3Ϛϧνςφϯτ೥ද w
$JUVT$MPVEҠߦϓϩδΣΫτ w σʔλҠߦ͋Ε͜Ε w ৼΓฦΓ

Ϛϧνςφϯτͱ͸

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

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

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

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

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

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

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

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

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

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

͍͚ͦ͏

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

BQBSUNFOUͷڍಈ ςφϯτ୯ҐͰσʔλϕʔε͕࡞੒͞ΕΔͷͰ ແ഑ྀʹ$SFXGJSTU 4&-&$5 '30.DSFXT-*.*5 ͱ͔΍ͬͯ΋ଞςφϯτͷσʔλ͕ࠞ͟Βͳ͍☺ ΋͠BQBSUNFOUΛ࢖Θͳ͍ͳΒ ಉ͡ςʔϒϧʹผςφϯτͷϨίʔυ͕ࠞ͟ΔͳΒ $SFXXIFSF
UFOBOU@JE GJSTUͬͯຖճࢦఆ͠ͳ͍ͱ 4&-&$5 '30.DSFXT 8)&3&AUFOBOU@JEA-*.*5

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

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

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

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

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

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

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

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

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

<FYBNQMF> BQBSUNFOUͷڍಈ 4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌ Amazon RDS Amazon ElastiCache AWS Elastic
Beanstalk Amazon S3 BQBSUNFOU FY3FEJTͱ4͸੾Γସ͑தͷςφϯτ*%Λ ͦΕͧΕOBNFTQBDFσΟϨΫτϦύεʹར༻͠෼཭ <FYBNQMF>

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

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

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

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

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

BQBSUNFOUͷམͱ݀͠

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

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

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

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

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

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

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

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

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

ϚΠάϨʔγϣϯ໰୊

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

%#ϒʔτλΠϜ໰୊

͜ͷ··Ͱ͸·͍ͣ ͳͥͳΒʜʜ

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

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

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

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

͜ͷ··Ͱ͸·͍ͣʜʜ

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

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

4NBSU)3Ϛϧνςφϯτ೥ද ܧଓར༻཰
ࣾ ར༻اۀ਺

4NBSU)3Ϛϧνςφϯτ೥ද
೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ೥ 2 ར༻اۀ਺

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

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

JOJUJBMDPNNJU

BQBSUNFOU͕(FNGJMFʹ௥Ճ͞Εͨͷ͸िؒޙ JOJUJBMDPNNJU

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

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

ϚΠάϨʔγϣϯฒྻԽ

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

͜ͷ࣌͸·ͩ Կ΋஌Βͳ͔ͬͨ

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

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

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

σϓϩΠ໰୊͕ݦࡏԽͩ͢͠ 8FCίϯςφͷσϓϩΠ͸ऴΘͬͯΔͷʹ ϚΠάϨʔγϣϯ͸ऴΘͬͯͳ͍ʂ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ ୅ද 8FCίϯςφ ϚΠάϨʔγϣϯ࣮ߦத
$3&"5&5"#-&DPNNFOUT ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧͳ͍

Τϥʔ

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

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

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

ଟஈσϓϩΠͷಋೖ

ଟஈσϓϩΠͷಋೖ ઌʹNJHSBUJPO؀ڥͰϚΠάϨʔγϣϯ࣮ߦ ׬ྃޙʹXFC؀ڥʹσϓϩΠ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ϚΠάϨʔγϣϯ࣮ߦத
$3&"5&5"#-&DPNNFOUT 8FCίϯςφ DPNNFOUTͷ ଘࡏΛ஌Βͳ͍ 8FCίϯςφ DPNNFOUTͷ ଘࡏΛ஌Βͳ͍

ଟஈσϓϩΠͷಋೖ ઌʹNJHSBUJPO؀ڥͰϚΠάϨʔγϣϯ࣮ߦ ׬ྃޙʹXFC؀ڥʹσϓϩΠ ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ϚΠάϨʔγϣϯ׬ྃ $3&"5&5"#-&DPNNFOUT 8FCίϯςφ
DPNNFOUTͷ ଘࡏΛ஌Βͳ͍ 8FCίϯςφ DPNNFOUTͷ ଘࡏΛ஌Βͳ͍

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

͔ͯ࣌ؒ͠͠͸ ͔͔ΔΑ͏ʹͳͬͨ

ฒྻ࣮ߦͷເ

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

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

৳ͼଓ͚ΔσϓϩΠ࣌ؒ

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

͍ͦͯͭ͠ʹ ͋ͷൿີฌث͕

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

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

͖ͨʂ͜ΕͰউͭΔʂ

࣮ઓ౤ೖޙ

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

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

ىͬͨ͜͜ͱ

·ͨผͷ೔͸ ผͷཧ༝Ͱཱͯଓ͚ʹ σϓϩΠࣦഊ

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

ਃ͠༁͍͟͝·ͤΜ Ͱͨ͠

͜ΕΛ͖͔͚ͬʹ ਂ໷ఆظϝϯςφϯε͕ ͸͡·Δʜʜ

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

ٳܜ͕ͯΒ ͜͜·Ͱͷ໰୊ͷ੔ཧ

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

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

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

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

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

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

ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ༏ઌ౓ߴ͕ऴྃͨ͠Βݟ੾ΓσϓϩΠͯ͠͠·͏ɹɹɹɹ ༏ઌϚΠάϨʔγϣϯ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ༏ઌ౓ߴ ༏ઌ౓த
༏ઌ౓௿ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧͳ͍

ϚΠάϨʔγϣϯ ׬ྃςφϯτ܈ ༏ઌ౓தɾ௿܈͕ΞΫηε͢ΔͱΤϥʔʹͳΔ͕ ࣮ࡍΞΫηεස౓͕௿͍܈ͳͷͰ໰୊͕ى͖ͳ͍ ༏ઌϚΠάϨʔγϣϯ ϚΠάϨʔγϣϯ ະ׬ྃςφϯτ܈ NJHSBUJPO ίϯςφ ༏ઌ౓ߴ
༏ઌ౓த ༏ઌ౓௿ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧ͋Δ ৽͍͠ 8FCίϯςφ DPNNFOUT ςʔϒϧͳ͍

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

গ͠ޮՌ͸͋ͬͨ

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

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

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

ͪΐͬͱ଴ͪͨ·͑

ͦ΋ͦ΋4NBSU)3͸

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

ͳͥϢʔβ͕ ύϒϦοΫ%#্ʹʁ

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

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

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

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

ͱ͜ΖͰ

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

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

શ͘ޮՌ͕ग़ͳ͔ͬͨ ͋ͷൿີฌثͷ͜ͱΛʜ

ࢥ͍ग़͢γϦʔζ

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

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

ਖ਼ղ͸ʜʜ

ਖ਼ղ͸ʜʜඵͰ͢

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

஌Βͳ͔ͬͨ

஌Βͳ͔ͬͨ Λฉ͚·͔ͨ͠ʁ

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

͓͋ͱ͕ΑΖ͍͠Α͏Ͱ

εϥΠυޙ൒ελʔτ

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

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

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

ͦΕ͸)FSPLV1PTUHSFTΛௐ΂͍ͯͨ࣌ͷ࿩ $JUVTͱͷग़ձ͍

$JUVTͱͷग़ձ͍

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

$JUVT͸ͭͷίʔσΟωʔλʔϊʔυͱ ෳ਺ͷϫʔΧʔϊʔυʹ෼͔Ε͍ͯΔ $JUVTͱͷग़ձ͍

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

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

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

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

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

"-5&35"#-&΋౰વ͍͚Δ $JUVTͱͷग़ձ͍

͍͢͝ʜʜ

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

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

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

$JUVTͱͷग़ձ͍

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

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

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

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

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

·ͣ͸Ҡߦର৅Λ੔ཧ

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

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

͋ͬɺओΩʔͲ͏͠Α

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

Ҡߦલ ҠߦલͱҠߦޙͷࠩ෼ 1PTUHSF42- $JUVT$MPVE QHHFN BDUJWFSFDPSENVMUJUFOBOUHFN ୯ҰεΩʔϚ ओΩʔ66*% 4ͷΩʔ66*% Ҡߦޙ
.Z42- "843%4 NZTRMHFN BQBSUNFOUHFN ෼ࢄεΩʔϚ ओΩʔ࿈൪ 4ͷΩʔ࿈൪

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

ࠩ෼ΛຒΊΔํ๏

੟ਓ͔ʜʜ

ͱ͸͍͑·ͣ͸ σʔλҠߦͳ͠Ͱ֬ೝ

ॳख͸ECDPOOFDUPS͔Β

BQBSUNFOUHFN͸࢒ͨ͠·· NZTRM͸ QHBDUJWFSFDPSENVMUJUFOOBUHFNΛ௥Ճ ॳख͸ECDPOOFDUPS͔Β

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

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

͔͜͜͠͠Ͱ໰୊͕

ࢥ͍ग़͢γϦʔζ ͭ·Γػೳվम͸جຊతʹϚΠάϨʔγϣϯΛ൐͏

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

͕ͯ͜͜͞େҰ൪

σʔλҠߦ͋Ε͜Ε

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

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

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

σʔλҠߦํ๏ͷௐࠪ

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

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

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

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

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

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

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

நग़͘Μࢼ࡞Ұ߸ػͷڍಈ ύϒϦοΫ%#্ͷ5FOBOUςʔϒϧ͔Β  શςφϯτͷ%#໊Λશ෦நग़ ϧʔϓ͠ͳ͕ΒύΠϓ্Ͱ  Ҿ਺ల։ͯ͠઀ଓઌ%#੾ସ NZTRMίϚϯυͷ࣮ߦ݁ՌΛඪ४ग़ྗ
ϦμΠϨΫτͰ೚ҙͷϑΝΠϧʹॻࠐ σʔλҠߦεΫϦϓτࢼ࡞ MySQL DB instance Amazon RDS

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

ࢼߦࡨޡͷ຤

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

Αͦ͞͏

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

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

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

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

ࠔͬͨॴ

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

ग़ྗޙʹTFEͳͲͰ΍Δํ๏΋͋Δ͕ ετΞυϑΝϯΫγϣϯΛ࢖ͬͨΒָͰͨ͠ ͨͩ୯ʹEPVCMFRVPUF͕͋ͬͨΒ̎ͭʹ͢Δ͚ͩ ͳ͓ܕ͸-0/(5&95ʹ͠ͳ͍ͱจࣈҎ಺ʹॖΊΒΕͯ͠·͏ EPVCMFRVPUFͷΤεέʔϓ໰୊ CREATE FUNCTION sys.CSVSTR(str LONGTEXT
CHARSET utf8mb4) RETURNS LONGTEXT CHARSET utf8mb4 DETERMINISTIC RETURN CONCAT('"', REPLACE(str, '"', '""'), '"');

ετΞυϑΝϯΫγϣϯ࡞ͬͨΒ 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;

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

ফ͑ͨࢀরઌͷςʔϒϧ໊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 ;

ଘࡏ͠ͳ͍͔΋͠Εͳ͍΍ͭ͸ ͱΓ͋͑ͣғΜͰ͓͜͏ʂ ϦϨʔγϣϯઌͷϨίʔυ͕ͳ͍ 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 ;

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

ͦͯ͠Ҡߦ౰೔

ಛʹେ͖ͳτϥϒϧ΋ͳ͘

46$$&44

ৼΓฦΓ

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

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

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

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

Զͨͪͷઓ͍͸ ·ͩ·ͩ͜Ε͔Βͩ

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

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

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

More Decks by Purintai

Other Decks in Programming

Featured

Transcript