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

by FUJIWARA Shunichiro

Slide 1

Slide 1 text

Amazon AuroraΛ׆༻ͨ͠ ιʔγϟϧήʔϜͷෳ਺ϫʔϧυσʔλ౷߹ Dev Day Online Japan 2021-09-29 ౻ݪ ढ़Ұ࿠ (@fujiwara)

Slide 2

Slide 2 text

@fujiwara SREνʔϜ github.com/kayac/ecspresso Amazon ECS σϓϩΠπʔϧ github.com/fujiwara/lambroll AWS Lambda σϓϩΠπʔϧ ISUCON11 ! ༏উ (4ճ໨)

Slide 3

Slide 3 text

Game & Community

Slide 4

Slide 4 text

Agenda • ΅͘ΒͷߕࢠԂʂϙέοτ ʹ͍ͭͯ • ήʔϜϫʔϧυͷ௥Ճͱ౷߹ͷܦҢ • ;ͨͭͷσʔλϕʔεΛͻͱͭʹ • Amazon Aurora Λ׆༻ͨ͠ߴ଎ͳ σʔλҠߦͱݕূ

Slide 5

Slide 5 text

΅͘ΒͷʂߕࢠԂϙέοτ ʹ͍ͭͯ

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

΅͘ΒͷʂߕࢠԂϙέοτ ήʔϜγεςϜ 2014೥9݄ϦϦʔεͷεϚʔτϑΥϯ޲͚ήʔϜ (7प೥!) ϓϨΠϠʔ͸ʮߴߍٿࣇʯʹͳΔ ϛχήʔϜͰͷ࿅शɺ૷උΛڧ͘͢ΔͳͲͰྗΛ෇͚͍ͯ͘ ֶߍʹෳ਺ͷϓϨΠϠʔ͕ू·ͬͯɺ1೔4ճ૊·ΕΔࢼ߹ʹࢀՃ ૬ख΋࣮ࡏͷϓϨΠϠʔ͕ू·ͬͯߏ੒͞ΕͨνʔϜ ͍ΘΏΔCPUઓ͸ͳ͍ ࢼ߹͸αʔόʔଆͰόονॲཧʹΑͬͯਐߦͯ݁͠Ռ͕ग़Δ

Slide 8

Slide 8 text

΅͘ΒͷʂߕࢠԂϙέοτ αʔόʔ؀ڥ 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)

Slide 9

Slide 9 text

ήʔϜϫʔϧυͷ௥Ճͱ౷߹ͷܦҢ

Slide 10

Slide 10 text

ҰൠతͳεϚʔτϑΥϯ޲͚ήʔϜͷ Ϣʔβʔ਺ਪҠ (֓೦) 1. ϦϦʔεޙҰఆظؒ·Ͱٸܹʹ૿Ճ 2. ؇΍͔ʹݮগ 3. ޿ࠂ΍ίϥϘࢪࡦͰҰ࣌తʹ૿Ճ 2→3→2→3 Λ܁Γฦ͢ ଛӹ෼ذ఺ΛԼճΓ ҡ࣋Ͱ͖ͳ͘ͳΔͱαʔϏεऴྃ΁ ͲΕ͚ͩݮগΛ؇΍͔ʹͰ͖Δ͔Ͱ ण໋͕มΘͬͯ͘Δ

Slide 11

Slide 11 text

GvG (guild versus guild) ήʔϜͷಛੑ ϦϦʔε࣌఺Ͱ͸ͻͱͭͷϫʔϧυ͔͠ͳ͔ͬͨ GvG ήʔϜ = ରਓؒ(νʔϜ)ઓ ࢒͍ͬͯΔϢʔβʔ͸೥݄ͱͱ΋ʹͲΜͲΜڧ͘ͳ͍ͬͯ͘ • ৽نϢʔβʔ͕ೖͬͯ΋ͳ͔ͳ͔উͯͳ͍ • ͔ͤͬ͘ೖ͖ͬͯͯ͘Εͨ৽نϢʔβʔ͕ఆண͠ͳ͍ ݮগ͕Ճ଎͢ΔͱαʔϏε͕ҡ࣋Ͱ͖ͳ͍ 㱺 ·ͬ͞Βͳ৽نϫʔϧυΛ௥Ճ͠Α͏ʂ ৽نϢʔβʔ͕ઓ͑ΔੈքΛ༻ҙͯ͠ɺͦ͜Ͱఆணͯ͠΋Β͏

