Save 37% off PRO during our Black Friday Sale! »

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

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

Ca6281fff64797dc419b78f51f25c0a5?s=128

FUJIWARA Shunichiro
PRO

September 29, 2021
Tweet

Transcript

  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. ΅͘ΒͷʂߕࢠԂϙέοτ ʹ͍ͭͯ

  6. None
  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ؒͷσʔλίϐʔΛฒྻ࣮ߦͰߴ଎ʹ

    • εφοϓγϣοτ͔Βͷ෮ݩͰසൟͳϦϋʔαϧΛՄೳʹ