2024/12/17 ੡଄ϏδωεςΫϊϩδʔ෦ ࠤ౻ஐथ ͋ͷ೔Զୡ͕ເݟͨ αʔόϨεΞʔΩςΫνϟ

ࣗݾ঺հ !UNL !UPNPLJ • ࠤ౻ஐथ • ੡଄ϏδωεςΫϊϩδʔ෦ • ΞʔΩςΫτνʔϜ • JAWS-UG CDKࢧ෦ ӡӦ • ޷͖ͳAWSαʔϏε -BNCEB $%,

஫ҙɿ൒෼ϙΤϜͰ͢

ਅ໘໨ʹDSQLղઆ/΍ͬͯΈͨهࣄ https://dev.classmethod.jp/tags/amazon-aurora-dsql/ DevIOͰطʹAurora DSQLͷهࣄ͕14→17ຊʂਅ໘໨ͳ࿩͸ੋඇͦͪΒͰʂ

2020೥ͷࣗ෼ • స৬ͯ͠αʔόϨε΍͍ͬͯͥ͘ʂ • αʔόϨεͱ͍͑͹API Gateway+Lambda+DynamoDBͩʂ • ΞϓϦ͕ෳࡶʹͳ͖ͬͯͨͷͰDynamoDBͷઃܭݟ௚ͥ͢ʂ https://www.slideshare.net/slideshow/db-20190905/171086391

2020೥ͷࣗ෼ https://www.slideshare.net/slideshow/db-20190905/171086391

DynamoDBઃܭʹڽΓͩͨ͠ࡍͷ͋Δ͋Δ • ΞΫηεύλʔϯΛ੔ཧͯ͠GSIઃܭͩʂ • ඇਖ਼نԽͩʂଟରଟͷؔ܎Ͱྡ઀ؔ܎ͷ Ϧετઃܭύλʔϯͩʂ • γϯάϧςʔϒϧઃܭͩʂ • ొஃऀ͸Ϛϧνςʔϒϧઃܭ೿ • GSIΦʔόʔϩʔσΟϯάͩʂ https://docs.aws.amazon.com/ja_jp/amazondynamodb/ latest/developerguide/bp-gsi-overloading.html

DynamoDBΛ࢖͏৔߹ʹΑ͋͘ΔΞʔΩςΫνϟ AWS Lambda Amazon DynamoDB Amazon Aurora Amazon OpenSearch Service AWS Lambda Amazon DynamoDB AWS Lambda Amazon DynamoDB Amazon S3 ɾɾɾ ɾɾɾ ɾɾɾ

VPCϨεͰSQL΋࣮ߦͰ͖Δ ׬શͳαʔόϨεΞʔΩςΫνϟͰ ෼͔Γ΍͘͢γεςϜ૊Ίͳ͍͔ͳ

re:Invent 2020

re:Invent 2020 https://dev.classmethod.jp/articles/partiql-for-dynamodb-example/

2020೥தͷΞοϓσʔτ

re:Invent 2021 https://dev.classmethod.jp/articles/new-amazon-dynamodb-standard-infrequest-access-table-class/

re:Invent 2022

re:Invent 2023

re:Invent 2024

re:Invent 2024

re:Invent 2024

20 DB෦෼΋VPCϨεͰRDBMS͕ར༻Մೳͳ ͋ͷ೔Զୡ͕ເݟͨαʔόϨεΞʔΩςΫνϟ͕ͦ͜ʹ͋Δʂ Aurora DSQLͰߟ͑ΒΕΔΞʔΩςΫνϟ Amazon Aurora DSQL AWS Lambda γϯϓϧʂʂ

21 • PostgresͰ࢖͑Δػೳ͕ϚωʔδυԽ͢ΔͨΊʹ࠹͕Ε͍ͯΔɻ݁ߏ࢖͑ͳ͍ػೳ͕ ͋Δ(Foreign keys΍VIEWͳͲ)ɻORMʹඞཁͳػೳ͕࠹͕͍ͬͯͯ࢖͑ͳ͔ͬͨΓ • ָ؍తಉ࣮࣌ߦ੍ޚͳ͜ͱΛཧղͯ͠ΞϓϦଆΛઃܭ ஫ҙɿ·ͩ৭ʑ͜Ε͔Β https://dev.classmethod.jp/articles/re- growth-aws-re-invent-2024-awsreinvent- regrowth_fuk/ https://dev.classmethod.jp/articles/ reinvent-dsql-drizzle-lambda-migration/ https://dev.classmethod.jp/articles/ slug-KDrUpAFyxapQ/

ΈΜͳͰ࢖ͬͯϑΟʔυόοΫ͠Α͏ʂ

એ఻ ໌೔CDKࢧ෦Ͱࠓ೥ͷৼΓฦΓ΍Γ·͢ʂ connpassʹͯʮCDKʯͰݕࡧʂ

એ఻2 ձࣾͷํͰ΋Πϕϯτ΍Γ·͢ʂ ΦϯϥΠϯɾΦϑϥΠϯ྆ํ͋ΔͷͰੋඇʂ