Slide 12

Slide 12 text

ϫʔϧυ௥Ճͷ࣮ࢪ ϦϦʔε͔Β1೥൒ޙɺ2016೥2݄ݕ౼։࢝ ׬શʹಠཱͨ͠σʔλϕʔεͱΞϓϦέʔγϣϯΛ௥Ճ͢Δ࣮૷ • Ϛελʔσʔλ(ΞΠςϜͳͲ)͸׬શʹಉҰ • ֤ϫʔϧυؒͰϢʔβʔσʔλͷҠߦ͸Ͱ͖ͳ͍ • ϓϨΠ͢ΔϫʔϧυΛҰ౓બ୒ͨ͠Β ผϫʔϧυͰ͸ϓϨΠͰ͖ͳ͍ • جຊతʹ֤ϫʔϧυͷαʔόʔؒͰ௨৴͸͠ͳ͍ (ྫ֎: σϓϩΠૢ࡞΍Redshift΁ͷΫΤϦ͸1Χॴ͔Βߦ͑Δ)

Slide 13

Slide 13 text

2016೥8݄ ৽ϫʔϧυ௥Ճ

Slide 14

Slide 14 text

͍͔ͭऴΘΔ͜ͱΛߟ͑ͯɺ௥Ճ௚ޙʹ౷߹ʹ͍ͭͯ΋ݕ౼͞Ε͍ͯͨ (͑Β͍)

Slide 15

Slide 15 text

ͦͯ͠2021೥ɺϫʔϧυʮ౷߹ʯ΁ αʔϏε։͔࢝Β6೥ɺϫʔϧυ௥Ճ͔Β΋4೥͕ܦա ϓϩσϡʔαʔஊʮ࣍͸10प೥Λ໨ࢦ͍ͨ͠ʯ ήʔϜͷಛੑ্ɺϓϨΠϠʔ͕ଟ͍΄͏͕໘ന͍ • ΞΫςΟϒͳνʔϜͱରઓͯ͠উͭ΄͏͕໘ന͍ • ৽Ϣʔβʔ͕ผʑͷϫʔϧυʹ഑ஔ͞ΕΔͱ૿͑ͮΒ͍ 㱺 ΞΫςΟϒͳϢʔβʔ਺ΛҰఆҎ্ʹอͭͨΊʹ ෼͔Ε͍ͯΔϫʔϧυΛ౷߹͍ͨ͠

Slide 16

Slide 16 text

ͱ͜ΖͰϫʔϧυ௥Ճ࣌ͷ࣮૷͸… ·ͬͨ͘ผͷγεςϜΛ ΋͏Ұݸཱͯͨঢ়ଶ ELB, ΞϓϦέʔγϣϯαʔό, Aurora, ElastiCache, ... Auroraʹೖ͍ͬͯΔσʔλͷID͸ AUTO_INCREMENT Ͱൃ൪ INSERT ͞ΕΔ͝ͱʹ1ͣͭࣗಈͰ૿͑ ͍ͯ͘஋͕ओΩʔ 㱺 ϫʔϧυA/BͰσʔλͷID͕ॏෳ

Slide 17

Slide 17 text

σʔλͷID͕ॏෳɺͱ͸ ͭ·Γ౷߹લ͸͜͏ • ϫʔϧυA/Bͷ player.id = 100͸ શ͘ͷผਓ • ϫʔϧυA/Bͷ player_item.id = 1000 ͸׬શʹผ෺ • player_item.player_id = 100 ͕ࢀর͢Δઌ(player.id)΋౰વผਓ Ͳ͏ͨ͠Β…

