Amazon Auroraを活用したソーシャルゲームの複数ワールドデータ統合 / AWS Dev Day Online Japan

1. Amazon AuroraΛ׆༻ͨ͠ ιʔγϟϧήʔϜͷෳ਺ϫʔϧυσʔλ౷߹ Dev Day Online Japan 2021-09-29 ౻ݪ ढ़Ұ࿠ (@fujiwara)
2. @fujiwara SREνʔϜ github.com/kayac/ecspresso Amazon ECS σϓϩΠπʔϧ github.com/fujiwara/lambroll AWS Lambda σϓϩΠπʔϧ ISUCON11 ! ༏উ (4ճ໨)
3. Game & Community
4. Agenda • ΅͘ΒͷߕࢠԂʂϙέοτ ʹ͍ͭͯ • ήʔϜϫʔϧυͷ௥Ճͱ౷߹ͷܦҢ • ;ͨͭͷσʔλϕʔεΛͻͱͭʹ • Amazon Aurora Λ׆༻ͨ͠ߴ଎ͳ σʔλҠߦͱݕূ
5. ΅͘ΒͷʂߕࢠԂϙέοτ ʹ͍ͭͯ
7. ΅͘ΒͷʂߕࢠԂϙέοτ ήʔϜγεςϜ 2014೥9݄ϦϦʔεͷεϚʔτϑΥϯ޲͚ήʔϜ (7प೥!) ϓϨΠϠʔ͸ʮߴߍٿࣇʯʹͳΔ ϛχήʔϜͰͷ࿅शɺ૷උΛڧ͘͢ΔͳͲͰྗΛ෇͚͍ͯ͘ ֶߍʹෳ਺ͷϓϨΠϠʔ͕ू·ͬͯɺ1೔4ճ૊·ΕΔࢼ߹ʹࢀՃ ૬ख΋࣮ࡏͷϓϨΠϠʔ͕ू·ͬͯߏ੒͞ΕͨνʔϜ ͍ΘΏΔCPUઓ͸ͳ͍ ࢼ߹͸αʔόʔଆͰόονॲཧʹΑͬͯਐߦͯ݁͠Ռ͕ग़Δ
8. ΅͘ΒͷʂߕࢠԂϙέοτ αʔόʔ؀ڥ 2014೥9݄ϦϦʔε࣌఺͔Β͢΂ͯ Amazon Web Services(AWS) Amazon Elastic Compute Cloud (EC2) Amazon RDS for MySQL Amazon ElastiCache for Redis Amazon Redshift 2016೥10݄ RDS for MySQL → Aurora MySQL 2021೥3݄ EC2 → Amazon Elastic Container Service(ECS)
9. ήʔϜϫʔϧυͷ௥Ճͱ౷߹ͷܦҢ
10. ҰൠతͳεϚʔτϑΥϯ޲͚ήʔϜͷ Ϣʔβʔ਺ਪҠ (֓೦) 1. ϦϦʔεޙҰఆظؒ·Ͱٸܹʹ૿Ճ 2. ؇΍͔ʹݮগ 3. ޿ࠂ΍ίϥϘࢪࡦͰҰ࣌తʹ૿Ճ 2→3→2→3 Λ܁Γฦ͢ ଛӹ෼ذ఺ΛԼճΓ ҡ࣋Ͱ͖ͳ͘ͳΔͱαʔϏεऴྃ΁ ͲΕ͚ͩݮগΛ؇΍͔ʹͰ͖Δ͔Ͱ ण໋͕มΘͬͯ͘Δ
11. GvG (guild versus guild) ήʔϜͷಛੑ ϦϦʔε࣌఺Ͱ͸ͻͱͭͷϫʔϧυ͔͠ͳ͔ͬͨ GvG ήʔϜ = ରਓؒ(νʔϜ)ઓ ࢒͍ͬͯΔϢʔβʔ͸೥݄ͱͱ΋ʹͲΜͲΜڧ͘ͳ͍ͬͯ͘ • ৽نϢʔβʔ͕ೖͬͯ΋ͳ͔ͳ͔উͯͳ͍ • ͔ͤͬ͘ೖ͖ͬͯͯ͘Εͨ৽نϢʔβʔ͕ఆண͠ͳ͍ ݮগ͕Ճ଎͢ΔͱαʔϏε͕ҡ࣋Ͱ͖ͳ͍ 㱺 ·ͬ͞Βͳ৽نϫʔϧυΛ௥Ճ͠Α͏ʂ ৽نϢʔβʔ͕ઓ͑ΔੈքΛ༻ҙͯ͠ɺͦ͜Ͱఆணͯ͠΋Β͏
12. ϫʔϧυ௥Ճͷ࣮ࢪ ϦϦʔε͔Β1೥൒ޙɺ2016೥2݄ݕ౼։࢝ ׬શʹಠཱͨ͠σʔλϕʔεͱΞϓϦέʔγϣϯΛ௥Ճ͢Δ࣮૷ • Ϛελʔσʔλ(ΞΠςϜͳͲ)͸׬શʹಉҰ • ֤ϫʔϧυؒͰϢʔβʔσʔλͷҠߦ͸Ͱ͖ͳ͍ • ϓϨΠ͢ΔϫʔϧυΛҰ౓બ୒ͨ͠Β ผϫʔϧυͰ͸ϓϨΠͰ͖ͳ͍ • جຊతʹ֤ϫʔϧυͷαʔόʔؒͰ௨৴͸͠ͳ͍ (ྫ֎: σϓϩΠૢ࡞΍Redshift΁ͷΫΤϦ͸1Χॴ͔Βߦ͑Δ)
13. 2016೥8݄ ৽ϫʔϧυ௥Ճ
14. ͍͔ͭऴΘΔ͜ͱΛߟ͑ͯɺ௥Ճ௚ޙʹ౷߹ʹ͍ͭͯ΋ݕ౼͞Ε͍ͯͨ (͑Β͍)
15. ͦͯ͠2021೥ɺϫʔϧυʮ౷߹ʯ΁ αʔϏε։͔࢝Β6೥ɺϫʔϧυ௥Ճ͔Β΋4೥͕ܦա ϓϩσϡʔαʔஊʮ࣍͸10प೥Λ໨ࢦ͍ͨ͠ʯ ήʔϜͷಛੑ্ɺϓϨΠϠʔ͕ଟ͍΄͏͕໘ന͍ • ΞΫςΟϒͳνʔϜͱରઓͯ͠উͭ΄͏͕໘ന͍ • ৽Ϣʔβʔ͕ผʑͷϫʔϧυʹ഑ஔ͞ΕΔͱ૿͑ͮΒ͍ 㱺 ΞΫςΟϒͳϢʔβʔ਺ΛҰఆҎ্ʹอͭͨΊʹ ෼͔Ε͍ͯΔϫʔϧυΛ౷߹͍ͨ͠
16. ͱ͜ΖͰϫʔϧυ௥Ճ࣌ͷ࣮૷͸… ·ͬͨ͘ผͷγεςϜΛ ΋͏Ұݸཱͯͨঢ়ଶ ELB, ΞϓϦέʔγϣϯαʔό, Aurora, ElastiCache, ... Auroraʹೖ͍ͬͯΔσʔλͷID͸ AUTO_INCREMENT Ͱൃ൪ INSERT ͞ΕΔ͝ͱʹ1ͣͭࣗಈͰ૿͑ ͍ͯ͘஋͕ओΩʔ 㱺 ϫʔϧυA/BͰσʔλͷID͕ॏෳ
17. σʔλͷID͕ॏෳɺͱ͸ ͭ·Γ౷߹લ͸͜͏ • ϫʔϧυA/Bͷ player.id = 100͸ શ͘ͷผਓ • ϫʔϧυA/Bͷ player_item.id = 1000 ͸׬શʹผ෺ • player_item.player_id = 100 ͕ࢀর͢Δઌ(player.id)΋౰વผਓ Ͳ͏ͨ͠Β…
18. ຅Ҋ • શͯͷσʔλΛϫʔϧυΛؚΊͨෳ߹ओΩʔʹ͢Δ ! ΞϓϦέʔγϣϯͷมߋൣғ͕େ͖͗͢Δ (ίʔυͱςετΛ߹Θͤͯ50ສߦఔ౓͋ΔͷͰ…) • ҠߦظؒΛઃ͚ͯͦΕͧΕͷϢʔβʔʹखଓ͖Λͯ͠΋Β͏ →Ϣʔβʔσʔλ୯ҐͰόονॲཧͰҠߦ ! ͦ͜Ͱڈͬͯ͠·͏Ϣʔβʔ͕େྔʹग़ΔՄೳੑ
19. ཁ݅ ʮϢʔβʔ͸Կ΋͠ͳ͍Ͱ΋ɺ৽͍͠ϫʔϧυͰήʔϜ͕ܧଓͰ͖Δʯ ݱঢ় • ֎෦ʹ಺෦ͷIDΛ࿐ग़͍ͯ͠Δͱ͜Ζ͸ͳ͍ • ͭ·Γ಺෦ͷID͸ɺ੔߹ੑ͕อ͍ͯͯΕ͹ผͷ஋ʹͯ͠Α͍ ͭ·Γ ֤ϫʔϧυʹଘࡏ͢ΔશϢʔβʔσʔλͷID(֎෦ࢀরؚΉ)Λ িಥ͠ͳ͍Α͏ʹ͢΂ͯॻ͖׵͑Ε͹Α͍ ຊ౰ʹ΍Δͷ…?
20. ;ͨͭͷσʔλϕʔεΛͻͱͭʹ
21. ID ΛৼΓ௚͢ ϫʔϧυAͷϢʔβʔσʔλͷIDͱϫʔϧυBͷIDΛ ॏෳ͠ͳ͍Α͏ʹશͯ࠶ൃ൪͢Δ • ͻͱͭͷςʔϒϧʹ͸࠷େͰ਺ԯߦ • ͋ΔςʔϒϧͷID͸ଞͷςʔϒϧͷΧϥϜʹؚ·ΕΔ(֎෦ࢀর) • ςʔϒϧ਺500Ҏ্ • ༰ྔ͸2ϫʔϧυ߹ܭ1TBఔ౓ (Aurora snapshotͷαΠζͰ) ͜ΕΛશͯໃ६ͳ͘ॻ͖׵͑ͳ͍ͱ͍͚ͳ͍
22. ID ରԠදΛ࣋ͭ? ͨͱ͑͹id_mapςʔϒϧʹ৽چIDͷରԠදΛ࡞Δ? world old_id new_id A 1 1 B 1 2 A 2 3 ... ... ... A 9999 19999 B 9999 20000 A 10000 20001 B 10000 20002 ... ... ...
23. world old_id new_id A 9999 19999 B 9999 20000 UPDATE player SET id=(SELECT new_id FROM id_map WHERE old_id=player.id AND world='A'); UPDATE player_item SET id=(SELECT new_id FROM id_map WHERE old_id=player_item.id AND world='A'), player_id=(SELECT new_id FROM id_map WHERE old_id=player_item.player_id AND world='A'); ͜ͷαϒΫΤϦͰ਺ेԯߦΛUPDATE……ͭΒͦ͏
24. ! ౷߹ = shardingͷٯૢ࡞Ͱ͸…?
25. ҰൠతͳγϟʔσΟϯά γϟʔσΟϯά(sharding) = σʔλΛ෼ׂͯ͠ෳ਺σʔλϕʔεʹ֨ೲ id data 2 AAA 3 BBB 4 CCC 5 DDD Ұ൪୯७ͳͷ͸IDͷ৒༨(mod)ͰৼΓ෼͚ ϫʔϧυA: id data 2 AAA 4 CCC ϫʔϧυB: id data 3 BBB 5 DDD
26. ࠓճ͸෼ׂͰ͸ͳ͘౷߹ͳͷͰٯʹ͢Δ ϫʔϧυA: ৽͍͠IDΛ ʹ͢Δ data id new_id AAA 1 → 2 CCC 2 → 4 ϫʔϧυB: ৽͍͠IDΛ ʹ͢Δ data id new_id BBB 1 → 3 DDD 2 → 5 ͷIDͱ ͷID͸ ౷߹ͯ͠΋িಥ͠ͳ͍ʂ data id AAA 2 BBB 3 CCC 4 DDD 5
27. SQLͰ΋αϒΫΤϦͳ͠Ͱ؆୯ܭࢉ UPDATE player SET id=(id * 2 + 1); UPDATE player_item SET id=(id * 2 + 1), player_id=(player_id * 2 + 1); ͢΂ͯͷม׵ޙͷIDΛ͋Β͔͡ΊܾఆతʹٻΊΒΕΔ IDৼΓ௚͠໰୊͸ղܾʂ (ͨͩ͠ʮٕज़తʹ͸Մೳʯঢ়ଶ)
28. Amazon Aurora Λ׆༻ͨ͠ ߴ଎ͳσʔλҠߦͱݕূ
29. σʔλͷexportͱimportํ๏Λݕ౼ ୯७ͳํ๏: Aurora MySQL ͔Β mysqldump 1. UPDATE player SET id=(id * 2 + shard_id)... 2. mysqldump > dump.sql 3. mysql < dump.sql িಥͤ͞ͳ͍ͨΊʹ͸ɺઌʹIDΛॻ͖׵͔͑ͯΒdump͢Δඞཁ͕͋Δ • ࠷ॳͷUPDATEͰֻ͕͔࣌ؒΓͦ͏ • ਺ඦGBͷdumpσʔλ(SQL)ΛऔΓ͜Ήͱ1೔ʙ਺೔Ϩϕϧ(ܦݧଇ) ϝϯςφϯε͸Ͱ͖Δ͚ͩ୹͍ͨ͘͠
30. mysqldump Ҏ֎ͷํ๏Λߟ͑Δ • ڊେςʔϒϧͷUPDATEʹ͸ֻ͕͔࣌ؒΔ 㱺 import͢ΔσʔλࣗମΛIDॻ͖׵͑ޙͷঢ়ଶʹ͍ͨ͠ • ߴ଎ԽͷͨΊɺฒྻॲཧΛ͍ͨ͠ 㱺 ςʔϒϧ୯ҐͰ෼ׂͯ͠ॲཧ (͜Ε͸mysqldumpͰ΋Մೳ) ʮAmazon Aurora MySQL ͔Β Amazon S3 ʹσʔλΛ ΤΫεϙʔτ͓ΑͼΠϯϙʔτ͢ΔͨΊͷϕετϓϥΫςΟεʯ1 1 https://aws.amazon.com/jp/blogs/news/best-practices-for-exporting-and-importing-data-from-amazon-aurora-mysql-to- amazon-s3/
31. SELECT INTO OUTFILE S3 ͱ LOAD DATA FROM S3 1. ΫΤϦ݁ՌΛ Amazon S3 ʹ CSV ͱͯ͠ export 2. CSV Λ S3 ͔ΒಡΈࠐΜͰςʔϒϧʹ import ςʔϒϧ୯ҐͰฒྻॲཧ͕Մೳ Aurora 㱻 S3 ؒͰॲཧ͕׬݁
32. SELECT INTO OUTFILE S3 mysqldumpͱ͸ҧ͍ɺ೚ҙͷΫΤϦ݁ՌΛS3ʹ௚઀ग़ྗͰ͖Δ IDॻ͖׵͑ࡁΈͷCSV͕ग़ྗͰ͖ΔͷͰɺͦͷ··औΓ͜ΊΔ 㱺 ڊେςʔϒϧͷ UPDATE ͕ෆཁʹ SELECT id*2+1 AS id, foo, bar, ... -- IDΛॻ͖׵͑ͯ͠·͏ FROM player INTO OUTFILE S3 's3://...' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n' MANIFEST ON; MANIFEST ON : ڊେͳςʔϒϧͷ৔߹ɺෳ਺S3 objectʹ෼ׂ͞ΕΔ objectҰཡ͕هࡌ͞ΕΔϚχϑΣετϑΝΠϧΛग़ྗ͢Δ
33. LOAD DATA FROM S3 S3ʹଘࡏ͍ͯ͠ΔCSVΛςʔϒϧʹऔΓ͜Ή LOAD DATA FROM S3 MANIFEST 's3://...' INTO TABLE player FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n' (id, foo, bar, ...) SELECT INTO OUTFILE S3 Ͱग़ྗͨ͠ MANIFEST Λ ࢦఆͯ͠औΓࠐΈ
34. ฒྻॲཧ͕Մೳ SELECT INTO OUTFILE S3 ͱ LOAD DATA FROM S3 ͸ ෳ਺ηογϣϯͰಉ࣌ʹൃߦՄೳ σʔλ͸ Aurora 㱻 S3 ؒͰ௚઀సૹ͞ΕΔ ΫΤϦൃߦݩʹ͸ෛՙֻ͕͔Βͳ͍ AuroraͷϚϧνίΞͱڧྗͳετϨʔδ S3 ͷྗΛଘ෼ʹ׆༻Ͱ͖Δʂ
35. ෦෼తͳϦτϥΠΛ༰қʹ ςʔϒϧ୯ҐͰexport, import͢Δ ࣦഊΛݕ஌ͨ͠Βͦͷςʔϒϧ͚ͩϦτϥΠՄೳ λεΫΛࡉ͔͘෼ׂ + ฒྻ࣮ߦͰεϧʔϓοτΛՔ͙ 㱺 λεΫͷࣦഊΛલఏʹɺΫϥ΢υͷྗΛ׆༻͢Δ Α͘ͳ͍΍Γํͷྫ $ mysqldump -h src.host mydb | mysql -h dest.host EC2(ͳͲ)ͷ1୆ʹෛՙֻ͕͔Δ ్தͷͲ͔͜Ͱࣦഊ͢ΔͱϦτϥΠ͕ࠔ೉ Auroraଆ΋1ίΞ͔͠࢖͑ͳ͍
36. ਺ඦςʔϒϧʹରͯ͠ SQL Λੜ੒͢Δ खͰ͸ແཧͳͷͰ Perl ͷεΫϦϓτͰ…… 1. show tables ͰςʔϒϧҰཡΛऔಘ 2. ࣄલʹચ͍ग़ͨ͠ςʔϒϧ໊ɺΧϥϜ໊Λݩʹ IDม׵͕ඞཁͳςʔϒϧʹ͍ͭͯ SELECT INTO OUTFILE S3 LOAD DATA FROM S3 ͷSQLΛੜ੒
37. IDม׵ର৅ͷચ͍ग़͠ͱϧʔϧԽ xxx_id ͱ͍͏໊લ͕෇͍͍ͯΕ ͹େ఍͸ม׵ର৅ ͨͩ͠Ϛελʔσʔλ͸ม׵ର৅ Ͱ͸ͳ͍ͷͰআ֎ ஍ಓͳચ͍ग़͠࡞ۀͰϧʔϧԽ # ඞͣIDม׵ͷର৅ʹ͢ΔΧϥϜ໊ # ͜͜Ͱఆٛ͞Ε͍ͯΔ΋ͷ + # ***_idͱͭ͘΋ͷͰϚελʔσʔλςʔϒϧ͕ # ଘࡏ͠ͳ͍΋ͷ͕IDม׵ͷର৅ my $REQUIRED_CONVERT_COLUMN = { id => 1, team_id => 1, team_name_id => 1 }; # IDม׵ͷର৅ʹؚΊͳ͍ΧϥϜ໊ my $IGNORE_CONVERT_COLUMN = { synced_league_id => 1, growth_lock_league_id => 1, post_id => 1, farm_league_id => 1, character_id => 1, # ...
38. ෬ฌ JSON ΧϥϜ ʮจࣈྻܕͷΧϥϜʹJSON͕ೖ͍ͬͯͯID͕ຒ·͍ͬͯΔʯ MySQL5.6 ޓ׵ͩͬͨͨΊɺJSON ܕͰ͸ͳ͍ී௨ͷTEXTܕ Ҡߦ͕ඞཁͳର৅͸਺ςʔϒϧ͚ͩͩͬͨ(Α͔ͬͨ…) ΞϓϦέʔγϣϯͰಡΜͰॻ͖׵͑ΔରԠ
39. ؆୯ͦ͏ʹॻ͖·͕ͨ͠… ҠߦεΫϦϓτ׬੒ʹ3ϲ݄ 2021-03-09 IDม׵ɺSQLΛग़ྗ͢ΔεΫϦϓτ։ൃ։࢝ (໿50ίϛοτ) 2021-06-14 ׬੒ ྫ֎͕ଟ͗͢ΔͨΊɺಈ͔ͯ͠͸ςετ(CI, QA) Λ܁Γฦͯ͠໰୊Λ௵͍ͯ͘͠ඞཁ͕͋ͬͨ
40. QAͱϦϋʔαϧ খ͍͞σʔλ͔ΒCI, QA؀ڥʹσʔλΛ౷߹͢ΔπʔϧΛ࡞੒ CI, QA(ਓྗ)Ͱ໰୊఺Λચ͍ग़͠ 㱺 QA͸10ճҎ্࣮ࢪͯ͠໰୊Λચ͍ग़ͨ͠ ຊ൪ͷεφοϓγϣοτ͔ΒAuroraΫϥελΛ෮ݩ export, import ΛεΫϦϓτͰ࣮ߦ ్த໰୊͕ى͖ͨΒεΫϦϓτΛमਖ਼ͯ͠΍Γͳ͓͠ ໰୊ͳ͘౷߹DB͕Ͱ͖ͨΒ QA ࣮ߦ ຊ൪σʔλͰ5,6ճϦϋʔαϧ
41. Կ౓΋ຊ൪ͷσʔλͰϦϋʔαϧ͢ΔͨΊʹ TerraformͰsnapshot͔ΒͷAuroraΫϥελ෮ݩΛࣗಈԽ ࠷৽ͷεφοϓγϣοτIDͰ terraform apply ͢Δ͚ͩ ਺ඦGBͷΫϥελͰ΋1࣌ؒఔ౓ ࣮֬ʹಉ͡ઃఆͰ෮ݩͰ͖Δ resource "aws_rds_cluster" "restore" { cluster_identifier = "restore-cluster" engine = "aurora" engine_version = "5.6.mysql_aurora.1.19.5" snapshot_identifier = "arn:aws:rds:ap-northeast-1:..." // ←͚ͩ͜͜ॻ͖׵͑Δ // ...
42. ͦͷଞɺࡉ͔͍޻෉ͳͲ े਺ຊɺܭ3000ߦ΄ͲͷPerl script͕ੜΈग़͞Εͨ • ηΧϯμϦΠϯσοΫεΛ DROP, ADD ͢Δ SQLจ΋ੜ੒ • import࣌͸ηΧϯμϦΠϯσοΫε͕ͳ͍ํ͕ߴ଎ • importޙʹ·ͱΊͯ ADD INDEX ͢Δ • SELECT ࣌ʹ count(*) ͰҠߦର৅ͷߦ਺ΛϑΝΠϧʹه࿥ • LOAD ޙʹ count(*) ͨ݁͠Ռͱಥ͖߹ΘͤΔ • Ͳ͏ͯ͠΋ॏෳͯ͠͠·͏ϨίʔυΛͳΜͱ͔͢Δ • ֎෦αʔϏεͷID͕ه࿥͞Ε͍ͯΔςʔϒϧͰॏෳͳͲ • ΞϓϦέʔγϣϯཁ݅ʹैͬͯ৽͍͠΄͏Λ࢒͢ͳͲରॲ
43. Ϧϋʔαϧͷ݁Ռ export, import ͸ෳ਺ϓϩηεͰฒྻ࣮ߦ͢Δ Aurora(౷߹લ r5.4xlarge 16ίΞ, ౷߹ޙ r5.8xlarge 32ίΞ) ͱS3ͷੑೳΛҾ͖ग़ͨ͢Ί export 16ฒྻɺimport 32ฒྻͰ࣮ߦ ਺ඦGBͷIDॻ͖׵͑ͱσʔλҠߦ͕2࣌ؒͰ׬ྃʂ
44. ϦϋʔαϧͰൃ֮ͨ͠໰୊ importޙɺADD INDEX Λ32ฒྻͰ࣮ߦ͍ͯͨ͠ͱ͜Ζ… Aurora ͷۭ͖ϝϞϦ͕ރׇͯ͠ΫϥογϡˠϑΣΠϧΦʔόʔ ଴ͬͯ΋ճ෮͠ͳ͍ ฒྻ౓Λམͱͯ͠΋ރׇ͕؇΍͔ʹͳΔ͚ͩ ADD INDEX Λ൒෼΄Ͳ࣮ߦޙɺAuroraΠϯελϯεΛ࠶ىಈ ࠶ىಈޙʹ͸ϝϞϦ໰୊ͳ͠ ͕࣌ؒͳ͔ͬͨͨΊݪҼ௥ٴ͸ఘΊͯ࠶ىಈͰ৐Γ੾Δ͜ͱʹ
45. ࣮ࡍͷ౷߹ϝϯςφϯε 2021-07-04(೔) 24:00 ϝϯςφϯε։࢝ 2021-07-05(݄) ऴ೔ϝϯςφϯε 2021-07-06(Ր) 10:00 ౷߹ϫʔϧυΦʔϓϯ ߹ܭ34࣌ؒͷϝϯςφϯε ࣮ͨͩ͠ಇ͸12࣌ؒఔ౓ ʲ໨ඪʳͪΌΜͱ৸Δ
46. ࣮ࡍͷ౷߹ϝϯςφϯε(1೔໨) 2021-07-04(೔) 24:00 (ਂ໷0࣌) ϝϯςφϯε։࢝ 1. ֤ϫʔϧυͰεφοϓγϣοτऔಘ 2. εφοϓγϣοτ͔ΒҠߦ༻Ϋϥε λΛ෮ݩ 3. 01:30 AM ࠒ׬੒ͨ͠ͷͰղࢄ ݩͷΫϥελ͸ͦͷ··࢒͓ͯ͘͠ ࠷ѱɺ౷߹લͷঢ়ଶʹ੾Γ໭ͨ͢Ί
47. ࣮ࡍͷ౷߹ϝϯςφϯε(2೔໨) 2021-07-05(݄) 09:00 export։࢝ 11:00 import׬ྃ 14:00 ࣄޙॲཧؚΊͯσʔλҠߦ׬ྃ 17:00 ಈ࡞֬ೝ׬ྃɻΞϓϦετΞެ։࡞ۀ 19:00 ղࢄ
48. ࣮ࡍͷ౷߹ϝϯςφϯε(3೔໨) 2021-07-06(Ր) 09:00 ΞϓϦετΞެ։Λ֬ೝ 10:00 ϝϯςφϯεղআɻ౷߹ϫʔϧυͰΦʔϓϯ ࡉ͔͍໰୊͸͍͔ͭ͋ͬͨ͘΋ͷͷ σʔλҠߦʹ·ͭΘΔେ͖ͳ໰୊͸ൃੜͤͣ ແࣄނͰ׬ྃʂ ! ਭ຾΋͔ͬ͠ΓऔΕͨ
49. ·ͱΊ ϦϦʔε͔Β7प೥Λܴ͑ͨʮ΅͘ΒͷߕࢠԂʂϙέοτʯͰ͸ ผʑͷσʔλϕʔεʹଘࡏ͍ͯͨ͠;ͨͭͷϫʔϧυΛ ͻͱͭʹ౷߹͠·ͨ͠ Amazon AuroraͷػೳΛ׆༻͢Δ͜ͱͰɺ ෳࡶͳॻ͖׵͑Λ൐͏େྔͷσʔλҠߦΛ ҆શʹ࣮ࢪ͢Δ͜ͱ͕Ͱ͖·ͨ͠ • Aurora㱻S3ؒͷσʔλίϐʔΛฒྻ࣮ߦͰߴ଎ʹ • εφοϓγϣοτ͔Βͷ෮ݩͰසൟͳϦϋʔαϧΛՄೳʹ