Slide 18

Slide 18 text

຅Ҋ • શͯͷσʔλΛϫʔϧυΛؚΊͨෳ߹ओΩʔʹ͢Δ ! ΞϓϦέʔγϣϯͷมߋൣғ͕େ͖͗͢Δ (ίʔυͱςετΛ߹Θͤͯ50ສߦఔ౓͋ΔͷͰ…) • ҠߦظؒΛઃ͚ͯͦΕͧΕͷϢʔβʔʹखଓ͖Λͯ͠΋Β͏ →Ϣʔβʔσʔλ୯ҐͰόονॲཧͰҠߦ ! ͦ͜Ͱڈͬͯ͠·͏Ϣʔβʔ͕େྔʹग़ΔՄೳੑ

Slide 19

Slide 19 text

ཁ݅ ʮϢʔβʔ͸Կ΋͠ͳ͍Ͱ΋ɺ৽͍͠ϫʔϧυͰήʔϜ͕ܧଓͰ͖Δʯ ݱঢ় • ֎෦ʹ಺෦ͷIDΛ࿐ग़͍ͯ͠Δͱ͜Ζ͸ͳ͍ • ͭ·Γ಺෦ͷID͸ɺ੔߹ੑ͕อ͍ͯͯΕ͹ผͷ஋ʹͯ͠Α͍ ͭ·Γ ֤ϫʔϧυʹଘࡏ͢ΔશϢʔβʔσʔλͷID(֎෦ࢀরؚΉ)Λ িಥ͠ͳ͍Α͏ʹ͢΂ͯॻ͖׵͑Ε͹Α͍ ຊ౰ʹ΍Δͷ…?

Slide 20

Slide 20 text

;ͨͭͷσʔλϕʔεΛͻͱͭʹ

Slide 21

Slide 21 text

ID ΛৼΓ௚͢ ϫʔϧυAͷϢʔβʔσʔλͷIDͱϫʔϧυBͷIDΛ ॏෳ͠ͳ͍Α͏ʹશͯ࠶ൃ൪͢Δ • ͻͱͭͷςʔϒϧʹ͸࠷େͰ਺ԯߦ • ͋ΔςʔϒϧͷID͸ଞͷςʔϒϧͷΧϥϜʹؚ·ΕΔ(֎෦ࢀর) • ςʔϒϧ਺500Ҏ্ • ༰ྔ͸2ϫʔϧυ߹ܭ1TBఔ౓ (Aurora snapshotͷαΠζͰ) ͜ΕΛશͯໃ६ͳ͘ॻ͖׵͑ͳ͍ͱ͍͚ͳ͍

Slide 22

Slide 22 text

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 ... ... ...

Slide 23

Slide 23 text

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……ͭΒͦ͏

Slide 24

Slide 24 text

! ౷߹ = shardingͷٯૢ࡞Ͱ͸…?

Slide 25

Slide 25 text

ҰൠతͳγϟʔσΟϯά γϟʔσΟϯά(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

Slide 26

Slide 26 text

ࠓճ͸෼ׂͰ͸ͳ͘౷߹ͳͷͰٯʹ͢Δ ϫʔϧυ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

Slide 27

Slide 27 text

SQLͰ΋αϒΫΤϦͳ͠Ͱ؆୯ܭࢉ UPDATE player SET id=(id * 2 + 1); UPDATE player_item SET id=(id * 2 + 1), player_id=(player_id * 2 + 1); ͢΂ͯͷม׵ޙͷIDΛ͋Β͔͡ΊܾఆతʹٻΊΒΕΔ IDৼΓ௚͠໰୊͸ղܾʂ (ͨͩ͠ʮٕज़తʹ͸Մೳʯঢ়ଶ)

Slide 28

Slide 28 text

Amazon Aurora Λ׆༻ͨ͠ ߴ଎ͳσʔλҠߦͱݕূ

Slide 29

Slide 29 text

σʔλͷ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೔ʙ਺೔Ϩϕϧ(ܦݧଇ) ϝϯςφϯε͸Ͱ͖Δ͚ͩ୹͍ͨ͘͠

Slide 30

Slide 30 text

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/

Slide 31

Slide 31 text

SELECT INTO OUTFILE S3 ͱ LOAD DATA FROM S3 1. ΫΤϦ݁ՌΛ Amazon S3 ʹ CSV ͱͯ͠ export 2. CSV Λ S3 ͔ΒಡΈࠐΜͰςʔϒϧʹ import ςʔϒϧ୯ҐͰฒྻॲཧ͕Մೳ Aurora 㱻 S3 ؒͰॲཧ͕׬݁

Slide 32

Slide 32 text

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Ұཡ͕هࡌ͞ΕΔϚχϑΣετϑΝΠϧΛग़ྗ͢Δ

Slide 33

Slide 33 text

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 Λ ࢦఆͯ͠औΓࠐΈ

Slide 34

Slide 34 text

ฒྻॲཧ͕Մೳ SELECT INTO OUTFILE S3 ͱ LOAD DATA FROM S3 ͸ ෳ਺ηογϣϯͰಉ࣌ʹൃߦՄೳ σʔλ͸ Aurora 㱻 S3 ؒͰ௚઀సૹ͞ΕΔ ΫΤϦൃߦݩʹ͸ෛՙֻ͕͔Βͳ͍ AuroraͷϚϧνίΞͱڧྗͳετϨʔδ S3 ͷྗΛଘ෼ʹ׆༻Ͱ͖Δʂ

Slide 35

Slide 35 text

෦෼తͳϦτϥΠΛ༰қʹ ςʔϒϧ୯ҐͰexport, import͢Δ ࣦഊΛݕ஌ͨ͠Βͦͷςʔϒϧ͚ͩϦτϥΠՄೳ λεΫΛࡉ͔͘෼ׂ + ฒྻ࣮ߦͰεϧʔϓοτΛՔ͙ 㱺 λεΫͷࣦഊΛલఏʹɺΫϥ΢υͷྗΛ׆༻͢Δ Α͘ͳ͍΍Γํͷྫ $ mysqldump -h src.host mydb | mysql -h dest.host EC2(ͳͲ)ͷ1୆ʹෛՙֻ͕͔Δ ్தͷͲ͔͜Ͱࣦഊ͢ΔͱϦτϥΠ͕ࠔ೉ Auroraଆ΋1ίΞ͔͠࢖͑ͳ͍

Slide 36

Slide 36 text

਺ඦςʔϒϧʹରͯ͠ SQL Λੜ੒͢Δ खͰ͸ແཧͳͷͰ Perl ͷεΫϦϓτͰ…… 1. show tables ͰςʔϒϧҰཡΛऔಘ 2. ࣄલʹચ͍ग़ͨ͠ςʔϒϧ໊ɺΧϥϜ໊Λݩʹ IDม׵͕ඞཁͳςʔϒϧʹ͍ͭͯ SELECT INTO OUTFILE S3 LOAD DATA FROM S3 ͷSQLΛੜ੒

Slide 37

Slide 37 text

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, # ...

Slide 38

Slide 38 text

෬ฌ JSON ΧϥϜ ʮจࣈྻܕͷΧϥϜʹJSON͕ೖ͍ͬͯͯID͕ຒ·͍ͬͯΔʯ MySQL5.6 ޓ׵ͩͬͨͨΊɺJSON ܕͰ͸ͳ͍ී௨ͷTEXTܕ Ҡߦ͕ඞཁͳର৅͸਺ςʔϒϧ͚ͩͩͬͨ(Α͔ͬͨ…) ΞϓϦέʔγϣϯͰಡΜͰॻ͖׵͑ΔରԠ

Slide 39

Slide 39 text

؆୯ͦ͏ʹॻ͖·͕ͨ͠… ҠߦεΫϦϓτ׬੒ʹ3ϲ݄ 2021-03-09 IDม׵ɺSQLΛग़ྗ͢ΔεΫϦϓτ։ൃ։࢝ (໿50ίϛοτ) 2021-06-14 ׬੒ ྫ֎͕ଟ͗͢ΔͨΊɺಈ͔ͯ͠͸ςετ(CI, QA) Λ܁Γฦͯ͠໰୊Λ௵͍ͯ͘͠ඞཁ͕͋ͬͨ

Slide 40

Slide 40 text

QAͱϦϋʔαϧ খ͍͞σʔλ͔ΒCI, QA؀ڥʹσʔλΛ౷߹͢ΔπʔϧΛ࡞੒ CI, QA(ਓྗ)Ͱ໰୊఺Λચ͍ग़͠ 㱺 QA͸10ճҎ্࣮ࢪͯ͠໰୊Λચ͍ग़ͨ͠ ຊ൪ͷεφοϓγϣοτ͔ΒAuroraΫϥελΛ෮ݩ export, import ΛεΫϦϓτͰ࣮ߦ ్த໰୊͕ى͖ͨΒεΫϦϓτΛमਖ਼ͯ͠΍Γͳ͓͠ ໰୊ͳ͘౷߹DB͕Ͱ͖ͨΒ QA ࣮ߦ ຊ൪σʔλͰ5,6ճϦϋʔαϧ

Slide 41

Slide 41 text

Կ౓΋ຊ൪ͷσʔλͰϦϋʔαϧ͢ΔͨΊʹ 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:..." // ←͚ͩ͜͜ॻ͖׵͑Δ // ...

Slide 42

Slide 42 text

ͦͷଞɺࡉ͔͍޻෉ͳͲ े਺ຊɺܭ3000ߦ΄ͲͷPerl script͕ੜΈग़͞Εͨ • ηΧϯμϦΠϯσοΫεΛ DROP, ADD ͢Δ SQLจ΋ੜ੒ • import࣌͸ηΧϯμϦΠϯσοΫε͕ͳ͍ํ͕ߴ଎ • importޙʹ·ͱΊͯ ADD INDEX ͢Δ • SELECT ࣌ʹ count(*) ͰҠߦର৅ͷߦ਺ΛϑΝΠϧʹه࿥ • LOAD ޙʹ count(*) ͨ݁͠Ռͱಥ͖߹ΘͤΔ • Ͳ͏ͯ͠΋ॏෳͯ͠͠·͏ϨίʔυΛͳΜͱ͔͢Δ • ֎෦αʔϏεͷID͕ه࿥͞Ε͍ͯΔςʔϒϧͰॏෳͳͲ • ΞϓϦέʔγϣϯཁ݅ʹैͬͯ৽͍͠΄͏Λ࢒͢ͳͲରॲ

Slide 43

Slide 43 text

Ϧϋʔαϧͷ݁Ռ export, import ͸ෳ਺ϓϩηεͰฒྻ࣮ߦ͢Δ Aurora(౷߹લ r5.4xlarge 16ίΞ, ౷߹ޙ r5.8xlarge 32ίΞ) ͱS3ͷੑೳΛҾ͖ग़ͨ͢Ί export 16ฒྻɺimport 32ฒྻͰ࣮ߦ ਺ඦGBͷIDॻ͖׵͑ͱσʔλҠߦ͕2࣌ؒͰ׬ྃʂ

Slide 44

Slide 44 text

ϦϋʔαϧͰൃ֮ͨ͠໰୊ importޙɺADD INDEX Λ32ฒྻͰ࣮ߦ͍ͯͨ͠ͱ͜Ζ… Aurora ͷۭ͖ϝϞϦ͕ރׇͯ͠ΫϥογϡˠϑΣΠϧΦʔόʔ ଴ͬͯ΋ճ෮͠ͳ͍ ฒྻ౓Λམͱͯ͠΋ރׇ͕؇΍͔ʹͳΔ͚ͩ ADD INDEX Λ൒෼΄Ͳ࣮ߦޙɺAuroraΠϯελϯεΛ࠶ىಈ ࠶ىಈޙʹ͸ϝϞϦ໰୊ͳ͠ ͕࣌ؒͳ͔ͬͨͨΊݪҼ௥ٴ͸ఘΊͯ࠶ىಈͰ৐Γ੾Δ͜ͱʹ

Slide 45

Slide 45 text

࣮ࡍͷ౷߹ϝϯςφϯε 2021-07-04(೔) 24:00 ϝϯςφϯε։࢝ 2021-07-05(݄) ऴ೔ϝϯςφϯε 2021-07-06(Ր) 10:00 ౷߹ϫʔϧυΦʔϓϯ ߹ܭ34࣌ؒͷϝϯςφϯε ࣮ͨͩ͠ಇ͸12࣌ؒఔ౓ ʲ໨ඪʳͪΌΜͱ৸Δ

Slide 46

Slide 46 text

࣮ࡍͷ౷߹ϝϯςφϯε(1೔໨) 2021-07-04(೔) 24:00 (ਂ໷0࣌) ϝϯςφϯε։࢝ 1. ֤ϫʔϧυͰεφοϓγϣοτऔಘ 2. εφοϓγϣοτ͔ΒҠߦ༻Ϋϥε λΛ෮ݩ 3. 01:30 AM ࠒ׬੒ͨ͠ͷͰղࢄ ݩͷΫϥελ͸ͦͷ··࢒͓ͯ͘͠ ࠷ѱɺ౷߹લͷঢ়ଶʹ੾Γ໭ͨ͢Ί

Slide 47

Slide 47 text

࣮ࡍͷ౷߹ϝϯςφϯε(2೔໨) 2021-07-05(݄) 09:00 export։࢝ 11:00 import׬ྃ 14:00 ࣄޙॲཧؚΊͯσʔλҠߦ׬ྃ 17:00 ಈ࡞֬ೝ׬ྃɻΞϓϦετΞެ։࡞ۀ 19:00 ղࢄ

Slide 48

Slide 48 text

࣮ࡍͷ౷߹ϝϯςφϯε(3೔໨) 2021-07-06(Ր) 09:00 ΞϓϦετΞެ։Λ֬ೝ 10:00 ϝϯςφϯεղআɻ౷߹ϫʔϧυͰΦʔϓϯ ࡉ͔͍໰୊͸͍͔ͭ͋ͬͨ͘΋ͷͷ σʔλҠߦʹ·ͭΘΔେ͖ͳ໰୊͸ൃੜͤͣ ແࣄނͰ׬ྃʂ ! ਭ຾΋͔ͬ͠ΓऔΕͨ

Slide 49

Slide 49 text

·ͱΊ ϦϦʔε͔Β7प೥Λܴ͑ͨʮ΅͘ΒͷߕࢠԂʂϙέοτʯͰ͸ ผʑͷσʔλϕʔεʹଘࡏ͍ͯͨ͠;ͨͭͷϫʔϧυΛ ͻͱͭʹ౷߹͠·ͨ͠ Amazon AuroraͷػೳΛ׆༻͢Δ͜ͱͰɺ ෳࡶͳॻ͖׵͑Λ൐͏େྔͷσʔλҠߦΛ ҆શʹ࣮ࢪ͢Δ͜ͱ͕Ͱ͖·ͨ͠ • Aurora㱻S3ؒͷσʔλίϐʔΛฒྻ࣮ߦͰߴ଎ʹ • εφοϓγϣοτ͔Βͷ෮ݩͰසൟͳϦϋʔαϧΛՄೳʹ